Re: PG 12 slow selects from pg_settings

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема Re: PG 12 slow selects from pg_settings
Дата
Msg-id CAGfhecjDZdSmzJb3f6ZfA8Cc48oFVCy4bki102_5zSKqgc=4YQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG 12 slow selects from pg_settings  (Ranier Vilela <ranier.vf@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Thank you, Ranier.

It's amazing how much effort and work that issue caused! Thank You and all involved!

Regards,
Julius Tuskenis

2021-10-08, pn, 15:50 Ranier Vilela <ranier.vf@gmail.com> rašė:
Em sex., 8 de out. de 2021 às 09:06, Julius Tuskenis <julius.tuskenis@gmail.com> escreveu:
Thank you,  Ranier, 

v12.8 has improved the performance

PostgreSQL 12.8, compiled by Visual C++ build 1914, 64-bit:
```
Function Scan on pg_show_all_settings a  (cost=0.00..12.50 rows=5 width=485) (actual time=7.122..7.128 rows=1 loops=1)
  Filter: (name = 'standard_conforming_strings'::text)
  Rows Removed by Filter: 313
Planning Time: 0.083 ms
Execution Time: 7.204 ms
```

Would you please direct me to the change log or some bug report to read in detail what was causing the problem and how it was fixed?
The history is long, but if you want to read.

regards,
Ranier Vilela

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

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: Re: PG 12 slow selects from pg_settings
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle