Re: question about MAKE_EXPIRED_TUPLES_VISIBLE - Mailing list pgsql-general

From Tom Lane
Subject Re: question about MAKE_EXPIRED_TUPLES_VISIBLE
Date
Msg-id 19086.1138916371@sss.pgh.pa.us
Whole thread Raw
In response to question about MAKE_EXPIRED_TUPLES_VISIBLE  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Responses Re: question about MAKE_EXPIRED_TUPLES_VISIBLE  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> I saw some where that if I recompiled my server with
> MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?

If you aren't a certified wizard you do NOT want to turn that on,
because it will very probably help you make things worse.  My opinion
on it is on record:
http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: question about MAKE_EXPIRED_TUPLES_VISIBLE
Next
From: Tony Caduto
Date:
Subject: Re: question about MAKE_EXPIRED_TUPLES_VISIBLE