| From: | torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | [doc] plan invalidation when statistics are update |
| Date: | 2020-11-18 02:04:53 |
| Message-ID: | 3ac82f4817c9fe274a905c8a38d87bd9@oss.nttdata.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-add-an-example-of-replanning-generic-plan.patch | text/x-diff | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2020-11-18 02:23:56 | Re: [HACKERS] logical decoding of two-phase transactions |
| Previous Message | torikoshia | 2020-11-18 02:04:34 | [doc] adding way to examine the plan type of prepared statements |