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
