Re: Changing the default configuration (was Re: [pgsql-advocacy]

From: "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Date: 2003-02-12 06:21:44
Message-ID: 200302121151.44843.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-performance

On Tuesday 11 Feb 2003 10:56 pm, you wrote:
> 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.

Let's take very simple scenario to supply pre-configured postgresql.conf.

Assume that SHMMAX=Total memory/2 and supply different config files for

64MB/128Mb/256MB/512MB and above.

Is it simple enough?

Shridhar

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message ow 2003-02-12 06:31:46 Re: [HACKERS] PostgreSQL Benchmarks
Previous Message Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 2003-02-12 06:14:54 Re: [HACKERS] PostgreSQL Benchmarks

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-12 06:23:30 Re: Maximum Size for Large Object / TOASTed Object
Previous Message Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 2003-02-12 06:14:54 Re: [HACKERS] PostgreSQL Benchmarks

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Clift 2003-02-12 11:51:56 Re: how to configure my new server
Previous Message Bruce Momjian 2003-02-12 05:52:08 Re: how to configure my new server