Hi Stephen, Yes, we're completely hosted and although we're not running into massive performance issues but we were thinking if DB partitioning helps boost the performance a bit more, why not. Your response makes a whole lot of sense and I totally agree. This query was raised just to gain insights and understand the efforts vs. benefits. We'd be interested with just the custom tables, tbh. We've been informed Postgres is hosted on RDS and hence not possible but an internal ENH has been raised by...

Turns out there is not a single customer using partitioned Postgres database. Sadly, Adobe support says this is something that isn't supported by ACC as there are no cases available to answer our queries.Is there a way we could raise an exception request so they can try this out on their local sandbox to confirm this works well compared to un-partitioned data? Just trying to get partitioning certified by Adobe. -wALF

Thanks Joyti. Although the second link wasn't accessible, the first one summarizes some good tips that can be helpful. I can now check with Adobe Support for I was particularly looking for database partitioning. Before we could consider, I wanted to have a clear understanding on the benefits vs. efforts of doing so. -wALF

Great Cedric ... that worked well for us.

This certainly looks helpful. I shall try and revert on this.

Hi Greeshma,What Jon meant was, are all the recipients of the delivery in the Sent state or some of them in the Pending state? Secondly, the mta is required so please confirm if the mta service running?We see the same issue but for our triggered emails (Message Center) where the recipients appear in Sent or Ignored state on RT but Pending on the marketing instance. -Harshal