Long-running transactions that are left open without being committed or rolled back are not a good design. In PostgreSQL, they have a more serious impact than in Oracle. It starts with table bloat and ...