[MASSMAIL]psql: Greatly speed up "\d tablename" when not using regexes

Поиск
Список
Период
Сортировка
От Jelte Fennema-Nio
Тема [MASSMAIL]psql: Greatly speed up "\d tablename" when not using regexes
Дата
Msg-id CAGECzQRqysy0eJMKR5he3gwtLrT87f9u5CQQua6B_XNwMnUtFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql: Greatly speed up "\d tablename" when not using regexes  (Greg Sabino Mullane <htamfids@gmail.com>)
Re: psql: Greatly speed up "\d tablename" when not using regexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: psql: Greatly speed up "\d tablename" when not using regexes  (Kirill Reshke <reshkekirill@gmail.com>)
Список pgsql-hackers
Running "\d tablename" from psql could take multiple seconds when
running on a system with 100k+ tables. The reason for this was that
a sequence scan on pg_class takes place, due to regex matching being
used.

Regex matching is obviously unnecessary when we're looking for an exact
match. This checks for this (common) case and starts using plain
equality in that case.

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Speed up clean meson builds by ~25%
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Issue with the PRNG used by Postgres