vacuum analyse waiting

From: Nicolas Aubert <aubertnicolas11(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum analyse waiting
Date: 2016-03-21 09:20:02
Message-ID: CAEnLzzVU0U1OnYLEq6JVX7LVTywrDRZJseExtdNy9vQC-tbh8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have several questions regarding the use of postgres.

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.
Is it possible to make tuning to force the vacuum analyse to pass?
Or do I do app down?

su - postgres -c "vacuumdb -z -e -v -d zabbix"

Thank you in advance.

Nicolas Aubert

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2016-03-21 11:02:50 Re: vacuum analyse waiting
Previous Message Stephen Frost 2016-03-19 17:01:10 Re: pg_backrest restore & streaming replication