Auto-vacuum is not running in 9.1.12

From: Prakash Itnal <prakash074(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: rasna(dot)t(at)nokia(dot)com, sandhya(dot)k_s(at)nokia(dot)com
Subject: Auto-vacuum is not running in 9.1.12
Date: 2015-06-10 12:06:39
Message-ID: CAHC5u79-UqbapAABH2t4Rh2eYdyge0Zid-X=Xz-ZWZCBK42S0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

Recently we encountered a issue where the disc space is continuously
increasing towards 100%. Then a manual vacuum freed the disc space. But
again it is increasing. When digged more it is found that auto-vacuuming
was not running or it is either stucked/hanged.

Version: 9.1.12
Auto vacuum is enabled: check configuration details attached file.
Auto vacuum daemon running.
From stats it shows that auto-vacuum last run almost more than month back.
There are no error logs from database.

The attached file has all these details. If any other details needed please
let me know. I will try to collect it and share. Please help to analyze why
auto-vacuum stopped suddenly?

--
Cheers,
Prakash

Attachment Content-Type Size
autovacuum_stat.txt text/plain 3.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2015-06-10 12:20:34 Re: [idea] table partition + hash join
Previous Message Rosiński Krzysztof 2 - Detal 2015-06-10 11:48:09 Re: [idea] table partition + hash join