> So looking for a good start as I start bringing up systems in Amazon,
AWS for performance.
Maybe useful information:
- "Amazon Web Services – RDBMS in the Cloud: PostgreSQL on AWS" (2013)
https://aws.amazon.com/whitepapers/postgresql-in-the-cloud/ Download
Whitepaper
I've found that pgtune doesn't quite provide the benefit that I would
like. It still uses large work mem and maintenance work mem numbers,
even though, up until now Postgres has an issue with large numbers of
tuples, so seems that smaller settings are better, in the 64MB type
range. (based on