Re: pgtune or similar to assist in initial settings

> 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 <http://media.amazonwebservices.com/AWS_RDBMS_PostgreSQL.pdf>

-" Amazon EBS Volume Performance on Linux Instances"
http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSPerformance.html

Imre

2016-07-12 2:34 GMT+02:00 Tory M Blue <tmblue(at)gmail(dot)com>:

> 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 feedback from this list in the past and testing of
> larger numbers on dedicated systems).
>
> Also I've found no benefit to larger Effective cache numbers in boxen
> dedicated to postgres.
>
> So looking for a good start as I start bringing up systems in Amazon,
> AWS for performance.
>
> pgtune is a great idea, but it's numbers seem to be based on what
> should be, vs what is..
>
> I'm currently on CentOS6 and 9.4.5
>
> Hardware specs of the AWS systems are 8 cpu/60 GB, I may bump that to
> a 16/122gb, but trying to control costs and I know going from 8 to 32
> yielded almost 0, my biggest gain was memory but even then I don't
> think I've got settings correct.
>
> Thanks
> Tory
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>