Virender Singla <virender....@gmail.com> writes:
> 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.
Probably because vacuum's is-this-row-dead-to-everyone tests are based
on the global xmin minimum. This must be so, because even if the
long-running transaction hasn't touched the table being vacuumed,
we don't know that it won't do so in future. So we can't remove
rows that it should be able to see if it were to look.
regards, tom lane
