effective_cache_size X shared_buffer

Поиск
Список
Период
Сортировка
От Patrick B
Тема effective_cache_size X shared_buffer
Дата
Msg-id CAJNY3itO1rTAtVQWadU6KcDbXrWiYFXOF7QX+Hnt2FTuDsGqyw@mail.gmail.com
обсуждение исходный текст
Ответы Re: effective_cache_size X shared_buffer  (Patrick B <patrickbakerbr@gmail.com>)
Re: effective_cache_size X shared_buffer  (Venkata B Nagothi <nag1010@gmail.com>)
Список pgsql-general
Hi guys.

I'm thinking about increasing the query cache for my PG 9.2 server.
I've got a project happening, which is doing lots and lots of writes and reads during the night, and in the morning I see PG cache warming up again, as all the cache "was used" by those write and read tasks.

So my environment gets very slow for a few hours, until the queries used on a daily basis go to the cache.

Question:
Should I increase effective_cache_size or shared_buffer? What's the difference between them?

Thanks
Patrick

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Merging records in a table with 2-columns primary key
Следующее
От: Patrick B
Дата:
Сообщение: Re: effective_cache_size X shared_buffer