pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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
------
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

* 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


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