Re: [PERFORM] High load average with PostgreSQL 7.4.2 on debian/ibm eserver.

2004-07-18 Thread Gaetano Mendola
[EMAIL PROTECTED] wrote: Whole config is available here: http://ludojad.itpp.pl/~eleven/pg-high-load.conf effective_cache_size = 4000 # typically 8KB each #random_page_cost = 4 # units are one sequential page fetch cost #cpu_tuple_cost = 0.01 # (same) #cpu_index_tuple_cost =

Re: [PERFORM] High load average with PostgreSQL 7.4.2 on debian/ibm eserver.

2004-06-29 Thread eleven
On Tue, Jun 29, 2004 at 09:17:36AM -0700, Marc wrote: Performance issue, I'm experiencing here, is somewhat weird - server gets high average load (from 5 up to 15, 8 on average). Standard performance monitoring utilities (like top) show that CPUs are not loaded (below 20%, often near

Re: [PERFORM] High load average with PostgreSQL 7.4.2 on debian/ibm eserver.

2004-06-29 Thread Josh Berkus
Eleven, In particular - could someone tell me if those iostat values can tell if I'm close to upper performance boundary of fast SCSI (Ultra 320, 15k RPM) disks? It's quite possible that you need to improve your disk array; certainly I would have spec'd a lot more disk than you're using