On 16 November 2017 at 09:19, Justin Pryzby 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
I just noticed that PG10 CREATE STATISTICS (dependencies) doesn't seem to work
for joins on multiple columns; is that right?
With statistics on table for 2017 but not 20171110:
ts=# CREATE STATISTICS x ON site_id,sect_id FROM eric_enodeb_cell_2017;
ts=# ANALYZE VERBOSE eric_enodeb_cell_20