Postgres Pro
Downloads
Home   >   mailing lists

9.2 and index only scans - Mailing list pgsql-general

From Thomas Kellerer
Subject 9.2 and index only scans
Date
Msg-id k1coqr$eeb$1@ger.gmane.org
Whole thread Raw
Responses Re: 9.2 and index only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hi,

I'm playing around with 9.2 beta4 and was looking into the new Index Only Scan feature.

I was a bit surprised that a "count(*)" query does not use an index.
Not even a count(col) where col is the PK of the table.

Is that intended? If so, why is that the case?
I would have thought that this is an operation which is suitable to be served by an index only scan.

Regards
Thomas

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: postmaster.pid file auto-clean up?
Next
From: Matvey Teplov
Date:
Subject: Question about granting permissions