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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
