Re: Yet another fast GiST build

[Andrey M. Borodin]

> 10 сент. 2020 г., в 17:43, Heikki Linnakangas <hlinn...@iki.fi> написал(а):
> 
> One more patch version attached. I fixed some memory leaks, and fixed the 
> abbreviation on 32-bit systems, and a bunch of small comment changes and such.
> 
> - Heikki
> <v18-0001-Add-support-for-building-GiST-index-by-sorting.patch>

The patch looks fine to me. On my machine GiST for points is builded 10x faster 
than before the patch.

Future action items:
1. Sort support for gist_btree data types
2. Better page borders with split and fillfactor
3. Consider sort build for tsvector

I'll certainly do 1 before next CF and most probably 2.
Item 1 is basically a lot of similar code for many many different types.
In Item 2 I plan to use Oleg's gevel to evaluation possibilities of MBR overlap 
reduction.

Item 3 seems tricky and need deeper evaluation: chances are sort build will 
decrease IndexScan performance in this case.

Thanks, Heikki!

Best regards, Andrey Borodin,