Re: vacuum analyse waiting

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


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

Предыдущее
От: Dmitrii Golub
Дата:
Сообщение: Re: Out of memory psql import!
Следующее
От: "Ferrell, Denise D CTR NSWCDD, H11"
Дата:
Сообщение: Passing parameters