Connection Pooling

Scalability ma haju ek better use case 6e k jyare number of connections bau vadhare vadhi jaay.

Darek connection, server na resources ne use kare 6e and koi query ne perform karya vagar large number of connections allowed karva aej bau moti problem bani rahe 6e. jyare hu kau 6u large number of database connection problems bani rahe 6e to maro matlab 6e 100 or 1000 database connections.

PgBouncer & PgPool II jeva tool PostgreSQL server ni jem ghani badhi application nu connection accept kare 6e and aa tool limited number of connection establish kare 6e real database sathe. ek prakare proxy jevu setup samji sakay k aa tools ek prakare large number of connections mate PostgreSQL server ni jem j work kare 6e application sathe and then biji baju real database sathe bau o6a praman ma database connections provide kare 6e. Aa connection multiple applications mate reuse thai sake 6e.

PgBouncer sathe connection aetla mate bhi set karvu joie kem k direct real database sathe connect karva karta PgBouncer sathe bau fast connection thai 6e. Kem k PgBouncer ae session mate koi database connection process nathi karvi padti.