Re: Do we need an index on pg_constraint.confrelid?

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Do we need an index on pg_constraint.confrelid?
Date: 2026-10-24 15:35:33
Message-ID: atzPo210J1Ymg478@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Oct-24, David Rowley wrote:

> I then tried out patching Postgres to add an index on
> pg_constraint(confrelid). The times I got were:

Yeah, we have a patch to add this already; see the thread at
https://postgr.es/m/trinity-08d3329b-f6b2-4c11-91d7-2198e50bf4fc-1790681922354@trinity-msg-rest-gmx-gmx-live-58cc8f554d-c56lm

Feel free to grab that for commit if you have the time and inclination,
with my thanks.

Regards

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2026-10-24 16:01:07 Re: Reject incompatible options specified with VACUUM ONLY_DATABASE_STATS
Previous Message Tatsuya Kawata 2026-10-24 14:44:16 Re: [PATCH] Add memory/disk usage for Function Scan nodes in EXPLAIN