Re: Vacuums on large busy databases

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Vacuums on large busy databases
Дата
Msg-id cone.1158255415.91768.31944.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Vacuums on large busy databases  (Francisco Reyes <lists@stringsutils.com>)
Ответы Re: Vacuums on large busy databases  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-performance
Dave Cramer writes:

> What is effective_cache set to ?

Increasing this seems to have helped significantly a web app. Load times
seem magnitudes faster.

Increased it to effective_cache_size = 12288 # 96MB

What is a reasonable number?
I estimate I have at least 1 to 2 GB free of memory.

Don't want to get too carried away right now with too many changes.. because
right now we have very few connections to that database (usually less than
10), but I expect it to go to a norm of 20+.. so need to make sure I won't
make changes that will be a problem in that scenario.

So far only see one setting that can be an issue: work_mem
so  have it set to only 32768.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Vacuums on large busy databases
Следующее
От: "Craig A. James"
Дата:
Сообщение: RAID 0 not as fast as expected