a == [EMAIL PROTECTED] writes:

 a> On Tue, Mar 22, 2005 at 03:23:18PM -0600, Brandon Metcalf wrote:
 a> >  s> What are you using to measure
 a> >  s> performance?
 a> >
 a> > Nothing too scientific other than the fact that since we have moved
 a> > the DB, we consistenly see a large number of postmater processes
 a> > (close to 100) where before we did not.

 a> What did you move from?  The Solaris ps (not in ucb, which is the
 a> BSD-style ps) shows the parent process name, so everything shows up
 a> as "postmaster" rather than "postgres".  There's always one back end
 a> per connection.

 a> If you are in fact using more connections, by the way, I can tell you
 a> that Solaris 8, in my experience, is _very bad_ at managing context
 a> switches.  So you may not be merely I/O bound (although your other
 a> reports seem to indicate that you are).

We moved from an HP-UX 10.20 box where the pgsql installation and data
were on a vxfs fileystem.

And we're definitely seeing more connections at a time which indicates
that each process is taking longer to complete.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to