On Tue, Oct 27, 2009 at 03:55:39PM +1100, ????????? wrote: > How does PostgreSQL recognise "deleted" tuples by using xmax ? xmax is the ID of the transaction that deleted the row. So if you are in a transaction that sees that transaction as commited, it has been deleted (from your point of view). If from your point of view that transaction is aborted, it has not been deleted. If that transaction is not finished yet, you have to wait. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
