I was running an SQL file in psql (via \i) and I noticed that the execution
had been stuck at a particular place for a few hours, which was far longer
than expected.
So I killed the processing of the file (with Ctrl-C), vacuumed everything I
could think of and tried again.
The same thing
Kynn Jones [EMAIL PROTECTED] writes:
I can't begin to guess why the update statement above caused the processing
to stall, but ran quickly when I executed it by itself. How can I
understand this situation better?
Perhaps it was blocked on a lock rather than actually doing anything.
Did you