Обсуждение: Shared buffers, Sort memory, Effective Cache Size
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
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 >
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