Re: Postgres performance comments from a MySQL user

On Wed, 2003-06-11 at 21:28, Tom Lane wrote:

> There are still a lot of platforms where desirable settings will cause
> the database to fail to start, because the default kernel limits on
> shared memory are still set for 1980s-vintage hardware.
>
> We have had a policy for a long time that we'd rather the out-of-the-box
> settings be guaranteed to start than that they be optimal for
> performance.  No one is going to get as far as testing performance
> if the system won't start for them.

How about providing several .conf files with an indication of what
hardware profiles they correspond to?

For example a low end, a mid range and a high end machine. Plus a SMP
.conf file.

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL