Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group