Shared buffers, Sort memory, Effective Cache Size - Mailing list pgsql-performance

From Frédéric Robinet
Subject Shared buffers, Sort memory, Effective Cache Size
Date
Msg-id 009901c427bd$c4752410$c601a8c0@MIMS
Whole thread Raw
Responses Re: Shared buffers, Sort memory, Effective Cache Size  (Qing Zhao <qzhao@supplyfx.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Chris Hoover"
Date:
Subject: Help understanding stat tables
Next
From: "Chris Hoover"
Date:
Subject: Re: Help understanding stat tables