vacuum on table1 skips rows because of a query on table2

Поиск
Список
Период
Сортировка
От Virender Singla
Тема vacuum on table1 skips rows because of a query on table2
Дата
Msg-id CAM6Zo8ySrgAuu94XOha7h-7ddgz4P=ft6dkvX3nR_5r49K=+uw@mail.gmail.com
обсуждение исходный текст
Ответы Re: vacuum on table1 skips rows because of a query on table2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Currently I see the vacuum behavior for a table is that, even if a long running query on a different table is executing in another read committed transaction.
That vacuum in the 1st transaction skips the dead rows until the long running query finishes.
Why that is the case, On same table long running query blocking vacuum we can understand but why query on a different table block it.

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

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] Block level parallel vacuum
Следующее
От: Michael Paquier
Дата:
Сообщение: Duplicate entries in pg_depend after REINDEX CONCURRENTLY