Re: Postgres performance comments from a MySQL user

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