Re: Error correction for n_dead_tuples - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Error correction for n_dead_tuples
Date
Msg-id 3682.1180238343@sss.pgh.pa.us
Whole thread Raw
In response to Error correction for n_dead_tuples  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
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 concurrent transactions.  So maybe we no longer need to do
anything.

It might be worth fixing things so that a VACUUM sets n_dead_tuples to
the number of deleted-but-not-removable tuples it saw, rather than
always setting to zero as is presently done.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: Reviewing temp_tablespaces GUC patch
Next
From: Matthew O'Connor
Date:
Subject: Re: Autovacuum versus rolled-back transactions