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.
>I want to view deleted records in table from a week ago i The accepted method for handling deleted (or updated) records is to create a TRIGGER (or RULE) on the table(s) that writes the record to a history file after it has been deleted (or updated).
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.