| Lists: | pgsql-general |
|---|
| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | question about MAKE_EXPIRED_TUPLES_VISIBLE |
| Date: | 2006-02-02 21:13:04 |
| Message-ID: | 43E275E0.3050008@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
I saw some where that if I recompiled my server with
MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?
I did a ./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE
It compiled ok but I dont see the deleted tuples
| 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 |
| 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
| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: question about MAKE_EXPIRED_TUPLES_VISIBLE |
| Date: | 2006-02-02 21:51:22 |
| Message-ID: | 43E27EDA.3010100@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Tom Lane wrote:
>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
>
>---------------------------(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
| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: question about MAKE_EXPIRED_TUPLES_VISIBLE |
| Date: | 2006-02-02 22:25:40 |
| Message-ID: | 20060202141759.T33004@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Thu, 2 Feb 2006, Tony Caduto wrote:
> Tom Lane wrote:
>
> >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
> >
> 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.
| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: question about MAKE_EXPIRED_TUPLES_VISIBLE |
| Date: | 2006-02-02 23:37:42 |
| Message-ID: | 43E297C6.5080905@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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