From: | Tory M Blue <tmblue(at)gmail(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | pgtune or similar to assist in initial settings |
Date: | 2016-07-12 00:34:53 |
Message-ID: | CAEaSS0a+f8XmBGGi0u_cd=O78s8dzDpYVwkh_1ucvMvpX6p8wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Imre Samu | 2016-07-12 20:03:55 | Re: pgtune or similar to assist in initial settings |
Previous Message | trafdev | 2016-07-09 17:26:34 | Re: less than 2 sec for response - possible? |