| From: | Marcelo Pereira Tada <marcelo(dot)tada(at)nube(dot)com(dot)br> |
|---|---|
| To: | PostgreSQL <pgsql-sql(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Problem with VACUUM |
| Date: | 2003-02-05 12:21:24 |
| Message-ID: | 3E4101C4.3070607@nube.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-05 15:23:18 | Re: Problem with VACUUM |
| Previous Message | Muhammad Shariq Muzaffar | 2003-02-05 10:10:51 | Lock timeout detection in postgres 7.3.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Haller | 2003-02-05 14:07:21 | Re: Inserting a tab character |
| Previous Message | Christoph Haller | 2003-02-05 12:04:17 | Re: bytea |