PgBouncer 1.3.3

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : BSD - BSD License
CreatedCreated : May 16, 2010
Size downloadDownloads : 4
Program licensing
Thank you for voting...

PgBouncer does not need to see full network packets ...

pgbouncer by Skype Technologies does not need to see full network packets at once, so memory usage is very down and limited.
Several levels of brutality when rotating connection occur.
In session_pooling, when the client connects, a server connection will be assigned to it for the whole duration it stays connected. When client disconnects, the server connection will be put back into pool.
In transaction pooling, a server connection is assigned to client only during a transaction. When PgBouncer 1.3.3 notices that transaction is over, the server will be put back into pool. This is a hack as it breaks application expectations of backend connection. The developer can use it only when application cooperates with such usage by not using features that can break. See the table below for breaking features.
In statement pooling (most aggressive method), multi-statement transactions are disallowed. This is meant to enforce "autocommit" mode on client, mostly targeted for PL/Proxy.
Most important functions of PgBouncer [pgbouncer1.3.3.exe]:
• Statement pooling
• Transaction pooling
• Session pooling
• Low memory requirements (2k per connection by default).
• It is not tied to one backend server, the destination databases can reside on different hosts.
supports online reconfiguration for most of the settings.
• Supports online restart/upgrade without dropping client connections.
• Supports protocol V3 only, so backend version must be >= 7. 4.
Demands:
• PostgreSQL
News in the current PgBouncer - 0MB version:
Improvements:
• Make listen(2) argument configurable: listen_backlog. This is useful on OS'es, where system max allowed is configurable.
• Improve disconnect messages to show what username or dbname caused login to fail.
Fixes:
• Move fast-fail relaunch logic around. Old one was annoying in case of permanently broken databases or users, by trying to retry even if there is no clients who want to login.
• Make logging functions keep old errno, otherwise PgBouncer 1.3.3 may act funny on higher loglevels and logging problems.
• Increase the size of various startup-related buffers to handle EDB more noisy startup.
• Detect V2 protocol startup request and give clear reason for disconnect.

PgBouncer 1.3.3 scripting tags: connection, server, pgbouncer, transaction management, queue, client, pooling, connection pool, session pooling, supports. What is new in PgBouncer 1.3.3 software script? - Unable to find PgBouncer 1.3.3 news. What is improvements are expecting? Newly-made PgBouncer 1.4 will be downloaded from here. You may download directly. Please write the reviews of the PgBouncer. License limitations are unspecified.