Hi all,
Working on the emaj extension (for the curious ones,
https://emaj.readthedocs.io/en/latest/ and
https://github.com/dalibo/emaj), I recently faced a performance problem
when querying and aggregating data changes. A query with 3 CTE has a O^2
behavior (https://explain.dalibo.com/plan/1d
Le 15/10/2023 à 18:37, Tom Lane a écrit :
Philippe BEAUDOIN writes:
During my analysis, I realized that the output rows estimate of the
second CTE is really bad, leading to a bad plan for the next CTE.
I reproduced the issue in a very small test case with a simplified
query. Attached is a
