On Mon, Mar 21, 2016 at 8:26 AM, Nicolas Aubert <aubertnicolas11@gmail.com> wrote:the vacuum process is the 22510here is what I found in pg_locksvirtualtransaction | pid | mode | granted | fastpath------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+---------- 3/376480 | 22510 | ExclusiveLock | t | | | | | | 3/376480 | 22510 | ShareUpdateExclusiveLock | f | fHave a look at the lock dependency queries at https://wiki.postgresql.org/wiki/Lock_dependency_information for more information about what is holding the locks.
the vacuum process is the 22510here is what I found in pg_locksvirtualtransaction | pid | mode | granted | fastpath------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+---------- 3/376480 | 22510 | ExclusiveLock | t | | | | | | 3/376480 | 22510 | ShareUpdateExclusiveLock | f | f
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных