Skip site navigation (1) Skip section navigation (2)

PostgreSQL 8.4 performance tuning questions

From: Rauan Maemirov <rauan(at)maemirov(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL 8.4 performance tuning questions
Date: 2009-07-30 12:06:40
Message-ID: c78bcec0907300506l21939a18y1f2d3d83656070da@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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?

Responses

pgsql-performance by date

Next:From: Suvankar RoyDate: 2009-07-30 12:24:46
Subject: Greenplum MapReduce
Previous:From: Doug HunleyDate: 2009-07-29 16:47:31
Subject: autovacuum 'stuck' ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group