From: Josh Berkus <josh@agliodbs.com>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Ron <rstpierre@syscor.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql.conf
Date: Wed, 30 Jul 2003 13:42:24 -0700
Message-ID: <200307301342.24321.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.LNX.4.33.0307301403110.25368-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0307301403110.25368-100000@css120.ihs.com>
Scott,
> Once someone is getting into the 8 way Itanium II with 32 Gigs of RAM,
> the fact that they are doing something that big means that by looking at
> the default, the workgroup, and the large server configs, they can
> extrapolate and experiment to determine the best settings, and are going
> to need to anyway to get it right.
>
> So, maybe just a note on which parameters to increase if you have more
> RAM/CPU/I/O bandwidth in the big server example?
Also, lets not get away from our goal here, which is NOT to provide
comprehensive documenation (which is available elsewhere) but to give new
DBAs a *sample* config that will perform better than the default.
Plus, I would assume that anybody who spent $50,000 on hardware would be smart
enough to pay a consultant $1000 to tune their database correctly.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, scott.marlowe@ihs.com, rstpierre@syscor.com
Subject: Re: postgresql.conf
In-Reply-To: <200307301342.24321.josh@agliodbs.com>
References: <Pine.LNX.4.33.0307301403110.25368-100000@css120.ihs.com> <200307301342.24321.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox