Le 02/04/2010 22:10, Campbell, Lance a écrit :
> Greg,
> Thanks for your help.
>
> 1) How does the number of buffers provided by pg_buffercache compare to
> memory (buffers * X = Y meg)?
1 buffer is 8 KB.
> 2) Is there a way to tell how many total buffers I have available/max?
With pg_bufferc
217-333-0382
-Original Message-
From: Greg Smith [mailto:g...@2ndquadrant.com]
Sent: Monday, March 29, 2010 11:54 AM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How much memory is PostgreSQL using
Campbell, Lance wrote:
>
> Or is there some way
Campbell, Lance wrote:
Or is there some way to ask PostgreSQL how much memory are you using
to cache disk blocks currently?
You can install contrib/pg_buffercache into each database and count how
many used blocks are there. Note that running queries using that
diagnostic tool is really i
