vacuum on table1 skips rows because of a query on table2

From: Virender Singla <virender(dot)cse(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: vacuum on table1 skips rows because of a query on table2
Date: 2019-10-25 06:03:11
Message-ID: CAM6Zo8ySrgAuu94XOha7h-7ddgz4P=ft6dkvX3nR_5r49K=+uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-10-25 06:43:18 Duplicate entries in pg_depend after REINDEX CONCURRENTLY
Previous Message Dilip Kumar 2019-10-25 05:05:50 Re: [HACKERS] Block level parallel vacuum