Re: PG 12 slow selects from pg_settings

2021-10-08 Thread Julius Tuskenis
> The history is long, but if you want to read. > https://www.postgresql.org/message-id/flat/7ff352d4-4879-5181-eb89-8a2046f928e6%40dunslane.net 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

Re: PG 12 slow selects from pg_settings

2021-10-08 Thread Ranier Vilela
Em sex., 8 de out. de 2021 às 09:06, Julius Tuskenis < [email protected]> 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

Re: PG 12 slow selects from pg_settings

2021-10-08 Thread Julius Tuskenis
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) Ro

Re: PG 12 slow selects from pg_settings

2021-10-08 Thread Ranier Vilela
Em sex., 8 de out. de 2021 às 04:01, Julius Tuskenis < [email protected]> 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. > > ``` >

PG 12 slow selects from pg_settings

2021-10-08 Thread Julius Tuskenis
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_s