On Fri, 30 Nov 2018 at 15:53, John Smith <localdevjs@xxxxxxxxx> wrote: > We have a long script of sql that we run, several thousand lines of sql. If I execute the script > from start to finish, somewhere in the middle of it, one sql command will hang and take 2 to > 3 hours. During this time, "htop" shows 100% cpu usage with a postgresql process, so it > appears to be doing something. > > If I stop that command, then immediately rerun the rest of the script starting from the command that "hung", > the "hung" command then completes in 5 seconds and the rest of the script just continues on perfectly. I assume that JDBC doesn't put a transaction around your whole script if you send it in one hit? Geoff
