X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4EB9153379 for ; Wed, 23 Mar 2005 16:58:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47400-06 for ; Wed, 23 Mar 2005 16:58:11 +0000 (GMT) Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by svr1.postgresql.org (Postfix) with SMTP id C2B675357B for ; Wed, 23 Mar 2005 16:58:09 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@216.75.167.195 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 23 Mar 2005 16:58:08 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id A092D3D2F; Wed, 23 Mar 2005 11:58:07 -0500 (EST) Date: Wed, 23 Mar 2005 11:58:07 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: PostgreSQL on Solaris 8 and ufs Message-ID: <20050323165807.GB26236@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <1111525423.9054.16.camel@lanshark.dmv.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/492 X-Sequence-Number: 11197 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