Re: [HACKERS] Error correction for n_dead_tuples

2007-05-26 Thread Tom Lane
I think this patch needs to be revisited in the light of the work I just did to make pgstats correctly track the effects of aborted transactions. It seems fairly likely to me that most of the problem you were seeing was actually due to that stupidity, and not to race conditions between VACUUM and c

[HACKERS] Error correction for n_dead_tuples

2007-05-15 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > I'm concerned that this one creates > an open-loop behavior in which the n_dead_tuples estimate will diverge > arbitrarily far from reality over time. I criticized the original > proposal on that basis, and I'm not convinced this version fixes it, > because o