| From: | Julius Tuskenis <julius(dot)tuskenis(at)gmail(dot)com> |
|---|---|
| To: | Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> |
| Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PG 12 slow selects from pg_settings |
| Date: | 2021-10-08 13:49:55 |
| Message-ID: | CAGfhecjDZdSmzJb3f6ZfA8Cc48oFVCy4bki102_5zSKqgc=4YQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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 Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> rašė:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2021-10-08 15:12:00 | Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle |
| Previous Message | Ranier Vilela | 2021-10-08 12:50:03 | Re: PG 12 slow selects from pg_settings |