Re: Performance regressions found using sqlfuzz

2019-02-16 Thread Tom Lane
Andres Freund writes: > On 2019-02-14 17:27:40 +, Jung, Jinho wrote: >> - Our analysis: We believe that this regression has to do with two factors: >> 1) conditional expression (e.g., LEAST or NULLIF) are not reduced to >> constants unlike string functions (e.g., CHAR_LENGTH) 2) change in t

Re: constraint exclusion with ineq condition (Re: server hardware tuning.)

2019-02-16 Thread Justin Pryzby
On Fri, Feb 15, 2019 at 12:24:18PM -0500, Benedict Holland wrote: > That sounds like a perfect task for a view if the joins are all the same. But note that either the view itself needs to have both where clauses (with hardcoded dates?), or otherwise the view needs to be on only one table, and the