Re: autovacuum run but last_autovacuum is empty

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: Re: autovacuum run but last_autovacuum is empty
Date: 2018-11-26 16:10:33
Message-ID: 10326.1543248633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> writes:
> I think that something is wrong because some tables has a value in
> last_autoanalyze and some dont while most of them were analyzed.

It's possible that autovacuum abandoned some vacuum attempts without
getting to the end because of lock conflicts.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2018-11-26 18:45:09 Re: dsa_allocate() faliure
Previous Message Jakub Glapa 2018-11-26 16:00:30 Re: dsa_allocate() faliure