On 2018-Aug-20, Fred Habash wrote: > How do we go about calculating appropriate values for these two parameters ... I don't know a lot about your system, so don't have anything to go on. Also, Aurora is mostly unknown to me. What did Amazon say? > > 'NUM_SUBTRANS_BUFFERS'? > TOTAL_MAX_CACHED_SUBXIDS > > And do both require a recompile? Yes. But maybe they'll just move the contention point a little bit backwards without actually fixing anything. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
