Postgres Pro
Downloads
Home   >   mailing lists

Re: Truly bizarre behavior with VACUUM FULL? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Truly bizarre behavior with VACUUM FULL?
Date
Msg-id 17325.1050711213@sss.pgh.pa.us
Whole thread Raw
In response to Truly bizarre behavior with VACUUM FULL?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Truly bizarre behavior with VACUUM FULL?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Truly bizarre behavior with VACUUM FULL?
Next
From: Josh Berkus
Date:
Subject: Re: Truly bizarre behavior with VACUUM FULL?