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

Re: Shared buffers, Sort memory, Effective Cache Size

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Qing Zhao <qzhao(at)supplyfx(dot)com>
Cc: Frédéric Robinet <Fr(at)Mims(dot)be>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Shared buffers, Sort memory, Effective Cache Size
Date: 2004-04-27 12:12:20
Message-ID: acjs80tbjoqf9gktcm8l3qrs8g0614j7ss@email.aon.at (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao(at)supplyfx(dot)com>
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

In response to

pgsql-performance by date

Next:From: AteszDate: 2004-04-27 12:54:27
Subject: Re: planner/optimizer question
Previous:From: Dave CramerDate: 2004-04-27 11:59:47
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the

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