We were also in search of having a table split across multiple databases but then found out about skypetools and at the same time the following article; http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/, true that it's not done with PG, but the same thing can be done with PG as well.
Assume this will be helpful for you.
Regards,
Ransika
On Tue, Jul 14, 2009 at 4:20 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Mon, Jul 13, 2009 at 11:16 PM, V S P<toreason@xxxxxxxxxxx> wrote:I think that skype's skytools could be used to create such a solution,
> Hello
>
> I am researching how to store the data for easy 'user-driven'
> reporting (where I do not need to develop application for
> every user request).
>
> The data will typically be number ranges and text strings with
> unique Id for each row
>
> I hope there will be a lot of data :-).
>
> So in that anticipation I am looking for a way
> to allow
> SQL/ODBC access to the data
>
> but in a way that each table resides on more than one
> PG server
>
> for example:
>
> table 1 lives in 3 PG instances (I can partition the data by date range)
> table 2 lives in the same 3 instances plus another one (because it's
> bigger)
>
>
> and I would like users to be able to issue SQL from within ODBC that
> joins them.
in particular pl/proxy.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Ransika De Silva
SCMAD 1.0, SCJP 1.4,
BSc.(Hons) Information Systems
