Re: *sigh*

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Randolf Richardson <rr(at)8x(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: *sigh*
Date: 2003-11-29 19:39:58
Message-ID: 87isl355gx.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Randolf Richardson <rr(at)8x(dot)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

In response to

  • Re: *sigh* at 2003-11-29 06:15:51 from Randolf Richardson

Responses

  • Re: *sigh* at 2003-11-30 02:21:23 from Gaetano Mendola

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-29 19:41:28 7.3.5 to be released this week ...
Previous Message Joe Conway 2003-11-29 19:31:03 Re: Automatically force zero_damaged_pages while InRecovery?