Re: psql: Greatly speed up "\d tablename" when not using regexes

Поиск
Список
Период
Сортировка
От Kirill Reshke
Тема Re: psql: Greatly speed up "\d tablename" when not using regexes
Дата
Msg-id CALdSSPjcUmVLidTTb+CANyd2TEq0tkOCe=r+xYbuhpuOePKHag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql: Greatly speed up "\d tablename" when not using regexes  (Jelte Fennema-Nio <postgres@jeltef.nl>)
Список pgsql-hackers

On Wed, 10 Apr 2024, 23:37 Jelte Fennema-Nio, <postgres@jeltef.nl> wrote:
On Wed, 10 Apr 2024 at 20:21, Kirill Reshke <reshkekirill@gmail.com> wrote:
> Do we need to force Collaction here like in other branches?
> if (PQserverVersion(conn) >= 120000)
>    appendPQExpBufferStr(buf, " COLLATE pg_catalog.default");

According to the commit and codecomment that introduced the COLLATE,
it was specifically added for correct regex matching (e.g. \w). So I
don't think it's necessary, and I'm pretty sure adding it will cause
the index scan not to be used anymore.

Ok, thanks for the clarification. If all of this is actually true, and patch is really does speedup, maybe we need to state this in the comments?

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jelte Fennema-Nio
Дата:
Сообщение: Re: psql: Greatly speed up "\d tablename" when not using regexes
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: broken JIT support on Fedora 40