Re: Slow query and wrong row estimates for CTE

2021-02-17 Thread Yoan SULTAN
*Hi all, * *This is my first post on this mailing list, I really enjoy it.* *I wanted to add some details and answers to this disccusion.* 17 févr. 2021 à 17:52, Dane Foster a écrit : > > A small update (see below/inline). > > > On Tue, Feb 16, 2021 at 2:11 PM Dane Foster wrote: > >> Short co

Re: Slow query and wrong row estimates for CTE

2021-02-17 Thread Yoan SULTAN
*You are totally right, the max(score_value) FILTER (WHERE score_name = 'student_performance_index') in the SELECT clause is redundant.* Le mer. 17 févr. 2021 à 21:33, Dane Foster a écrit : > On Wed, Feb 17, 2021 at 1:37 PM Yoan SULTAN wrote: > >> *Hi all, * >>

Re: Odd (slow) plan choice with min/max

2021-03-24 Thread Yoan SULTAN
you; we meet a planner bad behavior here. Regards, Yoan SULTAN Le mar. 23 mars 2021 à 22:38, Paul McGarry a écrit : > > > On Wed, 24 Mar 2021 at 00:07, Rick Otten wrote: > >> >>> Yes, the columns are highly correlated, but that alone doesn't seem like >>&g