Re: Postgres performance comments from a MySQL user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(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>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres performance comments from a MySQL user
Date: 2003-06-11 19:37:18
Message-ID: 22848.1055360238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> Having said that, though, I do wonder whether we couldn't bump them up a
>> little. Are there still any live platforms where the default SHMMAX is
>> less than 4 MB? (There was discussion of this a month or two back on
>> pghackers, but no conclusion.)

> Could we have per-platforms defaults?

Hmm, that might be a nice solution. Could we arrange for the template
file to supply defaults for shared_buffers and so forth? They'd have
to be inserted into postgresql.conf during installation or initdb, but
we already do some editing of postgresql.conf during initdb ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-11 19:48:48 Re: Index not being used in MAX function (7.2.3)
Previous Message Tony Grant 2003-06-11 19:37:08 Re: Postgres performance comments from a MySQL user