From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | hatuan05(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Does anyone user pg-pool II on real production ? Please help me. |
Date: | 2015-01-05 23:10:10 |
Message-ID: | 20150106.081010.882620421658577009.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Vanasco | 2015-01-06 17:07:00 | Re: postgresql versus riak for a global exchange |
Previous Message | Raymond Cote | 2015-01-05 22:49:02 | Re: postgresql versus riak for a global exchange |