Re: PG 12 slow selects from pg_settings

Em sex., 8 de out. de 2021 às 04:01, Julius Tuskenis <
julius(dot)tuskenis(at)gmail(dot)com> escreveu:

> Dear PostgreSQL community,
>
> we have noticed a severe decrease in performance reading
> pg_catalog.pg_settings table in PostgreSQL 12 on MS Windows 10 machines
> compared to earlier versions.
>
> ```
> explain (analyze, buffers, timing)
> SELECT * from pg_catalog.pg_settings where name =
> 'standard_conforming_strings';
> ```
>
> On *PostgreSQL 12.5, 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=343.350..343.356 rows=1 loops=1)
> Filter: (name = 'standard_conforming_strings'::text)
> Rows Removed by Filter: 313
> Planning Time: 0.079 ms
> Execution Time: 343.397 ms
>
You can try 12.8 which is available now, there is a dll related fix that
can make some improvement.

regards,
Ranier Vilela