question about MAKE_EXPIRED_TUPLES_VISIBLE

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

Tom Lane wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Well, it does not seem to do anything, I enabled it with ./configure
--enable-MAKE_EXPIRED_TUPLES_VISIBLE
I then thought well maybe I need to do dump of the table and the deleted
tuples would be in there, but no.

./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE is the correct way to
enable it right?

I accidentliy deleted 2600 rows that I would like to get back, so I gave
MAKE_EXPIRED_TUPLES_VISIBLE a try.

Thanks,

Tony

On Thu, 2 Feb 2006, Tony Caduto wrote:

Tom Lane wrote:

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

Well, it does not seem to do anything, I enabled it with ./configure
--enable-MAKE_EXPIRED_TUPLES_VISIBLE
I then thought well maybe I need to do dump of the table and the deleted
tuples would be in there, but no.

./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE is the correct way to
enable it right?

I think something like
CFLAGS="-D MAKE_EXPIRED_TUPLES_VISIBLE" ./configure
would be the way to get it.

Stephan Szabo wrote:

I think something like
CFLAGS="-D MAKE_EXPIRED_TUPLES_VISIBLE" ./configure
would be the way to get it.

Thanks,
I worked like a charm once I knew it was a CFLAG.

I did the dump as plain text insert statements, verified the deleted
records where there, then restored into a temp database, deleted all
records I did not need, then
dumped/restored back into the original table.

Thanks to Bruce for including this in 8.1, if used properly it's a life
saver :-)

Tony