public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tomas Vondra <[email protected]>
To: Hans Buschmann <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500
Date: Thu, 9 Feb 2023 16:53:08 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
>
> 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
Attachments:
[application/sql] query-complete.sql (5.0K, ../[email protected]/2-query-complete.sql)
download
[application/sql] query-smaller.sql (3.8K, ../[email protected]/3-query-smaller.sql)
download
[application/sql] create-join.sql (1.3K, ../[email protected]/4-create-join.sql)
download
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox