On Fri, 30 Nov 2018 at 15:53, John Smith <localde...@gmail.com> 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
