Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split

Alvaro Herrera wrote:
> Heikki Linnakangas wrote:
>> Stefan Kaltenbrunner wrote:
>>> Bruce Momjian wrote:
>>>> Log Message:
>>>> -----------
>>>> Reduce WAL activity for page splits:
>>>>
>>>>> Currently, an index split writes all the data on the split page to
>>>>> WAL. That's a lot of WAL traffic. The tuples that are copied to the
>>>>> right page need to be WAL logged, but the tuples that stay on the
>>>>> original page don't.
>>>
>>> this patch killed both of my OpenBSD buildfarm members
>
> Please note that zebra died for a different reason the second time (not
> enough shared memory).

yeah that's because initdb is leaving the shm-segments there on a failure.
This resulted in the out-of-shm failure on the following run which I
have manually cleared now ...

Stefan