Hi ,
I guess this is not Postgres.Is it Greenplum ?
Check for max connections on master and corresponding all nodes.
Max connections at nodes has to 4-5 times the max on master.
BTW are you using simple "create as select * from table " or anything else
Abhi