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
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.Lu||Date: 2006-07-06 08:49:33|
|Previous:||From: Chethana, Rao (IE10)||Date: 2006-07-06 08:15:07|
|Subject: Re: unsubscribe|