Thomas Mack <mack@ifis.cs.tu-bs.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