[doc] plan invalidation when statistics are update
torikoshia <torikoshia@oss.nttdata.com>
From: torikoshia <torikoshia@oss.nttdata.com>
To: pgsql-hackers@postgresql.org
Date: 2020-11-18T02:04:53Z
Lists: pgsql-hackers
Attachments
- v1-0001-add-an-example-of-replanning-generic-plan.patch (text/x-diff) patch v1-0001
Hi, AFAIU, when the planner statistics are updated, generic plans are invalidated and PostgreSQL recreates. However, the manual doesn't seem to explain it explicitly. https://www.postgresql.org/docs/devel/sql-prepare.html I guess this case is included in 'whenever database objects used in the statement have definitional (DDL) changes undergone', but I feel it's hard to infer. Since updates of the statistics can often happen, how about describing this case explicitly like an attached patch? Regards, -- Atsushi Torikoshi
Commits
-
doc: Add description about re-analysis and re-planning of a prepared statement.
- 4a36eab79a19 14.0 landed