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,
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 to ask
PostgreSQL 8.4.3
OS: Linux Red Hat 4.x
I changed my strategy with PostgreSQL recently to use a large segment of
memory for shared buffers with the idea of caching disk blocks. How can
I see how much memory PostgreSQL is using for this?
I tried:
ps aux | grep post | sort -k4
This
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