Re: GiST index performance

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: GiST index performance
Дата
Msg-id 49E71780.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Re: GiST index performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> wrote:
> I have been doing some queries that are best answered with GiST
> indexes

For what definition of "best answered"?

Since an index is only a performance tuning feature (unless declared
UNIQUE), and should never alter the results (beyond possibly affecting
row order if that is unspecified), how is an index which performs
worse than an alternative the best answer?

-Kevin

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: GiST index performance
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: GiST index performance