On Tue, Aug 27, 2019 at 9:54 AM Arnaud L. <arnaud.listes@xxxxxxxxx> wrote: > Any other idea ? I'll change the lines order for tonight's run, but that > is not what I'd call a solution... Does it hangs against the same line content or the same line number? Are you able to run the script automatically during working hours (to avoid firewalling or upgrades running in parrallel to your nightly script execution)? Any chance something is querying the same data and a lock blocks the transaction (pg_locks)? Just throwing on the table some desperate ideas.... Luca
