Search Postgresql Archives

Can parallel vacuum commands lead to a lock in Postgres 10.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux