Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500
Date
Msg-id a5d6451c-3417-16e7-97e1-b0607540f0cf@enterprisedb.com
Whole thread Raw
In response to Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers
> 
> FWIW I suggest you provide the data in a form that's easier to use (like
> a working SQL script). More people are likely to look and help than when
> they have to extract stuff from an e-mail, fill in missing pieces etc.
> 

BTW if anyone wants to play with this, here are the SQL scripts I used
to create the tables and the queries. There's no data, but it's enough
to see how the plans change.

regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird failure with latches in curculio on v15
Next
From: Robert Haas
Date:
Subject: Re: ICU locale validation / canonicalization