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.szk@gmail.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@gmail.com>:
>>
>> On 4 Mar 2013, at 13:21, Vincent Veyron <vv.lists@wanadoo.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.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
