Re: work_mem and shared_buffers

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: work_mem and shared_buffers
Дата
Msg-id 1195396179.4217.1.camel@ebony.site
обсуждение исходный текст
Ответ на Re: work_mem and shared_buffers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: work_mem and shared_buffers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
On Fri, 2007-11-09 at 13:12 -0600, Scott Marlowe wrote:

> Note that my best time was at around 16 Meg work_mem.  This data set
> is MUCH bigger than 16 Meg, it's around 300-400 Meg.  But work_mem
> optimized out at 16 Meg.  Btw, I tried it going as high as 768 Meg,
> and it was still slower than 16M.

Remember that what you have shown is that for *this* dataset 16Mb is the
optimum value. It is not a recommended value for all cases.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Performance problem (outer join + view + non-strict functions)‏
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: work_mem and shared_buffers