a == ajs@crankycanuck.ca 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.
--
Brandon