Commitc909bd8

committed

Doc: mention that extended stats aren't used for joins

Statistics defined by the CREATE STATISTICS command are only used toassist with the selectivity estimations of base relations, never forjoins. Here we mention this fact in the notes section of the CREATESTATISTICS command.Discussion:https://postgr.es/m/CAApHDvrMuVgDOrmg_EtFDZ=AOovq6EsJNnHH1ddyZ8EqL4yzMw@mail.gmail.comBackpatch-through: 11

1 parentb631182 commitc909bd8Copy full SHA for c909bd8

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -127,6 +127,12 @@ CREATE STATISTICS [ IF NOT EXISTS ] <replaceable class="parameter">statistics_na`
`127`	`127`	`reading it. Once created, however, the ownership of the statistics`
`128`	`128`	`object is independent of the underlying table(s).`
`129`	`129`	`</para>`
	`130`	`+`
	`131`	`+ <para>`
	`132`	`+ Extended statistics are not currently used by the planner for selectivity`
	`133`	`+ estimations made for table joins. This limitation will likely be removed`
	`134`	`+ in a future version of <productname>PostgreSQL</productname>.`
	`135`	`+ </para>`
`130`	`136`	`</refsect1>`
`131`	`137`
`132`	`138`	`<refsect1 id="sql-createstatistics-examples">`

Comments

(0)