Обсуждение: Problem with VACUUM

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.

Marcelo Pereira Tada <marcelo.tada@nube.com.br> writes:
>> NOTICE:  Child itemid in update-chain marked as unused - can't continue repair_frag
>> ERROR:  No one parent tuple was found

Try updating to 7.2.4; that should fix this.

            regards, tom lane