Re: vacuum analyse waiting
| От | bricklen |
|---|---|
| Тема | Re: vacuum analyse waiting |
| Дата | |
| Msg-id | CAGrpgQ_+gc8ZHX3dsoJGPD+ZsPkVRMrr0VfwuOLqHe6i7Vriag@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: vacuum analyse waiting (Nicolas Aubert <aubertnicolas11@gmail.com>) |
| Ответы |
Re: vacuum analyse waiting
|
| Список | pgsql-admin |
On Mon, Mar 21, 2016 at 8:26 AM, Nicolas Aubert <aubertnicolas11@gmail.com> wrote:
the vacuum process is the 22510
here is what I found in pg_locks
virtualtransaction | pid | mode | granted | fastpath
------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+----------
3/376480 | 22510 | ExclusiveLock | t |
| | | | | 3/376480 | 22510 | ShareUpdateExclusiveLock | f | f
Have 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.
В списке pgsql-admin по дате отправления: