Search Postgresql Archives

Re: [Q] single image Table across multiple PG servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday 14 July 2009 13:35:23 you wrote:
>  yes  -- thank you
>
> that's in the direction of what I am looking for
>
>
> ODBC connectivity and joins across databases!
>
>
> It looks like it cannot support
> a single image table across databases

It's effectively a single image across nodes - in that the grid allows you to 
partition a table across nodes (i.e. physical servers) so any sql see's it as 
a single table so long as you send the sql to the grid controller
>
> But do you know if supports viewes that combines tables
> from different servers (this way
> I can prefix a table on each server with server_id and then
> just combine them in the view in a single Image table)
>
no need for this, the system presents the clients (via the controller) a 
single table - even though its actually partitioned across nodes



It's quite similar to the Informix XPS product if that helps

>
> I am downloading it now and will try out on my windows dev
> machine.
>
>
> thanks
>
> > Maybe this is what you're looking for?
> >
> > http://www.enterprisedb.com/community/projects/gridsql.do
> >
> >
> >
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
>
> --
> Vlad P
> author of C++  ORM  http://github.com/vladp/CppOrm/tree/master


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux