Re: [HACKERS] Extrordinarily Poor Performance....

2001-05-03 Thread Trond Eivind Glomsrød
Lamar Owen <[EMAIL PROTECTED]> writes: > Ryan Mahoney wrote: > > Any input would be helpful! If you need additional info let me know. > > > BTW, Thanks to Lamar for some great tips today! > > You're more than welcome. > > I forgot a basic tip, which leads to a question: > How often are you r

Re: [HACKERS] Extrordinarily Poor Performance....

2001-05-03 Thread Lamar Owen
Ryan Mahoney wrote: > Any input would be helpful! If you need additional info let me know. > BTW, Thanks to Lamar for some great tips today! You're more than welcome. I forgot a basic tip, which leads to a question: How often are you running VACUUM ANALYZE? If this were PostgreSQL 7.0.3, we

Re: [HACKERS] Extrordinarily Poor Performance....

2001-05-03 Thread Bruce Momjian
I hope you have those postmasters listening on different ports. > Here is some output from top... > > 9:20pm up 40 min, 1 user, load average: 3.77, 3.12, 3.74 > 41 processes: 36 sleeping, 5 running, 0 zombie, 0 stopped > CPU states: 99.2% user, 0.7% system, 0.0% nice, 0.0% idle > Mem: 5

Re: [HACKERS] Extrordinarily Poor Performance....

2001-05-03 Thread Ryan Mahoney
Here is some output from top... 9:20pm up 40 min, 1 user, load average: 3.77, 3.12, 3.74 41 processes: 36 sleeping, 5 running, 0 zombie, 0 stopped CPU states: 99.2% user, 0.7% system, 0.0% nice, 0.0% idle Mem: 515664K av, 303712K used, 211952K free, 37476K shrd, 39552K buff Swap: 5