pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix planner failure with extended statistics on partitioned tabl 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix planner failure with extended statistics on partitioned tabl @ 2022-11-01 18:34 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-11-01 18:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix planner failure with extended statistics on partitioned tables. Some cases would result in "cache lookup failed for statistics object", due to trying to fetch inherited statistics when only non-inherited ones are available or vice versa. Richard Guo and Justin Pryzby Discussion: https://postgr.es/m/20221030170520.GM16921@telsasoft.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/f4857082bc16f36a5cdc6f8328cdc8071bb1715e Modified Files -------------- src/backend/utils/adt/selfuncs.c | 11 +++++++++-- src/test/regress/expected/stats_ext.out | 8 +++++++- src/test/regress/sql/stats_ext.sql | 3 ++- 3 files changed, 18 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix planner failure with extended statistics on partitioned tabl @ 2022-11-01 18:34 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-11-01 18:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix planner failure with extended statistics on partitioned tables. Some cases would result in "cache lookup failed for statistics object", due to trying to fetch inherited statistics when only non-inherited ones are available or vice versa. Richard Guo and Justin Pryzby Discussion: https://postgr.es/m/20221030170520.GM16921@telsasoft.com Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1f1865e9083625239769c26f68b9c2861b8d4b1c Modified Files -------------- src/backend/utils/adt/selfuncs.c | 11 +++++++++-- src/test/regress/expected/stats_ext.out | 8 +++++++- src/test/regress/sql/stats_ext.sql | 3 ++- 3 files changed, 18 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-01 18:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-11-01 18:34 pgsql: Fix planner failure with extended statistics on partitioned tabl Tom Lane <tgl@sss.pgh.pa.us> 2022-11-01 18:34 pgsql: Fix planner failure with extended statistics on partitioned tabl Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox