Re: Scalable cluster

One question about Postgres-XC, can it distribute one single query in
all nodes ?

Example,
Nodes: Node1,Node2,Node3
Query:"SELECT sum(foo) FROM bar group by foo"

(Obvious: Your data has to be shared between the nodes)

Query -> Compiler (in the pool)-> "share the query between the nodes"
-> merge -> return

I know tools to do it, but don't have full implementation like Netezza.

Thank you.

On 4 March 2013 13:36, Koichi Suzuki <koichi(dot)szk(at)gmail(dot)com> wrote:
> Version 1.1 will be out in this June time frame, with online node
> addition/removal, Trigger and improved planner. I'm more than happy
> if you evaluate XC.
>
> Regards;
> ----------
> Koichi Suzuki
>
>
> 2013/3/4 Greg Jaskiewicz <gryzman(at)gmail(dot)com>:
>>
>> On 4 Mar 2013, at 13:21, Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> wrote:
>>
>>>
>>> There is this :
>>>
>>> http://wiki.postgresql.org/wiki/Postgres-XC
>>>
>>>
>>> [Disclaimer : I can't tell whether it's usable or not; I just know they
>>> exist]
>>>
>>
>>
>> Well, I know of its existence too. Question is how production ready is it. And also how far off the 9.2 line is it.
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--

-dom

--

IBM - Business Analytics Optimization Consultant
Daniel Mantovani +5511 8538-9897
XOXO