Pool Modes

Pool Modes ae bau vadhare important concept 6e.

PgBouncer PostgreSQL protocol ne bau sari rite samje 6e ane ae aapdne 3 connection modes different purpose mate provide kare 6e.

1) Session Mode (default)

PostgreSQL connection reserved rahe 6e jya sudhi client aene disconnect na kare tya sudhi. aa safest method consider karva ma aave 6e pan ghani badhi application aevu connection banavse k je kyarey release j nahi kare.

Aa problem mate aapdi pase 6e. Transaction Mode.

2) Transaction Mode

Aa case ma ek connection client pase tya sudhi j rehse jya sudhi ae ek single transaction nahi complete kari le. Jyare transaction commit or abort thai jase, connection pool ma re-enter karse and bija client ne assign thai jase.

Aa ek saru setting 6e aevi application mate j persistent database connection rakhva ni try kare 6e.

Unfortunately ghani applications k je cursors or paginations use kare 6e ae connection persistent rakhva nu expect kare 6e, kem k aa operations ma next transaction current transaction sathe jodayelu hoi 6e and jo ae current transaction pa6i disconnect thai jay 6e to ae proper work nahi kare.

3) Statement Mode

Aa case ma ek statement complete thata ni sathej connection ne pull ma return karva de 6e. Aa aek khub highly aggressive setup 6e, je basically design thyu 6e high concurrency mate jema transactions jevu generally nathi hotu.

Aa case ae dhyan rakhva ma aave 6e k setup ma kai khotu na thai aetle darek statement pa6i directly connection return kari deva ma 6e.