From 2b1ccefe720812989e2b9f86508f538342324a39 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 24 Oct 2006 02:41:22 +0000 Subject: Add URL for: * Speed up COUNT(*) > http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php --- doc/src/FAQ/TODO.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 96467374adf..99e11179658 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Sat Oct 21 13:31:12 EDT 2006 +Last updated: Mon Oct 23 22:41:16 EDT 2006

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -867,6 +867,7 @@ first. get a count directly from a unique index, but for this to be faster than a sequential scan it must avoid access to the heap to obtain tuple visibility information. + http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php

Add estimated_count(*) to return an estimate of COUNT(*)

This would use the planner ANALYZE statistics to return an estimated -- cgit v1.2.3