Re: Yet another fast GiST build

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: Darafei Komяpa Praliaskouski <me(at)komzpa(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Yet another fast GiST build
Date: 2019-09-08 08:54:35
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> 1 сент. 2019 г., в 15:53, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> написал(а):
> <v2-0001-Add-sort-support-for-point-gist_point_sortsupport.patch><v2-0002-Implement-GiST-build-using-sort-support.patch>

Here's V3 of the patch set.
1. Added some documentation of new sort support routines
2. Fixed bug with dirty pages

I did not add sort support procs to built-in boxes, circles and polys, since it may be not optimal index for them. However, for points Z-order is quite good as a default.

Tests only pass with fixes for GiST KNN from Alexander in other thread.


Best regards, Andrey Borodin.

Attachment Content-Type Size
v3-0002-Implement-GiST-build-using-sort-support.patch application/octet-stream 21.0 KB
v3-0001-Add-sort-support-for-point-gist_point_sortsupport.patch application/octet-stream 2.5 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Sergei Kornilov 2019-09-08 09:31:04 Re: Change ereport level for QueuePartitionConstraintValidation
Previous Message Andrey Borodin 2019-09-08 08:21:30 Re: amcheck verification for GiST