Re: About Access paths

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: About Access paths
Дата
Msg-id 87wtsjc2ia.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: About Access paths  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Stuck with a query...  (Geoff Caplan <geoff@variosoft.com>)
Список pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:

> It's a fairly corner case feature, only for the case where you're
> looking for the existance of an index key but don't want any other
> data. I don't personally have any queries that could use such a
> construct, though maybe I'm missing the point.

You don't have any many-to-many relationships? Or any queries that use EXISTS
with indexable where clauses? Both of those are typical use cases for this
path.

In any case I think this type of scenario is more likely to be attacked via
some sort of "index organized table". But even that's not on the horizon right
now.

--
greg

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Pg 8.01 big trouble with LIMIT (bug !?)
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: More concurent transaction over single connection