Shared buffers, Sort memory, Effective Cache Size

From: Frédéric Robinet <Fr(at)Mims(dot)be>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Shared buffers, Sort memory, Effective Cache Size
Date: 2004-04-21 16:29:06
Message-ID: 009901c427bd$c4752410$c601a8c0@MIMS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Mims(dot)be

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Qing Zhao 2004-04-21 17:01:30 Re: Shared buffers, Sort memory, Effective Cache Size
Previous Message Chris Hoover 2004-04-21 16:24:35 Re: Help understanding stat tables