On 7/6/06, A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx> wrote:
am 06.07.2006, um 9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes: > In postgresql.conf I have these settings: > > shared_buffers = 40000 > work_mem = 8192 > maintenance_work_mem = 16384 > max_stack_depth = 2048 > > all other settings are left by default (except ones needed for pg_autovacuum). > > Is there anything I can tune to get better performance? You can set "log_min_duration_statement" to log slow querys and then analyse this querys.
When you collect your logs try PgFouine http://pgfouine.projects.postgresql.org/ to understand what queries should be optimized and what's the reason of poor performance.
