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
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
In response to Arnau [EMAIL PROTECTED]:
Hi all,
I have a server with 4GB of memory and I'm tweaking the PostgreSQL
configuration. This server will be dedicated to run PostgreSQL so I'd
like to dedicate as much as possible RAM to it.
I have dedicated 1GB to shared_buffers
Marcelo Costa wrote:
Hi, to all!
Recently i try increasing the memory values of shared buffers on one
IBM xseries 255 (Quad XEON 2.8, 8 GB RAM, 2 disk SCSI 36 GB(Raid 1), 1
Storage.
You haven't specified your OS so I am going to assume Linux.
Where I start up the cluster very messages of
Yes, my system is DEBIAN SARGE 3.0thanks,Marcelo2006/10/2, Joshua D. Drake [EMAIL PROTECTED]:
Marcelo Costa wrote: Hi, to all! Recently i try increasing the memory values of shared buffers on one IBM xseries 255 (Quad XEON 2.8, 8 GB RAM, 2 disk SCSI 36 GB(Raid 1), 1 Storage.
You haven't specified
On Thu, Oct 27, 2005 at 06:39:33PM -0400, Ron Peacetree wrote:
Databases basically come in 4 sizes:
1= The entire DB fits into memory.
2= The performance critical table(s) fit(s) into memory
3= The indexes of the performance critical table(s) fit into memory.
4= Neither the performance
