Re: Google Summer of Code: question about GiST API advancement project

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: GUO Rui <ruig2(at)uci(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org, a(dot)korotkov(at)postgrespro(dot)ru
Subject: Re: Google Summer of Code: question about GiST API advancement project
Date: 2019-04-05 10:13:29
Message-ID: 03560C71-92E4-4E86-99DC-C3C5B504B1BA@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

> 5 апр. 2019 г., в 14:07, GUO Rui <ruig2(at)uci(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2019-04-05 10:20:46 Re: Caveats from reloption toast_tuple_target
Previous Message Amit Langote 2019-04-05 10:07:17 Re: speeding up planning with partitions