On Tue, 11 Mar 2008, Bill Moran wrote:
In response to "Robins Tharakan" <tharakan@xxxxxxxxx>:
Sorry, if I am missing something here, but shouldn't something like this
allow us to get a (fast) accurate count ?
SELECT COUNT(*) from table WHERE indexed_field IS NULL
+
SELECT COUNT(*) from table WHERE indexed_field IS NOT NULL
For certain, qualified definitions of "fast", sure.
And certain, qualified definitions of "accurate" as well. Race condition?
Matthew
--
"Television is a medium because it is neither rare nor well done."
-- Fred Friendly
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
