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 [EMAIL PROTECTED] 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
