Randolf Richardson <rr@8x.ca> writes:
> What about adding a "total number of rows" value to the internal
> header of each table which gets incremented/decremented after each row is
> INSERT/DELETE has been committed. This way, a generic "count(*)" by itself
> could simply return this value without any delay at all.
Because different sessions have a (validly) different concept of what
that number should be, due to MVCC.
-Doug