On 5-Sep-06, at 9:31 AM, Merlin Moncure wrote:
On 9/1/06, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
>>
>> 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.
really? what are the relative advantages of raising shared buffers? I
was thinking maybe there might be less context switches in high load
environments...I'm really curious what you have to say here.
Have you tried it ? The results are quite dramatic.
So if shared buffers aren't the first tool you reach for, what is ?
merlin
---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
