ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> I'm thinking to add "the number of vacuumed tuples" to the message from
> vacuum. The stats collector will subtract the value from n_dead_tuples
> instead of setting it to zero. This is also needed if we want to make
> some kinds of "partial" vacuum methods.

This seems awfully dangerous to me, because then you are operating on
dead reckoning forever: there will be nothing that can correct an
inaccurate rowcount estimate, and in practice that means it will diverge
arbitrarily far from reality :-(, because of the inherent inaccuracies
of the stats system.  I think the risk of that is far worse than the
relatively small (or at least bounded) error arising from tuples not
seen by vacuum.

			regards, tom lane

In response to

• Estimation error in n_dead_tuples at 2007-02-01 10:43:45 from ITAGAKI Takahiro

Responses

• Re: Estimation error in n_dead_tuples at 2007-02-02 02:47:50 from ITAGAKI Takahiro
• Re: Estimation error in n_dead_tuples at 2007-02-02 06:03:09 from Jim Nasby

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-02-01 17:08:48
	Subject: Re: stack usage in toast_insert_or_update()
Previous:	From: Jan Wieck	Date: 2007-02-01 16:51:46
	Subject: Re: stack usage in toast_insert_or_update()