Can parallel vacuum commands lead to a lock in Postgres 10.2

From: Meikel Bisping <info(at)mbisping(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Can parallel vacuum commands lead to a lock in Postgres 10.2
Date: 2018-02-15 16:40:48
Message-ID: 9c78e39f-196a-06ee-8886-f7bc9b05e443@mbisping.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2018-02-15 18:52:51 Trigger (or something similar) on table rename?
Previous Message Charles Clavadetscher 2018-02-15 13:19:27 RE: Remove default privilege from DB