Transaction wraparound and read committed isolation level

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Transaction wraparound and read committed isolation level
Дата
Msg-id 167677624368.647177.14087162303276367700@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Transaction wraparound and read committed isolation level
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/routine-vacuuming.html
Description:

hey guys

thanks for the work you do we really appreciate it. 

In the transaction wraparound section this statement is misleading and got
me really confused. 

“a row version with an insertion XID greater than the current transaction's
XID is “in the future” and should not be visible to the current
transaction“

If the current transaction isolation level is read committed it absolutely
can see rows committed by future transactions with higher XIDs. 

Would be cool to add a note. 

this also bear the question that the wraparound isn’t really a problem with
default isolation level but more for higher levels such as repeatable read
and such. 

please correct me if my understanding is incorrect.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: unclear syntax explanation for multiple window definitions in a SELECT query
Следующее
От: Kirk Wolak
Дата:
Сообщение: Re: February 9th, 2023 Release links to a missing page