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

On Thu, Jan 5, 2023 at 1:31 PM MichaelDBA 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 wi

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

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 > wrote: What happens if you takepg_stat_statements out of the picture

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?

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

On Sat, Dec 31, 2022 at 2:26 PM Maxim Boguk wrote: > Hi, > > When performing post-mortem analysis of some short latency spikes on a > heavily loaded database, I found that the reason for (less than 10 second > latency spike) wasn't on the EXECUTE stage but on the BIND stage. > At the same time gr