Thursday, May 29, 2008

Re: [HACKERS] [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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: