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
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
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
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
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
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
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
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
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
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'
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
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
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
13 matches
Mail list logo