Horton

Re: Big performance slowdown from 11.2 to 13.3

Michael Lewis <mlewis@entrata.com>

View thread View on postgr.es
From: Michael Lewis <mlewis@entrata.com>
To: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-07-21T22:12:16Z
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?

>

Commits

  1. Get rid of artificial restriction on hash table sizes on Windows.