vacuum on table1 skips rows because of a query on table2
Virender Singla <virender.cse@gmail.com>
From: Virender Singla <virender.cse@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2019-10-25T06:03:11Z
Lists: 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.