How does PostgreSQL recognise "deleted" tuples by using xmax ?
Started by 纪晓曦over 16 years ago2 messagesgeneral
Re: How does PostgreSQL recognise "deleted" tuples by using xmax ?
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@svana.org> http://svana.org/kleptog/
Show quoted text
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.