Re: Planner misestimation for JOIN with VARCHAR - Mailing list pgsql-general

From Michael Lewis
Subject Re: Planner misestimation for JOIN with VARCHAR
Date
Msg-id CAHOFxGq8JefZXOA7_QLbNKMLiXusP0B1E4rrwHb-gh53cLrG7Q@mail.gmail.com
Whole thread Raw
In response to Re: Planner misestimation for JOIN with VARCHAR  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Planner misestimation for JOIN with VARCHAR  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
the join selectivity functions have yet to learn about extended statistics.

That is very interesting to me. So, extended statistics would help to properly estimate the result set coming out of a single table when comparing each of those columns to one or many values, but not when joining up another table? Is that on a roadmap or in progress as far as you know?

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Planner misestimation for JOIN with VARCHAR
Next
From: Dan shmidt
Date:
Subject: Logical replication stuck in catchup state