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