Postgres Pro
Downloads
Home   >   mailing lists

Re: work_mem and shared_buffers - Mailing list pgsql-performance

From Simon Riggs
Subject Re: work_mem and shared_buffers
Date
Msg-id 1195396179.4217.1.camel@ebony.site
Whole thread Raw
In response to Re: work_mem and shared_buffers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: work_mem and shared_buffers
List pgsql-performance
Tree view 
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 by date:

Previous
From: Dean Rasheed
Date:
Subject: Performance problem (outer join + view + non-strict functions)‏
Next
From: "Scott Marlowe"
Date:
Subject: Re: work_mem and shared_buffers