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
