Re: First query is slow, subsequent queries fast

Поиск
Список
Период
Сортировка
От Stephan Vollmer
Тема Re: First query is slow, subsequent queries fast
Дата
Msg-id 43972B01.3070709@gmx.de
обсуждение исходный текст
Ответ на Re: First query is slow, subsequent queries fast  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-performance
Hi Oleg, thanks for your quick reply!

Oleg Bartunov wrote:

> you cache is too low :) Try to increase shared_buffers, for example,
> for 2Gb I'd set it to 100,000

Ok, I set shared_buffers to 100000 and indeed it makes a big
difference. Other queries than the ones I mentioned are faster, too.

Thanks very much for your help,

- Stephan

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: High context switches occurring
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Join the same row