Re: Big performance slowdown from 11.2 to 13.3
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Big performance slowdown from 11.2 to 13.3
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Wed, 21 Jul 2021 16:12:16 -0600
Cc
: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to
: <
MN2PR15MB25601E80A9B6D1BA6F592B1985E39@MN2PR15MB2560.namprd15.prod.outlook.com
>
References
: <
MN2PR15MB25601E80A9B6D1BA6F592B1985E39@MN2PR15MB2560.namprd15.prod.outlook.com
>
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?
Follow-Ups
:
RE: Big performance slowdown from 11.2 to 13.3
From:
ldh@xxxxxxxxxxxxxxxxxx
References
:
Big performance slowdown from 11.2 to 13.3
From:
ldh@xxxxxxxxxxxxxxxxxx
Prev by Date:
Re: Big performance slowdown from 11.2 to 13.3
Next by Date:
RE: Big performance slowdown from 11.2 to 13.3
Previous by thread:
RE: Big performance slowdown from 11.2 to 13.3
Next by thread:
RE: Big performance slowdown from 11.2 to 13.3
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
