Re: Parameter for planner estimate of recursive queries

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Parameter for planner estimate of recursive queries
Дата
Msg-id CA+TgmoaGDw2baysiK+qqL+c3roa-9cPSvJ_Kwdgx7RoPQR0TaA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parameter for planner estimate of recursive queries  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: Parameter for planner estimate of recursive queries  (Simon Riggs <simon.riggs@enterprisedb.com>)
Re: Parameter for planner estimate of recursive queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Jan 25, 2022 at 4:44 AM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
> On the one hand, this smells like a planner hint.  But on the other
> hand, it doesn't look like we will come up with proper graph-aware
> selectivity estimation system any time soon, so just having all graph
> OLTP queries suck until then because the planner hint is hardcoded
> doesn't seem like a better solution.  So I think this setting can be ok.

I agree. It's a bit lame, but seems pretty harmless, and I can't see
us realistically doing a lot better with any reasonable amount of
work.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



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

Предыдущее
От: Denis Laxalde
Дата:
Сообщение: Re: [PATCH] Disable bgworkers during servers start in pg_upgrade
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Support for NSS as a libpq TLS backend