Re: using extended statistics to improve join estimates
От
Justin Pryzby
Тема
Re: using extended statistics to improve join estimates
Дата
Msg-id
20211122012315.GH17618@telsasoft.com
Ответ на
Re: using extended statistics to improve join estimates (Tomas Vondra)
Список
Дерево обсуждения
using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Justin Pryzby <pryzby@telsasoft.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Andres Freund <andres@anarazel.de>
Re: using extended statistics to improve join estimates Julien Rouhaud <rjuju123@gmail.com>
Re: using extended statistics to improve join estimates Justin Pryzby <pryzby@telsasoft.com>
Re: using extended statistics to improve join estimates Justin Pryzby <pryzby@telsasoft.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Re: using extended statistics to improve join estimates Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: using extended statistics to improve join estimates Andrei Lepikhov <lepihov@gmail.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Justin Pryzby <pryzby@telsasoft.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Justin Pryzby <pryzby@telsasoft.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihuifan1213@163.com>
Re: using extended statistics to improve join estimates Andy Fan <zhihui.fan1213@gmail.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Zhihong Yu <zyu@yugabyte.com>
Re: using extended statistics to improve join estimates Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: using extended statistics to improve join estimates Zhihong Yu <zyu@yugabyte.com>
Your regression tests include two errors, which appear to be accidental, and fixing the error shows that this case is being estimated poorly. +-- try combining with single-column (and single-expression) statistics +DROP STATISTICS join_test_2; +ERROR: statistics object "join_test_2" does not exist ... +ERROR: statistics object "join_stats_2" already exists -- Justin
В списке pgsql-hackers по дате отправления
