X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 300369FB2C5 for ; Sun, 30 Jul 2006 22:31:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19183-07 for ; Sun, 30 Jul 2006 22:30:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2B68F9FB308 for ; Sun, 30 Jul 2006 22:30:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k6V1UORS021520; Sun, 30 Jul 2006 21:30:24 -0400 (EDT) To: adey cc: "pgsql-admin@postgresql.org" , "PostgreSQL Admin" , postgresql-l Subject: Re: Fwd: vacuuming template0 gave ERROR In-reply-to: <1c66bda80607301716g1c28ce39w8bb6544252df61d1@mail.gmail.com> References: <1c66bda80607301716g1c28ce39w8bb6544252df61d1@mail.gmail.com> Comments: In-reply-to adey message dated "Mon, 31 Jul 2006 12:16:28 +1200" Date: Sun, 30 Jul 2006 21:30:24 -0400 Message-ID: <21519.1154309424@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/283 X-Sequence-Number: 22529 adey writes: > select datname, age(datfrozenxid), datfrozenxid, current_date, current_time > FROM pg_database > If template0 shouldn't be touched (and I don't know of deliberate access to > it), why is this changing please? Because current xid is changing and template0's datfrozenxid is not. Nonetheless, if template0 is properly frozen then you don't need to vacuum it, regardless of what age(datfrozenxid) says. regards, tom lane