Re: psql \copy hanging

On 8/22/19 7:07 AM, Arnaud L. wrote:
> Le 22/08/2019 à 16:00, Adrian Klaver a écrit :
>> The first thing I think of when seeing this sort of behavior on Windows
>> is anti-virus software. Doing you have any running on the machine?
>>
>> You say it always hangs on the same line. Is that line doing something
>> different from the others? Say writing to a different location.
>
> Thanks for your insights Adrian.
>
> There is no AV software on the machine as it is a Server version of
> Windows. (I know some people run AV on Windows Server, but I don't)
>
> All the lines write to the same location which is a network share, but
> the hanging one is clearly the longest query to execute and the output
> file is one of the biggest one (though not the biggest).

The only thing I can think of at the moment is to put the offending line
in a separate script and see what happens.

>
> Note that the share points to a local folder. The fact the psql writes
> to a share is only for robustness so that this script could be executed
> from any machine.
>
> Cheers
>
> --
> Arnaud
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com