Thomas Mack <mack(at)ifis(dot)cs(dot)tu-bs(dot)de> writes:
> Is there any chance to monitor the current transactions and abort them,
> in case of need?
Sure, just SIGINT whichever backend you want to cancel its query.
Use "ps" or pg_stat_activity to figure out the right PID to kill.
regards, tom lane