[doc] plan invalidation when statistics are update

Поиск
Список
Период
Сортировка
От torikoshia
Тема [doc] plan invalidation when statistics are update
Дата
Msg-id 3ac82f4817c9fe274a905c8a38d87bd9@oss.nttdata.com
обсуждение исходный текст
Ответы Re: [doc] plan invalidation when statistics are update
Список pgsql-hackers
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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: torikoshia
Дата:
Сообщение: [doc] adding way to examine the plan type of prepared statements
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] logical decoding of two-phase transactions