Обсуждение: vacuum analyse waiting

On Mon, Mar 21, 2016 at 10:20:02AM +0100, Nicolas Aubert wrote:
> The database is used for zabbix supervision application. It is heavily
> loaded (1500 values per second).
>
> I can not get the vacuum daily analyse, process vacuum goes into Waiting
> mode.

If it's waiting, then check why. pg_locks has all the important
information.

Best regards,

depesz

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.

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@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       | 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.