Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance tuning on RedHat Enterprise Linux 3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance tuning on RedHat Enterprise Linux 3
Date
Msg-id 1850.1102348398@sss.pgh.pa.us
Whole thread Raw
In response to Performance tuning on RedHat Enterprise Linux 3  ("David Esposito" <pgsql-general@esposito.newnetco.com>)
List pgsql-general
Tree view 
"David Esposito" <pgsql-general@esposito.newnetco.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

pgsql-general by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: select single entry and its neighbours using direct-acess to index?
Next
From: Stephan Szabo
Date:
Subject: Re: triggers, transactions and locks