How to terminate a process without rollback
When we terminate a process that is in a transaction, the system (fortunately) performs a rollback.
As part of some troubleshooting, I'm wondering if there's a way around this behavior to avoid rollback (or force commit) before termination.
Recently we had an issue on a test server with a process stuck in a huge transaction (around 100GB).
The out-of-control process was suspended and then terminated causing a rollback.
In the case of a test server, this is not really a problem.
If it happens on a production system, depending on the situation we might prefer to avoid rollback (journal volume, server availability, performance...).
We can suspend the process to save time, but then how to terminate it and avoid the rollback.
Although not recommended for obvious reasons, Is it possible?