Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum run but last_autovacuum is empty - Mailing list pgsql-performance

From Tom Lane
Subject Re: autovacuum run but last_autovacuum is empty
Date
Msg-id 10326.1543248633@sss.pgh.pa.us
Whole thread Raw
In response to Re: autovacuum run but last_autovacuum is empty  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
Tree view 
Mariel Cherkassky <mariel.cherkassky@gmail.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

pgsql-performance by date:

Previous
From: Jakub Glapa
Date:
Subject: Re: dsa_allocate() faliure
Next
From: Alvaro Herrera
Date:
Subject: Re: dsa_allocate() faliure