Gregory Stark <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend