Re: [PATCH] sort leaf pages by ctid for gist indexes built using sorted method

2022-03-21 Thread Andres Freund
Hi, On 2021-12-16 14:49:25 +0500, Andrey Borodin wrote: > > > With the current implementation, for GiST indexes created by doing multiple > > inserts, index tuples match heap tuples order, but it doesn't work that way > > for sorted method where index tuples on all levels are ordered using >

Re: [PATCH] sort leaf pages by ctid for gist indexes built using sorted method

2021-12-16 Thread Andrey Borodin
> With the current implementation, for GiST indexes created by doing multiple > inserts, index tuples match heap tuples order, but it doesn't work that way > for sorted method where index tuples on all levels are ordered using > comparator provided in sortsupport (z-order for geometry type,

[PATCH] sort leaf pages by ctid for gist indexes built using sorted method

2021-12-15 Thread Aliaksandr Kalenik
Hi! With the current implementation, for GiST indexes created by doing multiple inserts, index tuples match heap tuples order, but it doesn't work that way for sorted method where index tuples on all levels are ordered using comparator provided in sortsupport (z-order for geometry type, for