Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] CREATE STATISTICS and join selectivity - Mailing list pgsql-performance

From David Rowley
Subject Re: [PERFORM] CREATE STATISTICS and join selectivity
Date
Msg-id CAKJS1f-6B7KnDFrh6SFhYn-YbHYOXmDDAfd0XC=jJKZMCrfQyg@mail.gmail.com
Whole thread Raw
In response to [PERFORM] CREATE STATISTICS and join selectivity  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view 
On 16 November 2017 at 09:19, Justin Pryzby <pryzby@telsasoft.com> wrote:
> I just noticed that PG10 CREATE STATISTICS (dependencies) doesn't seem to work
> for joins on multiple columns; is that right?

Unfortunately, for now, they're not used for join selectivity
estimates, only for the base rel selectivities. That's all there was
time for with PG10. This is highly likely to be improved sometime in
the future.

-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: [PERFORM] CREATE STATISTICS and join selectivity
Next
From: Neto pr
Date:
Subject: [PERFORM] POWA doesn't show queries executed