> 10 сент. 2020 г., в 17:43, Heikki Linnakangas <hlinnaka@iki.fi> написал(а):
>
> One more patch version attached. I fixed some memory leaks, and fixed the abbreviation on 32-bit systems, and a bunch
ofsmall 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,