Re: Does anyone user pg-pool II on real production ? Please help me.

On 6 Jan 2015 03:02, "tuanhoanganh" <hatuan05(at)gmail(dot)com> wrote:
>
> Hello everybody
>
> Does anyone user pg-pool II on real production ?

Yes we have a customer using it in load balancing mode and another one
using it with Watchdog for high availability.

> How many slave do you have? and how many size of database ?
>

In both cases 1. But I believe pgpool can support more databases. Size of
db should not matter but we have 50GB if database being used with pgpool.

> I need config my old retail system to support ~ 1500 user with 1000GB
over 4 years. I want to try pgpool-II but don't found real system use it.
>

I guess in addition to using pgpool you should also think about using
pgbouncer as connection pooling agent (I would probably install it on
application server and configure to connect to pgpool)

> My system use direct SQL SELECT query and a lot pg procedure.

If there is a way you can specify different connection strings for these
two type of queries then you can make most out of pgbouncer. Do you do any
explicit transactions in these procedures?

> Can pgpool-II support load balance from SELECT my_procedure() ...

Yes you can specify those on white list (provided they are readonly
procedures).

>
> Please help me
>
> Thanks in advance. Sorry for my English.