Re: Improvement of procArray.xmin for VACUUM - Mailing list pgsql-patches

From Tom Lane
Subject Re: Improvement of procArray.xmin for VACUUM
Date
Msg-id 7924.1174844122@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improvement of procArray.xmin for VACUUM  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Improvement of procArray.xmin for VACUUM  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
Gregory Stark <stark@enterprisedb.com> writes:
> Well I think this would be the same infrastructure we would need to do
> the other discussed improvement to address pg_dump's impact. That
> would require us to publish the youngest xmax of the live
> snapshots. Vacuum could deduce that that xid cannot possibly see any
> transactions between the youngest extant xmax and the oldest
> in-progress transaction.

... and do what with the knowledge?  Not remove tuples, because any such
tuples would be part of RECENTLY_DEAD update chains that that xact might
be following now or in the future.

            regards, tom lane

pgsql-patches by date:

Previous
From: Greg Smith
Date:
Subject: Re: Load distributed checkpoint V3
Next
From: Gregory Stark
Date:
Subject: Re: Improvement of procArray.xmin for VACUUM