Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions
Дата
Msg-id CAMkU=1zv-aDKyOJcsh5cu1bLSVVeDQCxKDMvPUN_q34N1QO7GQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions  (rajan <vgmonnet@gmail.com>)
Список pgsql-general
On Mon, Jul 3, 2017 at 10:39 AM, rajan <vgmonnet@gmail.com> wrote:
Thanks, Jeff.

Now I am going back to my old question.

Even though *Session 2* fails to update with UPDATE 0 message, its txid is
saved in xmax of updated(by *Session 1*) tuple.

As it becomes an old txid, how come new txids are able to view it?

The database can see everything.  That is its job.  It constructs the principles of ACID out of non-ACID components.  But once you use pageinspect or select the system columns mxin and xmax, you start to peek through that illusion.
 
Cheers,

Jeff

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size
Следующее
От: Moreno Andreo
Дата:
Сообщение: Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size