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

From: Manu <manuelreyesbravo(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Do we need an index on pg_constraint.confrelid?
Date: 2026-11-12 22:30:29
Message-ID: 179452262986.299086.18237885640920645965@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Álvaro,

On Thu, Nov 12, 2026 at 3:29 PM Álvaro Herrera <alvherre(at)kurilemu(dot)de>
wrote:
> I have pushed this with a catversion bump, but omitted the new
> stats.sql test. (I also renamed the new index.)

Thanks for pushing it, b0496e30830, and for the review along the way.
Thanks too to Tom for suggesting the plain index, and to David and
Bernhard for the reports this started from.

I'll add an XXX note to the commit message when I leave a catversion
bump out, as you suggested.

Regards,
Manu

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Robert I Nilsson 2026-11-12 22:22:33 Re: [PATCH] Fix SASLprep validation after NFKC normalization