On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <[EMAIL PROTECTED]> wrote: >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. Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html