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: | 8937BC90-93B5-11D8-AC12-000A95AB8896@supplyfx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)Mims(dot)be
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-04-21 17:29:43 | Re: Wierd context-switching issue on Xeon |
Previous Message | Frédéric Robinet | 2004-04-21 16:29:06 | Shared buffers, Sort memory, Effective Cache Size |