Re: should we have a fast-path planning for OLTP starjoins?

On Sun, Nov 23, 2025 at 9:39 AM Tomas Vondra <tomas(at)vondra(dot)me> wrote:
> > 1. I do not think I believe the premise that the dimension tables
> > typically won't have restriction clauses. ISTM that a typical
> > query might be like
> >
> > select sum(o.total_price) from
> > orders o
> > join customers c on c.id = o.c_id
> > join products p on p.id = o.p_id
> > where c.customer_name = 'Wile E Coyote'
> > and p.product_name = 'Rocket Skates';
> >
>
> Good question. I don't have a great evidence such joins to dimensions
> (without additional restrictions) are a common case. It's partially a
> guess and partially based on my past experience.

In my experience, restriction clauses on dimension tables are very common.

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