Re: application of KNN code to US zipcode searches?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: application of KNN code to US zipcode searches?
Дата
Msg-id 12992.1297969985@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: application of KNN code to US zipcode searches?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-performance
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> The existing opclasses only support distance-to-a-point, but I believe
> the KNN gist code is flexible enough that it could be used for distance
> to the edge of a shape as well. Someone just needs to write the
> operators and support functions.

The distance has to be exactly computable from the index entry, so you'd
need to store the whole shape in the index, not just a bounding box.
Not sure how practical that will be for complex shapes.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Stosberg
Дата:
Сообщение: Re: application of KNN code to US zipcode searches?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: application of KNN code to US zipcode searches?