Postgres Pro
Downloads
Home   >   mailing lists

Re: psql: Greatly speed up "\d tablename" when not using regexes - Mailing list pgsql-hackers

From Jelte Fennema-Nio
Subject Re: psql: Greatly speed up "\d tablename" when not using regexes
Date
Msg-id CAGECzQS7-564414-vV+XrPBj=4gHW6mPT8eObjq5=RrEseRcAw@mail.gmail.com
Whole thread Raw
In response to Re: psql: Greatly speed up "\d tablename" when not using regexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql: Greatly speed up "\d tablename" when not using regexes
List pgsql-hackers
Tree view 
On Wed, 10 Apr 2024 at 20:06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Really?  ISTM this argument is ignoring an optimization the backend
> has understood for a long time.

Interesting. I didn't know about that optimization. I can't check
right now, but probably the COLLATE breaks that optimization.

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: Fix resource leak (src/backend/libpq/be-secure-common.c)
Next
From: Daniel Gustafsson
Date:
Subject: Re: Fix resource leak (src/backend/libpq/be-secure-common.c)