From: David Brain <dbrain@bandwidth.com>
To: pgsql-performance@postgresql.org
Subject: Potential memory usage issue
Date: Thu, 22 Mar 2007 08:08:25 -0400
Message-ID: <460271B9.8050600@bandwidth.com> (raw)
Hi,
I recently migrated one of our large (multi-hundred GB) dbs from an
Intel 32bit platform (Dell 1650 - running 8.1.3) to a 64bit platform
(Dell 1950 - running 8.1.5). However I am not seeing the performance
gains I would expect - I am suspecting that some of this is due to
differences I am seeing in reported memory usage.
On the 1650 - a 'typical' postmaster process looks like this in top:
5267 postgres 16 0 439m 427m 386m S 3.0 21.1 3:31.73 postmaster
On the 1940 - a 'typical' postmaster process looks like:
10304 postgres 16 0 41896 13m 11m D 4 0.3 0:11.73 postmaster
I currently have both systems running in parallel so the workloads will
be approximately equal. The configurations of the two systems in terms
of postgresql.conf is pretty much identical between the two systems, I
did make some changes to logging, but nothing to buffers/shared memory
config.
I have never seen a postmaster process on the new system consume
anywhere near as much RAM as the old system - I am wondering if there is
something up with the shared memory config/usage that is causing my
performance issues. Any thoughts as to where I should go from here?
Thanks,
David.
--
David Brain - bandwidth.com
dbrain@bandwidth.com
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: dbrain@bandwidth.com
Subject: Re: Potential memory usage issue
In-Reply-To: <460271B9.8050600@bandwidth.com>
* 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