Re: [PERFORM] pgtune or similar to assist in initial settings

2016-07-12 Thread Imre Samu
> 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

[PERFORM] pgtune or similar to assist in initial settings

2016-07-11 Thread Tory M Blue
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