Patrick Hatcher <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to