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_buffercache, yes. SELECT count(*) FROM pg_buffercache WHERE relfilenode IS NOT NULL; should give you the number of non-empty buffers. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
