Re: increasing shared buffers: how much should be removed

>>
>> 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(at)postgresql(dot)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/