Re: vacuum analyse waiting

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

 



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@xxxxxxxxx>:

On Mon, Mar 21, 2016 at 8:26 AM, Nicolas Aubert <aubertnicolas11@xxxxxxxxx> 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.



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux