Can parallel vacuum commands lead to a lock in Postgres 10.2 - Mailing list pgsql-general

From Meikel Bisping
Subject Can parallel vacuum commands lead to a lock in Postgres 10.2
Date
Msg-id 9c78e39f-196a-06ee-8886-f7bc9b05e443@mbisping.de
Whole thread Raw
Responses Re: Can parallel vacuum commands lead to a lock in Postgres 10.2
List pgsql-general
Hello,

we have lots of scripts which issue individual vacuum commands to tables 
like "vacuum full gxstage_bs" but also general "vaccum full" commands.
Until now these scripts run sequentially and there are no problems.
Now the idea is to run some scripts in parallel, my question is if 
parallel vacuum commands can lead to a lock in 10.2?
Unfortunately it isn't easy to change the scripts and rely on 
auto-vacuum since they are installed on lots of customers' hosts and 
installing updates is very complex.

Any suggestion is very much appreciated

Meikel Bisping



pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: RE: Remove default privilege from DB
Next
From: Ken Tanzer
Date:
Subject: Trigger (or something similar) on table rename?