Re: Performance Bottleneck - Mailing list pgsql-performance

From Martin Foster
Subject Re: Performance Bottleneck
Date
Msg-id YEiRc.48682$yT2.47522@clgrps13
Whole thread Raw
In response to Re: Performance Bottleneck  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Christopher Kings-Lynne wrote:

>>> This value of wal_buffers is simply ridiculous.
>>
>>
>>
>> Instead I think is ridiculous a wal_buffers = 8 ( 64KB ) by default.
>
>
> There is no point making WAL buffers higher than 8.  I have done much
> testing of this and it makes not the slightest difference to performance
> that I could measure.
>
> Chris
>

No point?  I had it at 64 if memory serves and logs were warning me that
raising this value would be desired because of excessive IO brought upon
from the logs being filled far too often.

It would seem to me that 8 is a bit low in at least a few circumstances.

    Martin Foster
    Creator/Designer Ethereal Realms
    martin@ethereal-realms.org

pgsql-performance by date:

Previous
From: Martin Foster
Date:
Subject: Re: Performance Bottleneck
Next
From: Mike Benoit
Date:
Subject: Re: Performance Bottleneck