| From: | Nicolas Aubert <aubertnicolas11(at)gmail(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: vacuum analyse waiting |
| Date: | 2016-03-21 15:26:40 |
| Message-ID: | CAEnLzzW16WhwHaV+vpc3QpStQ0YPT3EBsm+jo=MVeb0VzBTqLg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)depesz(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2016-03-21 15:35:38 | Re: vacuum analyse waiting |
| Previous Message | shyamkant.dhamke | 2016-03-21 12:35:43 | Re: PostgreSQL 9.3.5 - Enable SSL |