Re: more anti-postgresql FUD

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: more anti-postgresql FUD
Date: 2006-10-12 09:14:26
Message-ID: 758d5e7f0610120214y70fa18b4y267b87326009345f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Not necessarily. Last I heard, MySQL ships with multiple config files,
> ie: small, medium and large. So by choosing one of those you're
> effectively tuning MySQL as well.

Hmm, wouldn't it be a good idea to provide something similar?

I think an initdb could have an additional flag, like "--tune-for medium-oltp",
or something similar (MBs of RAM dedicated for PgSQL and estimated
number of concurrent users?).

This should probably be accompanied with verbosly claiming:
applying medium-olap profile:
** increasing work_mem from 123 to 456
and maybe some hints for further tuning, and a great advice that
all these numbers are changeable from postgresql.conf

This would probably hint newbies that they should consider modifying
these files, and also help with strange setups where sysadmin is an
enemy (and not a DBA; and wouldn't like to modify postgresql.conf
much, but an additional option to initdb should go fine ;)).

Regards,
Dawid

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter 2006-10-12 09:18:48 Override system-defined cast?
Previous Message alexei.vladishev 2006-10-12 08:58:20 Re: more anti-postgresql FUD