3 ms·
Aren't MSSQL and Oracle just doing redo logs, like MySQL? What do you consider not actual transactions? Postgresql keeps dead tuples in place until vacuumed,
by paulryanrogers 3y ago
Aren't MSSQL and Oracle just doing redo logs, like MySQL?
What do you consider not actual transactions?
Postgresql keeps dead tuples in place until vacuumed, which seems optimized for rollbacks. But isn't so bad if you're inserting much more than deleting or updating.
- pmarreck 3y agoNestable transactions = “real transactions” to me, I guess. I almost don’t see the point in non-nestable transactions
- paulryanrogers 3y agoSQL standardizes SAVEPOINT for such nesting. Is that not sufficient? FWIW Postgres supports it.