[HACKERS] Query got Killed with CTE.

Поиск
Список
Период
Сортировка
От Prabhat Sahu
Тема [HACKERS] Query got Killed with CTE.
Дата
Msg-id CANEvxPo2+e-QqTxHRh_q+dFANi9dPof9t_A=Q7wgfCuUi3sgUw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] Query got Killed with CTE.  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] PATCH: enabling parallel execution for cursorsexplicitly (experimental)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] SIGSEGV in BRIN autosummarize