Re: [TIPS] Tuning PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Payal Singh <payal(at)omniti(dot)com>, Scott Whitney <scott(at)journyx(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [TIPS] Tuning PostgreSQL 9.2
Date: 2016-04-11 22:45:57
Message-ID: CAE_gQfUzoZLU3NBhBvmNpfGiLY0-q_n6o6fb0y+0NSm0Z=0sTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
>>
> Hi guys... how are you all doing?
>
>
> Scott Marlowe, you sent an email about the pooler...
>
> I've done some tests on my VM, but can't do tests on the servers, as they
> are already in production...
> However... I'm willing to set-up the pgbouncer pool on my postgresql 9.2
> server...
>
> Just got some questions first.. can you please give me your opinion?
>
> *my scenario:*
>
>> 1 Load Balancer (nginx) --->
>> 2 web servers (www01 and www02) --->
>> 4 DB servers (master01, slave01 (read-only), slave02 (hot_standby),
>> slave03 (hot_standby), slave04 (hot_standby)
>
>
> I'd install the pgbouncer on the www01 server... What do you guys think
> about it? Having in mind my scenario?
>
> Cheers
> Lucas
>
>
I mean... can pgbouncer handle with my master and slave01? As I'm using
slave01 as read-only server? Also.. I've got 2 www servers... Do I have to
have pgbouncer in both of them?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2016-04-12 00:16:35 Re: [TIPS] Tuning PostgreSQL 9.2
Previous Message drum.lucas@gmail.com 2016-04-11 22:34:03 Re: [TIPS] Tuning PostgreSQL 9.2