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

From Kevin Kempter
Subject Re: [Q] single image Table across multiple PG servers
Date
Msg-id 200907141421.45474.kevink@consistentstate.com
Whole thread Raw
In response to [Q] single image Table across multiple PG servers  ("V S P" <toreason@fastmail.fm>)
Responses Custom Class variables
List pgsql-general
On Tuesday 14 July 2009 14:16:33 you wrote:
> This is great,
> thank you
>
> I have to say, if this is a free-of-charge
> add on to postgres that works and utilizes the hardware on each server
> to perform
> the join,
>
> -- why would anybody need to use mapreduce/hadoop/etc?
> for database-like selects  ?

It's new - the grid project just moved out of beta i believe. However I know
of at least one commercial company using it in production with no issues


>
>
>
>
>
>
>
> On Tue, 14 Jul 2009 09:45 -0600, "Kevin Kempter"
>
> <kevink@consistentstate.com> wrote:
> > > 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
>
> --
> Vlad P
> author of C++  ORM  http://github.com/vladp/CppOrm/tree/master


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [Q] single image Table across multiple PG servers
Next
From: Michael Gould
Date:
Subject: Custom Class variables