From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | Justin Clift <justin(at)postgresql(dot)org> |
Cc: | Joseph Shraibman <jks(at)selectacast(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres performance comments from a MySQL user |
Date: | 2003-06-12 14:29:59 |
Message-ID: | 3EE88E67.2EA59E5A@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 for our 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 that unless 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, and it'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(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Sven Koehler | 2003-06-12 14:33:11 | Re: full featured alter table? |
Previous Message | Dennis Gearon | 2003-06-12 14:27:57 | Re: How to change column type in PostgreSQL 7.1.2 |