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

Re: Changing the default configuration (was Re:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Justin Clift <justin(at)postgresql(dot)org>,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:26:05
Message-ID: 26582.1044984365@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> What if we supplied several sample .conf files, and let the user choose which
> to copy into the database directory?   We could have a "high read 
> performance" profile, and a "transaction database" profile, and a 
> "workstation" profile, and a "low impact" profile.

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.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Kaare RasmussenDate: 2003-02-11 17:26:46
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: mlwDate: 2003-02-11 17:23:42
Subject: Re: [HACKERS] Changing the default configuration (was Re:

pgsql-hackers by date

Next:From: Kaare RasmussenDate: 2003-02-11 17:26:46
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: mlwDate: 2003-02-11 17:23:42
Subject: Re: [HACKERS] Changing the default configuration (was Re:

pgsql-advocacy by date

Next:From: Kaare RasmussenDate: 2003-02-11 17:26:46
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: mlwDate: 2003-02-11 17:23:42
Subject: Re: [HACKERS] Changing the default configuration (was Re:

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