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

Поиск
Список
Период
Сортировка
От Jelte Fennema-Nio
Тема Re: psql: Greatly speed up "\d tablename" when not using regexes
Дата
Msg-id CAGECzQT70CNxDm+ZWJXL_f_=Q0Sr04YtaUo9PZMmEmxPjHh+DA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql: Greatly speed up "\d tablename" when not using regexes  (Kirill Reshke <reshkekirill@gmail.com>)
Ответы Re: psql: Greatly speed up "\d tablename" when not using regexes
Список pgsql-hackers
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.



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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Fix resource leak (src/backend/libpq/be-secure-common.c)
Следующее
От: Kirill Reshke
Дата:
Сообщение: Re: psql: Greatly speed up "\d tablename" when not using regexes