Re: Parameter for planner estimate of recursive queries - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Parameter for planner estimate of recursive queries
Date
Msg-id CA+TgmoaGDw2baysiK+qqL+c3roa-9cPSvJ_Kwdgx7RoPQR0TaA@mail.gmail.com
Whole thread Raw
In response to Re: Parameter for planner estimate of recursive queries  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: Parameter for planner estimate of recursive queries
Re: Parameter for planner estimate of recursive queries
List 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 by date:

Previous
From: Denis Laxalde
Date:
Subject: Re: [PATCH] Disable bgworkers during servers start in pg_upgrade
Next
From: Daniel Gustafsson
Date:
Subject: Re: Support for NSS as a libpq TLS backend