Le 02/04/2010 22:10, Campbell, Lance a écrit :
> 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_buffercache, yes.
WHERE relfilenode IS NOT NULL;
should give you the number of non-empty buffers.