Re: PG 12 slow selects from pg_settings - Mailing list pgsql-performance

From Ranier Vilela
Subject Re: PG 12 slow selects from pg_settings
Date
Msg-id CAEudQAqg-UOo3Pti3pC2AZJnPX3m-LZ7SpeG2-7cOxT1C48PGw@mail.gmail.com
Whole thread Raw
In response to Re: PG 12 slow selects from pg_settings  (Julius Tuskenis <julius.tuskenis@gmail.com>)
Responses Re: PG 12 slow selects from pg_settings
List pgsql-performance
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 by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: PG 12 slow selects from pg_settings
Next
From: Julius Tuskenis
Date:
Subject: Re: PG 12 slow selects from pg_settings