On Thu, May 29, 2008 at 4:52 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 4:45 PM, Justin <[EMAIL PROTECTED]> wrote: >> >> Then what is the purpose of shared buffers if nothing is being reused is it >> only used to keep track locks, changes and what is to being spooled to the >> kernel??? > > It caches disk pages (and holds other data structures), not query results.
Oops, misread that. Shared *buffers* is disk pages. Shared memory holds the buffers and other stuff as well. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers