Batching page logging during B-tree build - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Batching page logging during B-tree build
Date
Msg-id 41822E78-48EE-41AE-A89B-3CB76FF53980@yandex-team.ru
Whole thread Raw
Responses Re: Batching page logging during B-tree build  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Hi!

There's a thread about GiST build [0]. And we've found out there that logging newly created index with batches of 32
pagesis slightly faster. Heikki implemented new logging routine log_newpages() for GiST build and it makes code for
thisbatching nice and clean. 
Here is PoC with porting that same routine to B-tree. It allows to build B-trees ~10% faster on my machine.

Thanks!

Best regards, Andrey Borodin.

[0]
https://www.postgresql.org/message-id/flat/12CC4B83-9A5D-4A59-85A1-215CF9D1AB4B%40yandex-team.ru#6b93ee95fcc51ba710715d2ff6017b7f

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: factorial function/phase out postfix operators?
Next
From: Mark Dilger
Date:
Subject: Re: factorial function/phase out postfix operators?