Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3A3BC9F925D for ; Wed, 10 Oct 2007 14:40:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 96720-02-4 for ; Wed, 10 Oct 2007 14:39:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3D8669FB73F for ; Wed, 10 Oct 2007 14:39:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9AHdZCN020489; Wed, 10 Oct 2007 13:39:36 -0400 (EDT) To: "Scott Whitney" cc: pgsql-admin@postgresql.org Subject: Re: PG 8.1.4 not clearing pg_clog In-reply-to: <20071010164600.7FA2B3F2325@mail.int.journyx.com> References: <20071010164600.7FA2B3F2325@mail.int.journyx.com> Comments: In-reply-to "Scott Whitney" message dated "Wed, 10 Oct 2007 11:49:35 -0500" Date: Wed, 10 Oct 2007 13:39:35 -0400 Message-ID: <20488.1192037975@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/82 X-Sequence-Number: 26996 "Scott Whitney" writes: > Which I assume to be epoch dates and thusly converted. This assumption is incorrect, which likely accounts for your confusion. XID numbers have nothing to do with any external reality, and age() results even less. > If "today" is Saturday, a cronjob runs this command runs on each database: > PGCMD = 'vacuumdb -f -v -z %s' Seems like you should use the -a option instead of assuming that you know which databases need to be vacuumed. You haven't shown us a smoking gun here, but the failure to truncate pg_clog suggests that some database is getting missed. regards, tom lane