Hi, list. I've just upgraded pgsql from 8.3 to 8.4. I've used pgtune
before and everything worked fine for me.
And now i have ~93% cpu load. Here's changed values of config:
default_statistics_target = 50
maintenance_work_mem = 1GB
constraint_exclusion = on
checkpoint_completion_target = 0.9
effective_cache_size = 22GB
work_mem = 192MB
wal_buffers = 8MB
checkpoint_segments = 16
shared_buffers = 7680MB
max_connections = 80
My box is Nehalem 2xQuad 2.8 with RAM 32Gb, and there's only
postgresql working on it.
For connection pooling i'm using pgbouncer's latest version with
pool_size 20 (used 30 before, but now lowered) and 10k connections.
What parameters i should give more attention on?
pgsql-performance by date
|Next:||From: Suvankar Roy||Date: 2009-07-30 12:24:46|
|Subject: Greenplum MapReduce|
|Previous:||From: Doug Hunley||Date: 2009-07-29 16:47:31|
|Subject: autovacuum 'stuck' ?|