On 2018-Aug-17, Fred Habash wrote: > Aurora Postgres 9.6.3 Oh, okay, I don't know this one. Did you contact Amazon support? > So, no chance to recompile (AFAIK). > Is there a design anti-pattern at the schema or data access level that we > should look for and correct? Maybe ... > And as for the recompile, are you thinking 'NUM_SUBTRANS_BUFFERS'? Yes, that's one option, but there's also TOTAL_MAX_CACHED_SUBXIDS. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
