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.
pgsql-performance by date
|Next:||From: Qing Zhao||Date: 2004-04-21 17:01:30|
|Subject: Re: Shared buffers, Sort memory, Effective Cache Size|
|Previous:||From: Chris Hoover||Date: 2004-04-21 16:24:35|
|Subject: Re: Help understanding stat tables|