Re: Postgres performance comments from a MySQL user

Hi Dave,

Are we able to get more messages added to the list of mailing list end tags, so we
can mention something about server tuning or such?

The rest of these things will probably have to be done in the PG source code itself.

:-)

Regards and best wishes,

Justin Clift

Dennis Gearon wrote:
> 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

--
"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