X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4264D9DCBE7 for ; Tue, 7 Mar 2006 10:52:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32451-03 for ; Tue, 7 Mar 2006 10:52:51 -0400 (AST) 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 CDDA09DCBE4 for ; Tue, 7 Mar 2006 10:52:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k27EqkxO018277; Tue, 7 Mar 2006 09:52:46 -0500 (EST) To: Fabrice.Sznajderman@devoteam.com cc: pgsql-admin@postgresql.org Subject: Re: VACUUM Error? In-reply-to: References: Comments: In-reply-to Fabrice.Sznajderman@devoteam.com message dated "Tue, 07 Mar 2006 09:47:43 +0100" Date: Tue, 07 Mar 2006 09:52:46 -0500 Message-ID: <18276.1141743166@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200603/64 X-Sequence-Number: 20821 Fabrice.Sznajderman@devoteam.com writes: > But I had error :"ERROR: Parent tuple was not found What PG version is this? We recently fixed some bugs that could lead to this error. The error could only occur if you have some old open transaction(s) that could possibly still see since-updated tuples in the vacuumed table. So it'll go away if you close out open transactions. regards, tom lane