Re: View deleted records in a table

On 03/26/2016 09:08 AM, Boyan Botev wrote:

I want to view deleted records in table from a week ago in order to
troubleshoot a data issue. The table has not been vacuumed yet. I was

Are you sure?
In other words do you have autovacuum turned off?

trying to use the pageinspect v1.4 extension but can't seem to convert
the t_data to a readable record. Is there an easy way for me to get a

What is t_data?

What version of Postgres?

SQL to produce all system columns like xmin, xmax along with the visible
and invisible records of the table in a readable form.

I was hoping to find a setting similar to what Netezza has "set
show_deleted_records=1;" to easily turn this visibility on or off, but
it seems that feature was shot down several years ago. As a DBA I want
to say that a feature like this is indispensible when troubleshooting
data problems in large tables and environments where restores may not
always be an option.

That means keeping deleted records around for some indefinite period of time, which means table bloat.

Thanks in advance for any help,
Boyan

--
Adrian Klaver
adrian.klaver@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general