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