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@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/