Re: increasing the default WAL segment size - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: increasing the default WAL segment size
Date
Msg-id 43771576-af8b-0031-507f-cd6d61a74e44@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (tushar <tushar.ahuja@enterprisedb.com>)
Responses Re: increasing the default WAL segment size
List pgsql-hackers
On 4/4/17 22:47, Amit Kapila wrote:
>> Committed first part to allow internal representation change (only).
>>
>> No commitment yet to increasing wal-segsize in the way this patch has it.
>>
> 
> What part of patch you don't like and do you have any suggestions to
> improve the same?

I think there are still some questions and disagreements about how it
should behave.

I suggest the next step is to dial up the allowed segment size in
configure and run some tests about what a reasonable maximum value could
be.  I did a little bit of that, but somewhere around 256 MB, things got
really slow.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)
Next
From: Peter Eisentraut
Date:
Subject: Re: Re: PATCH: pageinspect / add page_checksum andbt_page_items(bytea)