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
Re: vacuum analyse waiting |
| Список | 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
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 по дате отправления: