From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL on Solaris 8 and ufs
Date: Wed, 23 Mar 2005 11:58:07 -0500
Message-ID: <20050323165807.GB26236@phlogiston.dyndns.org> (raw)
In-Reply-To: <Pine.LNX.4.58L.0503221506440.24435@cash.rhiamet.com>
References: <Pine.LNX.4.58L.0503221439160.24435@cash.rhiamet.com>
<1111525423.9054.16.camel@lanshark.dmv.com>
<Pine.LNX.4.58L.0503221506440.24435@cash.rhiamet.com>
On Tue, Mar 22, 2005 at 03:23:18PM -0600, Brandon Metcalf wrote:
> s> What are you using to measure
> s> performance?
>
> Nothing too scientific other than the fact that since we have moved
> the DB, we consistenly see a large number of postmater processes
> (close to 100) where before we did not.
What did you move from? The Solaris ps (not in ucb, which is the
BSD-style ps) shows the parent process name, so everything shows up
as "postmaster" rather than "postgres". There's always one back end
per connection.
If you are in fact using more connections, by the way, I can tell you
that Solaris 8, in my experience, is _very bad_ at managing context
switches. So you may not be merely I/O bound (although your other
reports seem to indicate that you are).
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: PostgreSQL on Solaris 8 and ufs
In-Reply-To: <20050323165807.GB26236@phlogiston.dyndns.org>
References: <Pine.LNX.4.58L.0503221439160.24435@cash.rhiamet.com> <1111525423.9054.16.camel@lanshark.dmv.com> <Pine.LNX.4.58L.0503221506440.24435@cash.rhiamet.com> <20050323165807.GB26236@phlogiston.dyndns.org>
* 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