Re: Google Summer of Code: question about GiST API advancementproject

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: Google Summer of Code: question about GiST API advancementproject
Дата
Msg-id 03560C71-92E4-4E86-99DC-C3C5B504B1BA@yandex-team.ru
обсуждение исходный текст
Ответ на Re: Google Summer of Code: question about GiST API advancement project  (GUO Rui <ruig2@uci.edu>)
Ответы Re: Google Summer of Code: question about GiST API advancement project  (GUO Rui <ruig2@uci.edu>)
Список pgsql-hackers
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
yourfeedback. 
I'd recommend planning some time to review other patches. If you plan to post your patches to commitfest, you are
expectedto 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
sameheight 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 по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: speeding up planning with partitions
Следующее
От: David Rowley
Дата:
Сообщение: Re: Caveats from reloption toast_tuple_target