Re: [GENERAL] Scalable cluster

2013-03-04 Thread Daniel de Oliveira Mantovani
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

Re: [GENERAL] Scalable cluster

2013-03-04 Thread Daniel de Oliveira Mantovani
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

Re: [GENERAL] Migration from DB2 to PostgreSQL

2013-06-21 Thread Daniel de Oliveira Mantovani
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. > __