Re: *sigh* - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: *sigh*
Date
Msg-id 87isl355gx.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: *sigh*  (Randolf Richardson <rr@8x.ca>)
Responses Re: *sigh*
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Automatically force zero_damaged_pages while InRecovery?
Next
From: "Marc G. Fournier"
Date:
Subject: 7.3.5 to be released this week ...