Search Postgresql Archives

UPDATE stalls when run in "batch mode"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 







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 happened: the processing stalled at the same place as before.

Once more I killed the processing of the file, but then, this time, instead of re-running the whole thing from the beginning like I did before, I just attempted to execute the statement at which the processing was hanging.  It was in fact an update statement of the form:

UPDATE T SET K = NULL FROM B WHERE T.K = B.X;

For good measure, I then executed the next few statements individually, and they all finished in a few seconds.  Then I ran the remainder of the original file, and everything went without a hitch, at the expected speed.

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?  I.e. is there any diagnostic procedure I can perform that may lead to the explanation for this inconsistent behavior?

(FWIW, none of the statements in question were executed within a transaction block.)

TIA!

Kynn


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux