Search Postgresql Archives

Re: Maximum of connections in PG

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux