Thursday, May 29, 2008

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 4:52 PM, Dave Page <dpage@pgadmin.org> wrote:
> On Thu, May 29, 2008 at 4:45 PM, Justin <justin@emproshunts.com> 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

No comments: