Skip site navigation (1) Skip section navigation (2)

Re: Changing the default configuration (was Re:

From: Justin Clift <justin(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:34:13
Message-ID: 3E493415.9090004@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
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


In response to

Responses

pgsql-performance by date

Next:From: Greg CopelandDate: 2003-02-11 17:36:17
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: Justin CliftDate: 2003-02-11 17:29:19
Subject: Re: Changing the default configuration (was Re:

pgsql-hackers by date

Next:From: Greg CopelandDate: 2003-02-11 17:36:17
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: Justin CliftDate: 2003-02-11 17:29:19
Subject: Re: Changing the default configuration (was Re:

pgsql-advocacy by date

Next:From: Greg CopelandDate: 2003-02-11 17:36:17
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: Justin CliftDate: 2003-02-11 17:29:19
Subject: Re: Changing the default configuration (was Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group