Re: Performance tuning on RedHat Enterprise Linux 3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Esposito" <pgsql-general(at)esposito(dot)newnetco(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance tuning on RedHat Enterprise Linux 3
Date: 2004-12-06 15:53:18
Message-ID: 1850.1102348398@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Esposito" <pgsql-general(at)esposito(dot)newnetco(dot)com> writes:
> New Box:
> shared_buffers = 131072 (roughly 1GB)

This setting is an order of magnitude too large. There is hardly any
evidence that it's worth setting shared_buffers much above 10000.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-12-06 15:59:04 Re: triggers, transactions and locks
Previous Message Pierre-Frédéric Caillaud 2004-12-06 15:51:00 Re: select single entry and its neighbours using direct-acess to index?