Re: [GENERAL] Using xmax to detect deleted rows

2016-01-10 Thread Jim Nasby
On 1/8/16 9:02 AM, Alvaro Herrera wrote: Meel Velliste wrote: 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, a

Re: [GENERAL] Using xmax to detect deleted rows

2016-01-08 Thread Alvaro Herrera
Meel Velliste wrote: > 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 we

[GENERAL] Using xmax to detect deleted rows

2016-01-08 Thread Meel Velliste
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 check