Re: vacuum analyse waiting

Поиск
Список
Период
Сортировка
От Nicolas Aubert
Тема Re: vacuum analyse waiting
Дата
Msg-id CAEnLzzW16WhwHaV+vpc3QpStQ0YPT3EBsm+jo=MVeb0VzBTqLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum analyse waiting  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: vacuum analyse waiting  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: vacuum analyse waiting  (bricklen <bricklen@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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



2016-03-21 12:02 GMT+01:00 hubert depesz lubaczewski <depesz@depesz.com>:
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


В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: PostgreSQL 9.3.5 - Enable SSL
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: vacuum analyse waiting