Re: PG 12 slow selects from pg_settings

Em sex., 8 de out. de 2021 às 09:06, Julius Tuskenis <
julius(dot)tuskenis(at)gmail(dot)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.
https://www.postgresql.org/message-id/flat/7ff352d4-4879-5181-eb89-8a2046f928e6%40dunslane.net

regards,
Ranier Vilela