Re: question about MAKE_EXPIRED_TUPLES_VISIBLE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: question about MAKE_EXPIRED_TUPLES_VISIBLE
Date: 2006-02-02 21:39:31
Message-ID: 19086.1138916371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-02-02 21:51:22 Re: question about MAKE_EXPIRED_TUPLES_VISIBLE
Previous Message Michelle Konzack 2006-02-02 21:30:36 Re: Alternative to knoda, kexi and rekall?