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.