Re: psql is hanging

On Fri, 30 Nov 2018 at 15:53, John Smith <localdevjs(at)gmail(dot)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