Chris Joysn <[email protected]> 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
