pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Ian Westmacott <ianw@intellivid.com>
To: pgsql-admin@postgresql.org
Subject: Re: 8.1.8 autovacuum missing databases
Date: Fri, 02 May 2008 12:45:07 -0400
Message-ID: <7451.1209746707@sss.pgh.pa.us> (raw)
In-Reply-To: <7391.1209746458@sss.pgh.pa.us>
References: <1209574908.22509.6.camel@vega.intellivid.com>
	<20185.1209575233@sss.pgh.pa.us>
	<1209576488.22509.9.camel@vega.intellivid.com>
	<22093.1209588237@sss.pgh.pa.us>
	<1209646882.16174.15.camel@vega.intellivid.com>
	<7698.1209650248@sss.pgh.pa.us>
	<1209664799.16174.51.camel@vega.intellivid.com>
	<17328.1209667453@sss.pgh.pa.us>
	<1209668403.16174.60.camel@vega.intellivid.com>
	<17606.1209669106@sss.pgh.pa.us>
	<20080502161709.GH2320@alvh.no-ip.org>
	<7391.1209746458@sss.pgh.pa.us>

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



view thread (19+ messages)  latest in thread

Message-ID: <7451.1209746707@sss.pgh.pa.us>
Permalink:  ../7451.1209746707@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/7451.1209746707@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, alvherre@alvh.no-ip.org, ianw@intellivid.com
  Subject: Re: 8.1.8 autovacuum missing databases
  In-Reply-To: <7451.1209746707@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox