Hi all, func.sgml still claims that a sequential scan is the only way to execute a SELECT COUNT(*) query. I think this note should just be removed from the current docs, given the existence of index-only scans; patch attached.
I didn't see any other outright incorrect spots regarding COUNT(*). There are two EXPLAIN outputs for COUNT(*) queries, in auto-explain.sgml and ddl.sgml, though those are probably fine as-is. Josh
func.sgml.diff
Description: Binary data
-- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs