From: | "Amber" <guxiaobo1982(at)hotmail(dot)com> |
---|---|
To: | "Mark Roberts" <mailing_lists(at)pandapocket(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: What's size of your PostgreSQL Database? |
Date: | 2008-09-10 15:17:40 |
Message-ID: | BLU139-DS13315E270661057362484CD570@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 8. We have a master and a replica. We have plans to move to a
> cluster/grid Soon(TM). It's not an emergency and Postgres can easily
> handle and scale to a 3TB database on reasonable hardware (<$30k).
>
I'd like to know what's your progress of choosing the cluster/grid solution, we are also looking for
an appropriate one, following is the our major factors of the ideal solution.
1. Some kind of MPP.
2. No single point of failure.
3. Convenient and multiple access interfaces.
And following the is the solutions we have examined:
1. Slony-I: Not a MPP solution, and using triggers to detect changes, which defects performance.
2. pgpool-II: Some kind of MPP, but join operations can't be done on multiple machines parallelly, that is it can't scale out well.
3. Sequoia : The same problem as pgpool-II, and the major access interface is JDBC.
From | Date | Subject | |
---|---|---|---|
Next Message | Amber | 2008-09-10 15:25:55 | Re: What's size of your PostgreSQL Database? |
Previous Message | Alvaro Herrera | 2008-09-10 14:56:54 | Re: plpgsql return select from multiple tables |