Re: [PERFORM] How much memory is PostgreSQL using

2010-04-03 Thread Guillaume Lelarge
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

Re: [PERFORM] How much memory is PostgreSQL using

2010-04-02 Thread Campbell, Lance
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

Re: [PERFORM] How much memory is PostgreSQL using

2010-03-29 Thread Greg Smith
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

[PERFORM] How much memory is PostgreSQL using

2010-03-29 Thread Campbell, Lance
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 l

Re: [PERFORM] How much memory PostgreSQL is going to use?

2007-06-12 Thread Bill Moran
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

[PERFORM] How much memory PostgreSQL is going to use?

2007-06-12 Thread Arnau
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 (shared_buffers=131072) but I'm not sure if this will be

Re: [PERFORM] How much memory in 32 bits Architecture to Shared Buffers is Possible

2006-10-02 Thread Marcelo Costa
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 spec

Re: [PERFORM] How much memory in 32 bits Architecture to Shared Buffers

2006-10-02 Thread Joshua D. Drake
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 message

[PERFORM] How much memory in 32 bits Architecture to Shared Buffers is Possible

2006-10-02 Thread Marcelo Costa
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. I try change these shared memory values to use 25% of memory ram (2048 MB) and effective_cache_size to 50% (4096 MB) of memory. All thi

Re: [PERFORM] How much memory?

2005-10-28 Thread Alex Turner
Reasons not to buy from Sun or Compaq - why get Opteron 252 when a 240 will do just fine for a fraction of the cost, which of course they don't stock, white box all the way baby ;). My box from Sun or Compaq or IBM is 2x the whitebox cost because you can't buy apples to apples. We have a bitchin'

Re: [PERFORM] How much memory?

2005-10-27 Thread Jim C. Nasby
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

Re: [PERFORM] How much memory?

2005-10-27 Thread Ron Peacetree
nt: Oct 27, 2005 3:31 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] How much memory? Is there a rule-of-thumb for determining the amount of system memory a database requres (other than "all you can afford")? ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PERFORM] How much memory?

2005-10-27 Thread PostgreSQL
Is there a rule-of-thumb for determining the amount of system memory a database requres (other than "all you can afford")? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings