Re: Google Summer of Code: question about GiST API advancement project - Mailing list pgsql-hackers

From GUO Rui
Subject Re: Google Summer of Code: question about GiST API advancement project
Date
Msg-id CAEuz5PTsO+XSU==N4SnwcJZ8AtRDaNgFkxPfv9JCVHfZSQxeCg@mail.gmail.com
Whole thread Raw
In response to Re: Google Summer of Code: question about GiST API advancementproject  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Google Summer of Code: question about GiST API advancementproject
List pgsql-hackers
I added more details about GiST use cases (PostGIS and ScalaGiST) in my proposal and created one more entry for reviewing other patches in the time table.

I'll try to polish the proposal in the remaining three days to the GSoC deadline. I don't think I have much time to modify PostgreSQL source code and test against it myself though ;(. Many thanks to your feedback.

On Fri, Apr 5, 2019 at 3:13 AM Andrey Borodin <x4mmm@yandex-team.ru> wrote:
Hi!

> 5 апр. 2019 г., в 14:07, GUO Rui <ruig2@uci.edu> написал(а):
>
> I drafted my proposal about the above topic at https://docs.google.com/document/d/1X7Lw-c0rLYuSjwLNfw6qXpN5Cf1_0u2gXtgEgLkNezA/edit?usp=sharing  . Looking forward to your feedback.
I'd recommend planning some time to review other patches. If you plan to post your patches to commitfest, you are expected to review work some work of comparable complexity of others.

> 1. The case that the volume of an MBB is 0 should be very rare
Nope, if you index data points tend to cluster on grid-alligned planes (which happens with geo data, all points have same height above ocean) if always have zero volume of MBB.

BTW look at PostGIS, they are main GiST users, so indexing their data is important.

Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: New vacuum option to do only freezing
Next
From: Andres Freund
Date:
Subject: Re: [RFC] [PATCH] Flexible "partition pruning" hook