Re: Big performance slowdown from 11.2 to 13.3

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Big performance slowdown from 11.2 to 13.3
Date: 2021-07-21 22:12:16
Message-ID: CAHOFxGoRVO_qpyjAmCkFcdV5Z9a=X-Md_jT=fi8AwwON02sHGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ldh@laurent-hasson.com 2021-07-21 23:19:04 RE: Big performance slowdown from 11.2 to 13.3
Previous Message Justin Pryzby 2021-07-21 19:15:28 Re: Big performance slowdown from 11.2 to 13.3