Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Consider index-only scans even when there is no matching qual or - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Consider index-only scans even when there is no matching qual or
Date
Msg-id 2321.1318360289@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Consider index-only scans even when there is no matching qual or  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pgsql: Consider index-only scans even when there is no matching qual or  (Thom Brown <thom@linux.com>)
List pgsql-committers
Tree view 
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> Consider index-only scans even when there is no matching qual or ORDER BY.
>>
>> By popular demand.

> Is this the COUNT(*) optimization?

Yeah, among other cases.

            regards, tom lane

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql: Consider index-only scans even when there is no matching qual or
Next
From: Thom Brown
Date:
Subject: Re: pgsql: Consider index-only scans even when there is no matching qual or