>>
>> I think 'shared buffers' is one of the most overrated settings from a
>> performance standpoint. however you must ensure there is enough for
>> things the server does besides caching. It used to be a bigger deal
>> than it is in modern versionf of postgresql modern operating systems.
Previous to 8.1 I would agree with you, but as of 8.1 it is probably the
most underrated.
Joshua D. Drake
>>
>> merlin
>>
> So if shared buffers is the most overrated, what do you consider the
> proper way of tuning ?
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/