Re: endless quere when upsert with ON CONFLICT clause

2019-03-29 Thread Andreas Kretschmer
Am 29.03.19 um 15:29 schrieb Stephan Schmidt: PostgreSQL version: 11.2 Operating system:   Linux Description: We have a wuite complex CTE which collects data fast enough for us and has a ok execution plan. When we insert the result into a table like With _/some/_data AS ( SELECT…. ),

endless quere when upsert with ON CONFLICT clause

2019-03-29 Thread Stephan Schmidt
PostgreSQL version: 11.2 Operating system: Linux Description: We have a wuite complex CTE which collects data fast enough for us and has a ok execution plan. When we insert the result into a table like With _some_data AS ( SELECT…. ), _some_other_data AS ( SELECT …. ) INSERT INTO table1