21.05.2018 14:42, Vlad Khorsun via Firebird-devel пишет:
I don't see how persistent connections in Postgres could be reused by
different user sessions.
No, in Postgres you can reuse only your own connections.
Nevertheless, it seems to me that this approach also solves the original
task that faced the implementation of the connection pool.
But you do not need to deal with the side effects of managing this pool
by the system, not the user.
Because reset the state of the session is half the task, and often this
will not solve the problem, because sometimes you need to execute
queries in the context of the previous state. That is, on a good need to
implement a reset state somewhere out, and then restore it from there
(on request or maybe always).
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
