PostgreSQL Subtransaction

A transaction unit nested within a parent transaction in PostgreSQL, created explicitly via the SAVEPOINT command or implicitly triggered by exception-handling blocks. Subtransactions provide partial rollback capability but can cause significant performance degradation in high-concurrency scenarios.