pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with VACUUM
2+ messages / 2 participants
[nested] [flat]
* Problem with VACUUM
@ 2003-02-05 12:21 Marcelo Pereira Tada <marcelo.tada@nube.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Marcelo Pereira Tada @ 2003-02-05 12:21 UTC (permalink / raw)
To: pgsql-sql; pgsql-admin@postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with VACUUM
@ 2003-02-05 15:23 Tom Lane <tgl@sss.pgh.pa.us>
parent: Marcelo Pereira Tada <marcelo.tada@nube.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-02-05 15:23 UTC (permalink / raw)
To: marcelo.tada@nube.com.br; +Cc: pgsql-sql; pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-05 15:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-05 12:21 Problem with VACUUM Marcelo Pereira Tada <marcelo.tada@nube.com.br>
2003-02-05 15:23 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox