Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)

Поиск
Список
Период
Сортировка
От MichaelDBA
Тема Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Дата
Msg-id 759b87bb-b3c7-6c39-4297-26a2777f9836@sqlexec.com
обсуждение исходный текст
Ответ на How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)  (Maxim Boguk <maxim.boguk@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Well if you find out for sure, please let me know.  I'm very interested in the outcome of this problem.

Maxim Boguk wrote on 1/5/2023 6:44 AM:


On Thu, Jan 5, 2023 at 1:31 PM MichaelDBA <MichaelDBA@sqlexec.com> wrote:

What happens if you take pg_stat_statements out of the picture (remove from shared_preload_libraries)?  Does your BIND problem go away?

I didn't test this idea, because it requires restart of the database (it cannot be done quickly) and without pg_stat_statements there will be no adequate performance monitoring of the database.
But I'm pretty sure that the issue will go away with pg_stat_statements disabled.

--
Maxim Boguk
Senior Postgresql DBA
https://dataegret.com/

Phone UA: +380 99 143 0000
Phone AU: +61  45 218 5678




В списке pgsql-performance по дате отправления:

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Следующее
От: Joe Wildish
Дата:
Сообщение: Max write throughput for single COPY