Re: Postgres performance comments from a MySQL user

----- Original Message -----
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>
Sent: Wednesday, June 11, 2003 9:37 PM
Subject: Re: [GENERAL] Postgres performance comments from a MySQL user

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

There is project on gborg(or somewhere else), written as deamon that
monitors server and calculates the best configuration based not only on
platform, but also on server load.(damn, I can't remember the project
name!). I think that monitoring is done using pg_stat.
If group think that this is important isue, we can try to do something like
this, or even include that project in contrib ? I know that I did downlad
the source, but never tried if it works.
Maybe I can try it I let You know ? Even beter if author is reading this
list !

Regards !