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  (Zev Benjamin <zev-pgsql@strangersgate.com>)
Re: Tuning 9.3 for 32 GB RAM  ("Tomas Vondra" <tv@fuzzy.cz>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: Tuning 9.3 for 32 GB RAM
Следующее
От: Dang Minh Huong
Дата:
Сообщение: Equivalent syntax of PL/SQL using array in PL/pgSQL