Can parallel vacuum commands lead to a lock in Postgres 10.2

Поиск
Список
Период
Сортировка
От Meikel Bisping
Тема Can parallel vacuum commands lead to a lock in Postgres 10.2
Дата
Msg-id 9c78e39f-196a-06ee-8886-f7bc9b05e443@mbisping.de
обсуждение исходный текст
Ответы Re: Can parallel vacuum commands lead to a lock in Postgres 10.2  (PT <wmoran@potentialtech.com>)
Список 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 по дате отправления:

Предыдущее
От: "Charles Clavadetscher"
Дата:
Сообщение: RE: Remove default privilege from DB
Следующее
От: Ken Tanzer
Дата:
Сообщение: Trigger (or something similar) on table rename?