I would like to use the "xmax" column to detect rows that have been recently deleted. Is it possible to get the deleted row versions with non-zero xmax to remain visible long enough that I could periodically check, say once an hour, and still be able to see rows that were deleted since I last checked?
- [GENERAL] Using xmax to detect deleted rows Meel Velliste
- Re: [GENERAL] Using xmax to detect deleted rows Alvaro Herrera