Doubt in pgbouncer

On Oct 1, 2020, at 5:42 PM, Rama Krishnan <raghuldrag@gmail.com> wrote:

Hi Friends,

By using pg bouncer can we split read and queries

Thank
Rk

Did you mean reads vs writes?

Yeah. Rob

On Fri, 2 Oct, 2020, 05:14 Rob Sargent, <robjsargent@gmail.com> wrote:

Yeah rob can we spilt read/write queries using pgbouncer

On Fri, 2 Oct, 2020, 08:43 Rama Krishnan, <raghuldrag@gmail.com> wrote:

Hi Rama,

On 02/10/2020 01:42, Rama Krishnan wrote:

Hi Friends, 

By using pg bouncer can we split read and queries

pgbouncer is just a connection pooler.

The logic where to send the reads and where the writes, should be in our application.

regards,

fabio pardi

On Thursday, October 1, 2020, Fabio Pardi <f.pardi@portavita.eu> wrote:

Hi Rama,

On 02/10/2020 01:42, Rama Krishnan wrote:

Hi Friends,

By using pg bouncer can we split read and queries

pgbouncer is just a connection pooler.

The logic where to send the reads and where the writes, should be in our
application.

Seems as if pgPool is at least worth considering...

David J.

On 2/10/20 9:50 π.μ., Fabio Pardi wrote:

Hi Rama,

On 02/10/2020 01:42, Rama Krishnan wrote:

Hi Friends,

By using pg bouncer can we split read and queries

pgbouncer is just a connection pooler.

The logic where to send the reads and where the writes, should be in our application.

yeah reading back some comments over the github on various issues, the pgbouncer hackers were of the philosophy that pgbouncer should remain as query agnostic as possible, in the sense that it should
not investigate the content of the queries. Those had to do with classic problems like search_path in transaction mode (some PR's were rejected because of that).
You might find this interesting : https://github.com/awslabs/pgbouncer-rr-patch

regards,

fabio pardi

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt