From: | Antonis Antoniou <a(dot)antoniou(at)albourne(dot)com> |
---|---|
To: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: vacuum full problem |
Date: | 2003-11-07 10:50:27 |
Message-ID: | 3FAB78F3.8060406@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
pginfo wrote:
>Hi,
>I am running pg 7.3.4 on linux red hat 9.0.
>
>If I try to execute vacuum full analyze verbose, the pg vacuum some
>tables and hang after this lines:
>
>INFO: --Relation pg_toast.pg_toast_16408--
>INFO: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
>Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space
>0/0; EndEmpty/Avail. Pages 0/0.
> CPU 0.00s/0.00u sec elapsed 0.00 sec.
>INFO: Index pg_toast_16408_index: Pages 1; Tuples 0.
> CPU 0.00s/0.00u sec elapsed 0.00 sec.
>
>After rebooting I can vacuum without any problems.
>I do not find nothing in my log-file that can point me to this problem.
>Also the problem comes constantly by me.
>Any idea or info about this problem?
>Also I am using pg + java (jboss), but I think vacuum is working normal
>with it and I have many instalations without this problem.
>
Try to "reindex table pg_toast.pg_toast_16408;" Maybe an index is broken.
Many Thanks
Antonis
From | Date | Subject | |
---|---|---|---|
Next Message | Dani Oderbolz | 2003-11-07 11:57:47 | pg_atoi: zero-length string |
Previous Message | Markus Bertheau | 2003-11-07 10:16:22 | small table occupies many relpages |