X-Original-To: pgsql-admin@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 63A3B47607B; Wed,  5 Feb 2003 09:36:46 -0500 (EST)
Received: from smtp.attlatin.com.br (smtp.attlatin.com.br [200.173.133.2])
	by postgresql.org (Postfix) with ESMTP
	id A6C2A4767C2; Wed,  5 Feb 2003 09:21:14 -0500 (EST)
Received: from nube.com.br (200-207-156-24.dsl.telesp.net.br [200.207.156.24])
	by smtp.attlatin.com.br (8.11.6/8.9.3) with ESMTP id h15Eccf32735;
	Wed, 5 Feb 2003 12:38:39 -0200
Message-ID: <3E4101C4.3070607@nube.com.br>
Date: Wed, 05 Feb 2003 12:21:24 +0000
From: Marcelo Pereira Tada <marcelo.tada@nube.com.br>
Reply-To: marcelo.tada@nube.com.br
Organization: NUBE - =?ISO-8859-1?Q?N=FAcleo?= Brasileiro de
	=?ISO-8859-1?Q?Est=E1gios?=
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: pt-br, en-us
MIME-Version: 1.0
To: PostgreSQL <pgsql-sql@postgresql.org>, pgsql-admin@postgresql.org
Subject: Problem with VACUUM
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/59
X-Sequence-Number: 7257

Hello everybody!

We have a problem with VACUUM FULL and the our PostgresSQL is very slow.

On the try run the vacuum command, its returns:

> NOTICE:  Child itemid in update-chain marked as unused - can't continue repair_frag
> ERROR:  No one parent tuple was found
> vacuumdb: vacuum  nube failed

I think it looking for a table or an atributte of inherits but we have already droped it.

The PostgresSQL version is: 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96

Thanks

Marcelo.