Postgres Pro
Downloads
Home   >   mailing lists

COUNT(*) and index-only scans - Mailing list pgsql-hackers

From Bruce Momjian
Subject COUNT(*) and index-only scans
Date
Msg-id 201110101723.p9AHNZ113162@momjian.us
Whole thread Raw
Responses Re: COUNT(*) and index-only scans  (Thom Brown <thom@linux.com>)
Re: COUNT(*) and index-only scans  (Greg Stark <stark@mit.edu>)
Re: COUNT(*) and index-only scans  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view 
I talked to Robert Haas and he said that index-only scans do not
optimize COUNT(*).  Is this something we can do for PG 9.2?  Is anyone
working on this?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Range Types - typo + NULL string constructor
Next
From: Gurjeet Singh
Date:
Subject: Re: SET variable - Permission issues