On 05/04/2017 02:04 PM, PAWAN SHARMA
wrote:
Yes.
Either forever or for however long lock_timeout and/or statement_timeout are set to (or any user command like Ctrl+C).
If any of those limits are reached, the vacuum is cancelled.
Prevent what? Even if the vacuum could run while the other transaction had the exclusive lock, it wouldn't be able to do any work. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support |