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 Bruce Momjian
Subject Re: pgsql: Consider index-only scans even when there is no matching qual or
Date
Msg-id 201110111901.p9BJ1SZ08761@momjian.us
Whole thread Raw
In response to pgsql: Consider index-only scans even when there is no matching qual or  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Consider index-only scans even when there is no matching qual or  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Tree view 
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?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Consider index-only scans even when there is no matching qual or
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Consider index-only scans even when there is no matching qual or