Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum analyse waiting - Mailing list pgsql-admin

From bricklen
Subject Re: vacuum analyse waiting
Date
Msg-id CAGrpgQ_+gc8ZHX3dsoJGPD+ZsPkVRMrr0VfwuOLqHe6i7Vriag@mail.gmail.com
Whole thread Raw
In response to Re: vacuum analyse waiting  (Nicolas Aubert <aubertnicolas11@gmail.com>)
Responses Re: vacuum analyse waiting  (Nicolas Aubert <aubertnicolas11@gmail.com>)
List pgsql-admin
Tree view

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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: vacuum analyse waiting
Next
From: Edgar Delgado
Date:
Subject: Out of memory psql import!