Re: [GENERAL] covering indexes?

2009-02-12 Thread Tom Lane
Kevin Kempter 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 -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] covering indexes?

2009-02-12 Thread 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 adva