Re: Query kills machine.

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: Query kills machine.
Дата
Msg-id
412B05A2.8070301@familyhealth.com.au
Ответ на
Query kills machine. (Stef)
Список
Дерево обсуждения
Query kills machine. Stef <svb@ucs.co.za>
Re: Query kills machine. Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Query kills machine. Stef <svb@ucs.co.za>
Re: Query kills machine. Tom Lane <tgl@sss.pgh.pa.us>
Re: Query kills machine. Stef <svb@ucs.co.za>
Re: Query kills machine. "Magnus Naeslund(t)" <mag@fbab.net>
Re: Query kills machine. "Magnus Naeslund(pg)" <mag-pg@fbab.net> 
For starters,


> ------------------------------------------------------------------------
> 
> shared_buffers = 110592
> wal_buffers = 400
> sort_mem = 30720
> vacuum_mem = 10240
> checkpoint_segments = 30
> commit_delay = 5000
> commit_siblings = 100
> effective_cache_size = 201413

Try more like this:

shared_buffers = 30000
wal_buffers = 
sort_mem = 4096
vacuum_mem = 10240
checkpoint_segments = 30
commit_delay = 
commit_siblings = 
effective_cache_size = 100000

Chris
В списке pgsql-performance по дате отправления
Предыдущее
От: Stef
Дата:
Сообщение: Query kills machine.
Следующее
От: Jan Wieck
Дата:
FAQ