Re: Index-only scans for multicolumn GIST

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index-only scans for multicolumn GIST
Дата
Msg-id 21665.1406037961@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index-only scans for multicolumn GIST  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: Index-only scans for multicolumn GIST  (Emre Hasegeli <emre@hasegeli.com>)
Список pgsql-hackers
Heikki Linnakangas <hlinnakangas@vmware.com> writes:
> For a circle, the GiST index stores a bounding box of the circle. The 
> new fetch function reverses that, calculating the radius and center of 
> the circle from the bounding box.

> Those conversions lose some precision due to rounding. Are we okay with 
> that?

That seems like a nonstarter :-(.  Index-only scans don't have a license
to return approximations.  If we drop the behavior for circles, how much
functionality do we have left?
        regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Index-only scans for multicolumn GIST
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [bug fix] Suppress "autovacuum: found orphan temp table" message