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