Chris Joysn <joysn71@xxxxxxxxx> writes: > I have an issue when using CTEs. A query, which consists of multiple CTEs, > runs usually rather fast (~5s on my environment). But it turned out that > using one CTE can lead to execution times of up to one minute. > That CTE is used two times within the query. Try labeling that CTE as NOT MATERIALIZED. regards, tom lane
