Thread: Doubt in pgbouncer
Hi Friends,
By using pg bouncer can we split read and queries
Thank
Rk
> 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:
> 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 can we spilt read/write queries using pgbouncer
On Fri, 2 Oct, 2020, 08:43 Rama Krishnan, <raghuldrag@gmail.com> wrote:
Yeah. RobOn Fri, 2 Oct, 2020, 05:14 Rob Sargent, <robjsargent@gmail.com> wrote:
> 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?
Hi Rama,
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 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,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).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.
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