covering indexes?

Started by Kevin Kempterabout 17 years ago2 messagesgeneral
Jump to latest
#1Kevin Kempter
kevink@consistentstate.com

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...

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kevin Kempter (#1)
Re: covering indexes?

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