Re: vacuum analyse waiting

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Nicolas Aubert <aubertnicolas11(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum analyse waiting
Date: 2016-03-21 11:02:50
Message-ID: 20160321110250.GE14681@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message shyamkant.dhamke 2016-03-21 12:35:43 Re: PostgreSQL 9.3.5 - Enable SSL
Previous Message Nicolas Aubert 2016-03-21 09:20:02 vacuum analyse waiting