Re: [PERFORM] Memory question on win32 systems

On Thu, 29 May 2008, Justin wrote:

> I'm confussed trying to figure out how caches are being use and being 
> moving through postgresql backend.

The shared_buffers cache holds blocks from the database files.  That's it. 
If you want some more information about how that actually works head to 
http://www.westnet.com/~gsmith/content/postgresql/ and read "Inside the 
PostgreSQL Buffer Cache".

The work memory allocated for sorting is separate from that, and it 
doesn't cache anything.  It just provides working room for a query that's 
being executed right now.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD