Randolf Richardson <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to