From: Justin Clift <justin@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Cc: pgsql-advocacy@postgresql.org
Subject: Re: Changing the default configuration (was Re:
Date: Wed, 12 Feb 2003 04:34:13 +1100
Message-ID: <3E493415.9090004@postgresql.org> (raw)
In-Reply-To: <26582.1044984365@sss.pgh.pa.us>
References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local>
<26004.1044980414@sss.pgh.pa.us>
<3E492E06.2030702@postgresql.org>
<200302110918.48614.josh@agliodbs.com>
<26582.1044984365@sss.pgh.pa.us>
Tom Lane wrote:
<snip>
> Uh ... do we have a basis for recommending any particular sets of
> parameters for these different scenarios? This could be a good idea
> in the abstract, but I'm not sure I know enough to fill in the details.
>
> A lower-tech way to accomplish the same result is to document these
> alternatives in postgresql.conf comments and encourage people to review
> that file, as Steve Crawford just suggested. But first we need the raw
> knowledge.
Without too much hacking around, you could pretty easily adapt the
pg_autotune code to do proper profiles of a system with different settings.
i.e. increment one setting at a time, run pgbench on it with some decent
amount of transactions and users, stuff the results into a different
database. Aggregate data over time kind of thing. Let it run for a
week, etc.
If it's helpful, there's a 100% spare Althon 1.6Ghz box around with
(choose your OS) + Adaptec 29160 + 512MB RAM + 2 x 9GB Seagate Cheetah
10k rpm drives hanging around. No stress to set that up and let it run
any long terms tests you'd like plus send back results.
Regards and best wishes,
Justin Clift
> regards, tom lane
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
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: justin@postgresql.org, tgl@sss.pgh.pa.us, josh@agliodbs.com, merlin.moncure@rcsonline.com, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org
Subject: Re: Changing the default configuration (was Re:
In-Reply-To: <3E493415.9090004@postgresql.org>
References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26004.1044980414@sss.pgh.pa.us> <3E492E06.2030702@postgresql.org> <200302110918.48614.josh@agliodbs.com> <26582.1044984365@sss.pgh.pa.us> <3E493415.9090004@postgresql.org>
* 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