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

Re: Shared buffers, Sort memory, Effective Cache Size

From: Qing Zhao <qzhao(at)supplyfx(dot)com>
To: Frédéric Robinet <Fr(at)Mims(dot)be>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Shared buffers, Sort memory, Effective Cache Size
Date: 2004-04-21 17:01:30
Message-ID: (view raw or whole thread)
Lists: pgsql-performance

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.


On Apr 21, 2004, at 9:29 AM, Frédéric Robinet wrote:

> Hello,
> I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL 
> 7.4
> running on.  What are the bests settings for shared buffers, sort 
> memory and
> effective cache size?
> My main database have a small/mid range size: some tables may have 1 
> or 2
> millions of records.
> Thanks
> Frédéric Robinet
> Fr(at)Mims(dot)be
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to


pgsql-performance by date

Next:From: Josh BerkusDate: 2004-04-21 17:29:43
Subject: Re: Wierd context-switching issue on Xeon
Previous:From: Frédéric RobinetDate: 2004-04-21 16:29:06
Subject: Shared buffers, Sort memory, Effective Cache Size

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