Postgres Pro
Downloads
Home   >   mailing lists

Re: Big performance slowdown from 11.2 to 13.3 - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Big performance slowdown from 11.2 to 13.3
Date
Msg-id CAHOFxGoRVO_qpyjAmCkFcdV5Z9a=X-Md_jT=fi8AwwON02sHGw@mail.gmail.com
Whole thread Raw
In response to Big performance slowdown from 11.2 to 13.3  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Responses RE: Big performance slowdown from 11.2 to 13.3  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
List pgsql-performance
Tree view
I'm not seeing the valueof the CTE. Why not access assessmenticcqa_raw directly in the main query and only do GROUP BY once? Do you have many values in iccqar_ques_code which are not used in this query?

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Big performance slowdown from 11.2 to 13.3
Next
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big performance slowdown from 11.2 to 13.3