Hi! There's a thread about GiST build [0]. And we've found out there that logging newly created index with batches of 32 pages is slightly faster. Heikki implemented new logging routine log_newpages() for GiST build and it makes code for this batching 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
v3-0001-Use-new-log_newpages-routine-in-B-tree-build.patch
Description: Binary data
