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])