On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao(at)supplyfx(dot)com>
>I have recently configured my PG7.3 on a G5 (8GB RAM) with
>shmmax set to 512MB and shared_buffer=50000, sort_mem=4096
>and effective cache size = 10000. It seems working great so far but
>I am wondering if I should make effctive cache size larger myself.
Yes, much larger! And while you are at it make shared_buffers smaller.
In response to
pgsql-performance by date
|Next:||From: Atesz||Date: 2004-04-27 12:54:27|
|Subject: Re: planner/optimizer question|
|Previous:||From: Dave Cramer||Date: 2004-04-27 11:59:47|
|Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the|