Re: vacuum analyse waiting - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: vacuum analyse waiting
Date
Msg-id 20160321110250.GE14681@depesz.com
Whole thread Raw
In response to vacuum analyse waiting  (Nicolas Aubert <aubertnicolas11@gmail.com>)
Responses Re: vacuum analyse waiting  (Nicolas Aubert <aubertnicolas11@gmail.com>)
List pgsql-admin
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 by date:

Previous
From: Nicolas Aubert
Date:
Subject: vacuum analyse waiting
Next
From:
Date:
Subject: Re: PostgreSQL 9.3.5 - Enable SSL