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

Hi,

> Hello everybody
>
> Does anyone user pg-pool II on real production ?

Yes, I have customers who are using pgpool-II.

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

Mostly one slave, some of them use more than one, up to four or so.
I am not sure how big their databases are though.

> 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.

Here it is:
http://www.sraoss.co.jp/case_study/daiichihoki_en.php

Also the most recent case study of "Gengo" (http://gengo.com/) will be
available soon in English.  They are using PostgreSQL and pgpool-II on
AWS.  (Japanese case study text is already availble. Please take a
look at if you like: http://www.sraoss.co.jp/case_study/gengo.php).

> My system use direct SQL SELECT query and a lot pg procedure. Can pgpool-II
> support load balance from SELECT my_procedure() ...

Yes. pgpool-II can have a list of load-balancing-possible functions
(procedures).

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

There is a pgpool-II specific mailing list. I suggest you to move to
it.
http://www.pgpool.net/mailman/listinfo/pgpool-general

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp