Re: [Q] single image Table across multiple PG servers - Mailing list pgsql-general

From Ransika de Silva
Subject Re: [Q] single image Table across multiple PG servers
Date
Msg-id a5af5afc0907140434x50ff6c8flb6f341435ec2b063@mail.gmail.com
Whole thread Raw
In response to Re: [Q] single image Table across multiple PG servers  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: [Q] single image Table across multiple PG servers
List pgsql-general
Hello,

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@gmail.com> wrote:
On Mon, Jul 13, 2009 at 11:16 PM, V S P<toreason@fastmail.fm> wrote:
> 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.

I think that skype's skytools could be used to create such a solution,
in particular pl/proxy.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
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

pgsql-general by date:

Previous
From: Nenad Milasinovic
Date:
Subject: PostgreSQL-License
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL-License