Hi, While quering with CTE against PG HEAD , i found that query got killed with this below error logs -- Machine Configuration: (d1.xlarge) CUPs : 8 , RAM : 16GB , SIze : 640GB
postgres=# with x as (select 5 c1 from generate_series(1,1000000) x) select * from x x1 join x x2 using(c1); Killed 2017-10-17 14:12:33.558 BST [949] LOG: could not send data to client: Broken pipe 2017-10-17 14:12:33.558 BST [949] STATEMENT: with x as (select 5 c1 from generate_series(1,1000000) x) select * from x x1 join x x2 using(c1); 2017-10-17 14:12:33.559 BST [949] FATAL: connection to client lost 2017-10-17 14:12:33.559 BST [949] STATEMENT: with x as (select 5 c1 from generate_series(1,1000000) x) select * from x x1 join x x2 using(c1); *Thanks & Regards,* *Prabhat Kumar Sahu* Mob: 7758988455 Skype ID: prabhat.sahu1984 www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/>
