Обсуждение: covering indexes?

Поиск
Список
Период
Сортировка

covering indexes?

От
Kevin Kempter
Дата:
Hi all;

I saw in the 8.1 release notes that a bug fix for covering index logic was
included. Can anyone point me to documentation on how to get PostgreSQL to
take advantage of a covering index (i.e. the query will return data only from
the index with no need to hit the table) ?


Thanks in advance...

Re: covering indexes?

От
Tom Lane
Дата:
Kevin Kempter <kevink@consistentstate.com> writes:
> I saw in the 8.1 release notes that a bug fix for covering index logic was
> included.

I don't know what you thought you read, but there are no covering
indexes in Postgres.

            regards, tom lane