Re: 8.1.8 autovacuum missing databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Ian Westmacott <ianw(at)intellivid(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1.8 autovacuum missing databases
Date: 2008-05-02 16:45:07
Message-ID: 7451.1209746707@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wrote:
> Perhaps it is worth adding a defense to autovac to not believe last
> autovac times that are in the future, since the system clock is not
> under our control and could go backwards. Other than that I don't
> think there's any bug here.

Oh, the other thing that comes to mind is that it's a bad move not
to have exposed last_autovac_time anywhere in the pgstat views.
Obviously we cannot back-patch that, but I think it should be fixed
going forward. This whole thing might've been much less of a mystery
if that state had been visible.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2008-05-02 19:52:11 Re: 8.1.8 autovacuum missing databases
Previous Message Tom Lane 2008-05-02 16:40:58 Re: 8.1.8 autovacuum missing databases