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

Re: getting better performance

From: "Ivan Zolotukhin" <ivan(dot)zolotukhin(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: getting better performance
Date: 2006-07-06 08:48:09
Message-ID: 751e56400607060148vc8186ffpe580c4741ce942fd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 7/6/06, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> 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.

In response to

pgsql-performance by date

Next:From: Monique.LuDate: 2006-07-06 08:49:33
Subject: unsubscribe
Previous:From: Chethana, Rao (IE10)Date: 2006-07-06 08:15:07
Subject: Re: unsubscribe

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