[postgis-devel] GiST Sorting

Giuseppe Broccolo g.broccolo.7 at gmail.com
Tue Jan 11 12:52:09 PST 2022


Hi Darafei,

On Sun, 9 Jan 2022, 14:12 Darafei "Komяpa" Praliaskouski, <me at komzpa.net>
wrote:

> Hi everyone,
>
> After several weeks of research, testing and experiments we believe we
> found a solution that does not cause the select performance degradation (or
> sometimes brings profit) and still builds the index faster using the
> sorting build method.
>
> The patch is posted on pgsql-hackers by Aliaskandr Kalenik in this thread:
>
>
> https://www.postgresql.org/message-id/CAHqSB9jqtS94e9%3D0vxqQX5dxQA89N95UKyz-%3DA7Y%2B_YJt%2BVW5A%40mail.gmail.com
>
> Patch on commitfest:
>
> https://commitfest.postgresql.org/36/3487/
>
> Sergei Shoulbakov implemented the benchmark to prove the effect. Results
> and notes are posted here:
>
> https://www.postgresql.org/message-id/3aa6ba30-e9d8-10ef-753f-8deea5f196d0%40kontur.io
>
> We need your help to get it reviewed and merged to get the benefits for
> everyone in PG15.
>

That's cool! What can we do to help?

Giuseppe.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20220111/47393c51/attachment.html>


More information about the postgis-devel mailing list