Re: vacuum analyse waiting

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?

2016-03-21 16:37 GMT+01:00 bricklen <bricklen(at)gmail(dot)com>:

>
> On Mon, Mar 21, 2016 at 8:26 AM, Nicolas Aubert <aubertnicolas11(at)gmail(dot)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.
>
>