Re: vacuum analyse waiting
| От | Nicolas Aubert |
|---|---|
| Тема | Re: vacuum analyse waiting |
| Дата | |
| Msg-id | CAEnLzzUf2=nMZtU7CEa3LAZF60p_waEirF_aHCOY3ZxQOm864A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: vacuum analyse waiting (bricklen <bricklen@gmail.com>) |
| Ответы |
Re: vacuum analyse waiting
|
| Список | pgsql-admin |
I'm a little lost in solving this problem.
The process vacuum waiting to disappeared. I do not think it is completed successfully.
How to verify that the vacuum passes successfully?
How to prevent it happening in modewaiting?
The process vacuum waiting to disappeared. I do not think it is completed successfully.
How to verify that the vacuum passes successfully?
How to prevent it happening in modewaiting?
2016-03-21 16:37 GMT+01:00 bricklen <bricklen@gmail.com>:
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 | 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.
В списке pgsql-admin по дате отправления: