Re: Changing the default configuration (was Re:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Changing the default configuration (was Re:
Date: 2003-02-11 17:52:55
Message-ID: 26850.1044985975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-performance

Justin Clift <justin(at)postgresql(dot)org> writes:
> Tom Lane wrote:
>> 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.

> 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.

If I thought that pgbench was representative of anything, or even
capable of reliably producing repeatable numbers, then I might subscribe
to results derived this way. But I have little or no confidence in
pgbench. Certainly I don't see how you'd use it to produce
recommendations for a range of application scenarios, when it's only
one very narrow scenario itself.

regards, tom lane

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Lane 2003-02-11 17:54:37 Re: [HACKERS] Changing the default configuration (was Re:
Previous Message Josh Berkus 2003-02-11 17:48:39 Re: Changing the default configuration (was Re:

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-11 17:54:37 Re: [HACKERS] Changing the default configuration (was Re:
Previous Message Josh Berkus 2003-02-11 17:48:39 Re: Changing the default configuration (was Re:

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-02-11 17:54:37 Re: [HACKERS] Changing the default configuration (was Re:
Previous Message Josh Berkus 2003-02-11 17:48:39 Re: Changing the default configuration (was Re: