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
just fixing:
like Netezza which has full implementation to do it.*
On 4 March 2013 14:59, Daniel de Oliveira Mantovani
wrote:
> One question about Postgres-XC, can it distribute one single query in
> all nodes ?
>
> Example,
> Nodes: Node1,Node2,Node3
> Query:"SELECT sum
http://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf
On 18 June 2013 05:52, sachin kotwal wrote:
> Function in DB2: BLOB() Criteria: Size of character string targeted for cast
> is more than 1GB How can I migrate this function into PostgreSQL with above
> mention criteria.
> __