Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) - Mailing list pgsql-performance
From
MichaelDBA
Subject
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
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_statementsthere 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.
From:
Maxim Boguk Date: Subject:
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)