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 E9ABE9FB2C5 for ; Sun, 30 Jul 2006 23:07:08 -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 22264-06 for ; Sun, 30 Jul 2006 23:07:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 2804A9FB2C1 for ; Sun, 30 Jul 2006 23:07:04 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so523758ugc for ; Sun, 30 Jul 2006 19:07:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=oHaKOWv/zRw2zuMaJ+KaFSpIldkJT8MDuo7NfHEYmClmLDzkd1f2K1mXweinnOzEkYtOw740alLOdXkt0GmGCrfUPeulzOC5APm1TNFoBrWYmfu8fR2BaZZ7HXTKYB+VTlzPx65jhEXKsriZD2t3OT3D545baHCoUKDov6Rjd5M= Received: by 10.66.224.3 with SMTP id w3mr1949319ugg; Sun, 30 Jul 2006 19:07:01 -0700 (PDT) Received: by 10.66.234.17 with HTTP; Sun, 30 Jul 2006 19:07:01 -0700 (PDT) Message-ID: <1c66bda80607301907t53a39d0am77fb6191dbe070a8@mail.gmail.com> Date: Mon, 31 Jul 2006 14:07:01 +1200 From: adey To: "Tom Lane" Subject: Re: Fwd: vacuuming template0 gave ERROR Cc: "pgsql-admin@postgresql.org" , "PostgreSQL Admin" , postgresql-l In-Reply-To: <21519.1154309424@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_48930_27655094.1154311621564" References: <1c66bda80607301716g1c28ce39w8bb6544252df61d1@mail.gmail.com> <21519.1154309424@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.593 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/284 X-Sequence-Number: 22530 ------=_Part_48930_27655094.1154311621564 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Tom - datfrozenxid has been the same for at least the last month on template0 and 1 On 7/31/06, Tom Lane wrote: > > 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 > ------=_Part_48930_27655094.1154311621564 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Tom - datfrozenxid has been the same for at least the last month on template0 and 1

On 7/31/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
adey <adey11@gmail.com> 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

------=_Part_48930_27655094.1154311621564--