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
Message-ID: A4FC0488-FA18-4F06-A299-5BD4A1F64574@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.
Changes:
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.

Thanks!

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

Responses

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