Re: Postgres performance comments from a MySQL user

From: Tony Grant <tony(at)tgds(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kaarel <kaarel(at)future(dot)ee>, Justin Clift <justin(at)postgresql(dot)org>, "Jay O'Connor" <joconnor(at)cybermesa(dot)com>, postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres performance comments from a MySQL user
Date: 2003-06-11 19:37:08
Message-ID: 1055360227.1631.111.camel@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-11 19:37:18 Re: Postgres performance comments from a MySQL user
Previous Message Dann Corbit 2003-06-11 19:34:30 Re: Postgres performance comments from a MySQL user