Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500
Дата
Msg-id a5d6451c-3417-16e7-97e1-b0607540f0cf@enterprisedb.com
обсуждение исходный текст
Ответ на Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Weird failure with latches in curculio on v15
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ICU locale validation / canonicalization