Re: Postgres performance comments from a MySQL user - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 3EE88E67.2EA59E5A@cvc.net
Whole thread Raw
In response to Postgres performance comments from a MySQL user  ("Jay O'Connor" <joconnor@cybermesa.com>)
Responses Re: Postgres performance comments from a MySQL user  (Justin Clift <justin@postgresql.org>)
List pgsql-general
How about adding the mesage about tuning to the:

1/ 'don't kill the postmaster message at the bottom of emails'
2/ The install messages.
3/ The build messages.
4/ The login screen for the superuser of the databse?

Justin Clift wrote:
>
> Joseph Shraibman wrote:
> > Justin Clift wrote:
> >
> >> The _very first_ thing to do with any PostgreSQL installation is bump
> >> up the memory settings (at least "sort_mem" and "shared_buffers") in
> >> the postgresql.conf and restart it.
> >>
> >> Tell him to test it with decent settings (try about 4000 for each as
> >> an initial start),
>  >
> > Perhaps that should be in the message that 'make install' echoes and in
> > comments in the conf file itself?
> >
>
> Probably it's a good idea to have some mention of this, as even though we should alter the source to higher defaults
forour next release, there are potentially 
> people that would read a message like this and go "wow, didn't know that", then tune their existing installations as
well.
>
> With Solaris, 4000 for those memory settings is a good place to start and it's generally fine to just leave them at
thatunless there's a definite reason for 
> performance tuning.  No idea with other OS's.
>
> Anyone feel like submitting a patch to alter the default settings to a higher mark?  Don't think it's been done yet,
andit'd be a shame to forget it before 
> feature freeze time of the next release.
>
> Regards and best wishes,
>
> Justin Clift
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: How to change column type in PostgreSQL 7.1.2
Next
From: Sven Koehler
Date:
Subject: Re: full featured alter table?