On Fri, 16 Jan 2004, Anjan Dave wrote:
> 68 processes: 67 sleeping, 1 running, 0 zombie, 0 stopped
> CPU0 states: 3.1% user 4.4% system0.0% nice 0.0% iowait 92.0%
> idle
> CPU1 states: 0.0% user 3.2% system0.0% nice 0.0% iowait 96.3%
> idle
> CPU2 states: 0.4% user 0.3% s
, each at an RSS of about 87MB...
Thanks,
anjan
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 7:52 PM
To: Anjan Dave
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] shared_buffer value
"Anjan Dave" <[EMAIL PROTECTED]> writes:
"Anjan Dave" <[EMAIL PROTECTED]> writes:
> Question is, does the 80MB buffer allocation correspond to ~87MB per
> postmaster instance? (with about 100 instances of postmaster, that will
> be about 100 x 80MB =3D 8GB??)
Most likely, top is counting some portion of the shared memory block
against ea
On Thursday 15 January 2004 22:49, Anjan Dave wrote:
> Gurus,
>
> I have defined the following values on a db:
>
> shared_buffers = 10240 # 10240 = 80MB
> max_connections = 100
> sort_mem = 1024 # 1024KB is 1MB per operation
> effective_cache_size = 262144 # equals to 2GB
Title: Message
Gurus,
I have defined the
following values on a db:
shared_buffers =
10240 # 10240 = 80MB
max_connections = 100
sort_mem =
1024
# 1024KB is 1MB per operation
effective_cache_size = 262144 # equals
to 2GB for 8k pages
Rest of the values
are
