| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |
| 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 |