Re: Vacuum hangs

Will do thanks. I ended up dropping and recreating the index and that
seems to have fixed the problem.

Patrick Hatcher

Tom Lane
<tgl(at)sss(dot)pgh(dot)pa(dot)u
s> To
Patrick Hatcher
11/09/2004 12:06 <PHatcher(at)macys(dot)com>
PM cc
pgsql-general(at)postgresql(dot)org
Subject
Re: [GENERAL] Vacuum hangs

Patrick Hatcher <PHatcher(at)macys(dot)com> writes:
> Doing a Vacuum Analyze on a table and it's been hanging for at least 2
> hours. I could see no other users hitting the table at the time. This
is
> the second time this has happened on this particular table and I can't
> seem to pin point the issue. If I kill the PID and restart the vacuum
> analyze it works fine. Any suggestion where I start searching?

Next time, please attach to the vacuuming backend with gdb and get a
stack trace. The pg_locks output doesn't tell us anything except that
the problem isn't a lock :-(

regards, tom lane