From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim C. Nasby <decibel@decibel.org>
Cc: Joel Fradkin <jfradkin@wazagua.com>
Cc: PostgreSQL Perform <pgsql-performance@postgresql.org>
Subject: Re: Configing 8 gig box.
Date: Wed, 11 May 2005 00:10:36 -0400
Message-ID: <29857.1115784636@sss.pgh.pa.us> (raw)
In-Reply-To: <20050510214531.GP31103@decibel.org>
References: <006c01c554d9$7d701120$797ba8c0@jfradkin>
<20050510214531.GP31103@decibel.org>
"Jim C. Nasby" <decibel@decibel.org> writes:
> On Mon, May 09, 2005 at 04:55:53PM -0400, Joel Fradkin wrote:
>> Seems to be only using like 360 meg out of 7 gig free (odd thing is I did
>> see some used swap 4k out of 1.9) with a bunch of users (this may be normal,
>> but it is not going overly fast so thought I would ask).
> This is perfectly normal. Each postgresql backend will only report
> memory usage roughly equal to shared_buffers plus the size of the code
> (16M or so?). If it's in the middle of a sort or vacuum, it will use
> more memory.
One thing to note is that depending on which Unix variant you are using,
top may claim that any particular backend process is using the portion
of shared memory that it's actually physically touched. This means that
the claimed size of a backend process will grow as it runs (and randomly
needs to touch pages that are in different slots of the shared-memory
buffers) regardless of any actual objective growth in memory needs.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, decibel@decibel.org, jfradkin@wazagua.com
Subject: Re: Configing 8 gig box.
In-Reply-To: <29857.1115784636@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox