Thread: Shared buffers, Sort memory, Effective Cache Size

Shared buffers, Sort memory, Effective Cache Size

From
Frédéric Robinet
Date:
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@Mims.be


Re: Shared buffers, Sort memory, Effective Cache Size

From
Qing Zhao
Date:
Hello,

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.

Tnaks!

Qing
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@Mims.be
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


Re: Shared buffers, Sort memory, Effective Cache Size

From
Manfred Koizar
Date:
On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao@supplyfx.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