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.
- vacuum on table1 skips rows because of a query on table2 Virender Singla
- Re: vacuum on table1 skips rows because of a query on... Tom Lane
- Re: vacuum on table1 skips rows because of a quer... Virender Singla
- Re: vacuum on table1 skips rows because of a ... Robert Haas
- Re: vacuum on table1 skips rows because o... Laurenz Albe
- Re: vacuum on table1 skips rows because o... Tom Lane