pgsql: Temporarily install debugging in partition_prune test

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Temporarily install debugging in partition_prune test
Date: 2024-03-21 08:21:34
Message-ID: E1rnDg6-004uT1-77@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Temporarily install debugging in partition_prune test

The buildfarm animal parula has been sporadically failing in the
partition_prune test for the past week or so. It appears like an
auto-vacuum or auto-analyze has run on one of the partitions of the "ab"
table, causing the plan to change. This is unexpected as the table is
empty.

Here we install some telemetry to find out if this is the case. This
also joins in pg_index to see if something has gone wrong with the index
which could result in the planner being unable to use that index.

We can revert this once we've figured out the cause of the plan
instability.

Reported-by: Tom Lane
Investigation-by: Tom Lane
Discussion: https://postgr.es/m/4009739.1710878318%40sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1db689715d44276407dc4d6fadbc11da8d391bd9

Modified Files
--------------
src/test/regress/expected/partition_prune.out | 62 +++++++++++++++++++++++++++
src/test/regress/sql/partition_prune.sql | 14 ++++++
2 files changed, 76 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Daniel Gustafsson 2024-03-21 14:08:55 pgsql: Explicitly require password for SCRAM exchange
Previous Message Amit Langote 2024-03-21 08:07:37 pgsql: Add SQL/JSON query functions