X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4BB6F47636C
	for <pgsql-sql@postgresql.org>; Fri, 18 Apr 2003 20:13:46 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 8A97E475EF0
	for <pgsql-sql@postgresql.org>; Fri, 18 Apr 2003 20:13:45 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3J0DXU6017326;
	Fri, 18 Apr 2003 20:13:34 -0400 (EDT)
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Truly bizarre behavior with VACUUM FULL? 
In-reply-to: <200304181525.59152.josh@agliodbs.com> 
References: <200304181525.59152.josh@agliodbs.com>
Comments: In-reply-to Josh Berkus <josh@agliodbs.com>
	message dated "Fri, 18 Apr 2003 15:25:59 -0700"
Date: Fri, 18 Apr 2003 20:13:33 -0400
Message-ID: <17325.1050711213@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-32.3 required=5.0
	tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/292
X-Sequence-Number: 12993

Josh Berkus <josh@agliodbs.com> writes:
> Is it possible that VACUUM FULL is restoring the discarded tuple in
> the system table and dropping the valid one?

Fairly difficult to believe...

What is causing the new improved version to come back again?  Are you
doing another manual CREATE OR REPLACE each day?  How exactly?

			regards, tom lane