Re: What's size of your PostgreSQL Database?

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.

In response to

Responses

Browse pgsql-general by date

  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