Menu
Does PostgreSQL support multiple transactions on the same connection? I don't mean nested transactions, but unrelated different transactions.
259
PostgreSQL processes more than 20 thousand transactions per second when MongoDB doesn't reach 2 thousand. PostgreSQL latencies are under 50ms for the 99% percentile, and as low as less than 1 millisecond.
PostgreSQL Connection Limits At provision, Databases for PostgreSQL sets the maximum number of connections to your PostgreSQL database to 115. 15 connections are reserved for the superuser to maintain the state and integrity of your database, and 100 connections are available for you and your applications.
Postgres does support nested transactions, but they differ from the conventional SQL, more like transactions with nested partial points.
PostgreSQL is a relational database management system. It's even the world's most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations.
If you mean "interleaved transactions" as required by the Java JTA standard: No, there is no support for that. See this JDBC FAQ section for this and why it is not a big loss.
Also the PostgreSQL core does not support something like this.
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
