On 03/14/2017 09:08 AM, Durumdara wrote:
Dear Melvin!
What is the meaning of PgBouncer with persistent, non-interruptable
connections? To I know it (for learn).
They are non web connections (request, get connection, result, drop
connection), they are pure, native applications which are keeping
connection from the start to the termination.
So just so we are same page:
1) When you say Web connections you are referring to HTTP:
*connection*
client request --> Web Server
|
client <-- reponse |
*connection*
repeat *connection* section for each request
2) Postgres connections
*connection*
client connect -->
query --> Postgres server
query -->
client disconnect <--
*connection*
In either case you are connecting/disconnecting it is just a matter of
when. So if I am following correctly you do not actually need a
connection to the Postgres server that is always on you just need one to
be available when you run a query or set of queries.
Thank you!
dd
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general