Re: Tuning 9.3 for 32 GB RAM
| От | Alexander Farber |
|---|---|
| Тема | Re: Tuning 9.3 for 32 GB RAM |
| Дата | |
| Msg-id | CAADeyWhE=0vvX-zoENPH+XAsr+-0fSAyCpg2TjCp_1YY6oHVGg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Tuning 9.3 for 32 GB RAM (Alexander Farber <alexander.farber@gmail.com>) |
| Ответы |
Re: Tuning 9.3 for 32 GB RAM
Re: Tuning 9.3 for 32 GB RAM |
| Список | pgsql-general |
pgtune has produced the following for my server (the specs: http://www.hetzner.de/en/hosting/produkte_rootserver/px60ssd ):
default_statistics_target = 50
maintenance_work_mem = 1GB
constraint_exclusion = on
checkpoint_completion_target = 0.9
effective_cache_size = 22GB
work_mem = 192MB
wal_buffers = 8MB
checkpoint_segments = 16
shared_buffers = 7680MB
max_connections = 80
Is it really okay? Isn't 22GB too high?
And how does it know that max_connections =80 is enough in my case? (I use pgbouncer).
Regards
Alex
On Thu, Nov 14, 2013 at 4:04 PM, Alexander Farber <alexander.farber@gmail.com> wrote:
And pgtune is 4 years old...
В списке pgsql-general по дате отправления: