Re: [ADMIN] Re: [SQL] Data recovery

> > Very, very hard, but not impossible.  If you update a row, and do a
> > select on that row, the select updates the transaction status so the
> > next select doesn't need to look at the pg_log table.  What this means
> > is that pg_log could probably be reconstructed from existing data, with
> > just 'unselected' changes not appearing properly.
>
>     So  at  the  end  you have some data that you cannot trust. I
>     don't think that's worth the efford.

Yes.  True.  It is just a point that came up recently when Tom found the
first select on a table slow.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026