Re: [GENERAL] Trouble running nested select - Join query

2014-05-26 Thread David G Johnston
Rushi wrote > copy (select * from (select s1.head as h1,s1.tail as t1 ,s2.tail as > neighbor from miami_2d s1, miami_directednetwork s2 where s1.tail=s2.head > and s2.tail not in (select tail from miami_2d where head=s1.head)) as O > where O.h1!=O.neighbor) to '/tmp/tmp.txt' Some thoughts: The O

[GENERAL] Trouble running nested select - Join query

2014-05-25 Thread RUSHI KAW
Hi, I have been working with Postgresxc 1.1 on a cluster, each cluster compute node having 48GB RAM. I have instantiated the coordinator on one of the compute nodes and have 4 datanodes (2+2) running on two other compute nodes.  I have been trying to run the  following query which is a select on