pgsql: doc: Note that plan advice does not affect cached plans

Поиск
Список
Период
Сортировка
Искать

pgsql: doc: Note that plan advice does not affect cached plans

От:
Robert Haas <rhaas@postgresql.org>
Дата:
doc: Note that plan advice does not affect cached plans

Plan advice is consulted only at plan time.  When a cached plan is
re-executed, no re-planning occurs, so updated advice has no effect.
DISCARD PLANS can be used to discard cached plans, but only affects
the sessions in which it is executed.

Reported-by: Noah Misch 
Suggested-by: Jakub Wartak 
Discussion: https://postgr.es/m/20260827171830.68.noahmisch@microsoft.com
Co-authored-by: Dongpo Liu 
Co-authored-by: Robert Haas 
Backpatch-through: 19

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/26bd08fb5c069fbdf55867adc398cfca0f55d5c8

Modified Files
--------------
doc/src/sgml/pgplanadvice.sgml  | 12 ++++++++++++
doc/src/sgml/pgstashadvice.sgml |  8 ++++++++
2 files changed, 20 insertions(+)

FAQ