Search Postgresql Archives

Re: Scalable cluster

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

 



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


-- 
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