Re: Yet another fast GiST build (typo)

x4mmm@yandex-team.ru

From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>

To: Heikki Linnakangas <hlinnaka@iki.fi>

Cc: Pavel Borisov <pashkin.elfe@gmail.com>, Thomas Munro <thomas.munro@gmail.com>, Daniel Gustafsson <daniel@yesql.se>, Erik Rijkers <er@xs4all.nl>, Michael Paquier <michael@paquier.xyz>, Alexander Korotkov <a.korotkov@postgrespro.ru>, Darafei Komяpa Praliaskouski <me@komzpa.net>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-09-07T08:36:46Z

Lists: pgsql-hackers

Attachments

v2-0001-nbtree-faster-logging.patch (application/octet-stream) patch v2-0001


> 7 сент. 2020 г., в 12:14, Andrey M. Borodin <x4mmm@yandex-team.ru> написал(а):
> 
> Maybe I'm missing something? Like forgot to log 10% of pages, or something like that...

Indeed, there was a bug. I've fixed it, and I still observe same performance gain.

Best regards, Andrey Borodin.

Commits

Add sortsupport for gist_btree opclasses, for faster index builds.
- 9f984ba6d23d 14.0 landed
pageinspect: Fix relcache leak in gist_page_items().
- 04eb75e783ba 14.0 landed
Fix test failure with wal_level=minimal.
- 5abca4b1cd71 14.0 landed
Enhance nbtree index tuple deletion.
- d168b666823b 14.0 cited
Fix portability issues in the new gist pageinspect test.
- 6ecaaf810b8b 14.0 landed
Add functions to 'pageinspect' to inspect GiST indexes.
- 756ab29124d7 14.0 landed
Fix missing validation for the new GiST sortsupport functions.
- 6f0bc5e1daf0 14.0 landed
Fix compilation warning in xlog.c
- 0a3c864c3275 14.0 cited
Set right-links during sorted GiST index build.
- 265ea567852a 14.0 landed
Fix checksum calculation in the new sorting GiST build.
- c47a240fe6db 14.0 landed
Add support for building GiST index by sorting.
- 16fa9b2b30a3 14.0 landed