Re: pgbouncer - Mailing list pgsql-general

From Giovanni Biscontini
Subject Re: pgbouncer
Date
Msg-id CAOM+UfU37iNjJQ4_xuLy=Og939VaYyQ3R8t1xM=LU6hxCsF1Eg@mail.gmail.com
Whole thread Raw
In response to pgbouncer  (Rita <rmorgan466@gmail.com>)
List pgsql-general
On the DB server: the bouncer is made to optimize many and fast connections to the DB and fasten the throughput, so You've to have the shortest way to go to the data.
One important thing: remember that different user raise different connections so be careful to choose which application you'll direct to pgbouncer.
A couple more: be careful to choose the right pool_mode and tune the right server_connect_timeout value. 
all the best, Giovanni

Il giorno mer 28 giu 2023 alle ore 13:19 Rita <rmorgan466@gmail.com> ha scritto:

seems like I may need to deploy pgbouncer for my webapp. should i deploy it on the db server or on the webserver?
--
--- Get your facts first, then you can distort them as you please.--


--

Best Regards


Dott. Giovanni Biscontini

Software Developer & Database Architect

_________________________________________________________________
Privacy e riservatezza: il presente messaggio, così come i relativi allegati, contengono dati ed informazioni da considerarsi strettamente riservate ed è indirizzato esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato a trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD). Chiunque ricevesse questo messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente dell’errato invio, distruggendo poi l'eventuale copia cartacea e la copia in formato elettronico.


pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pgbouncer
Next
From: Rita
Date:
Subject: Re: pgbouncer