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 | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend