Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND
 on production database (or BIND vs log_lock_waits)
To: Maxim Boguk <maxim.boguk@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
References: 
 <CAK-MWwSfx7SmUQ=_rB4q61sE8uP6LqH-1wM0DSYyBadjBe9BDw@mail.gmail.com>
 <CAK-MWwRxnjLTTTkM_muvBrHMoYYbT5xYFm=5cML9Q+SfRAwkXQ@mail.gmail.com>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <103b95ea-75d1-0a1e-9fed-817c17f31b0f@sqlexec.com>
Date: Thu, 5 Jan 2023 06:31:46 -0500
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.59
MIME-Version: 1.0
In-Reply-To: 
 <CAK-MWwRxnjLTTTkM_muvBrHMoYYbT5xYFm=5cML9Q+SfRAwkXQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------F0F35397413761CD79C31E97"
Content-Language: en-US
UI-OutboundReport: notjunk:1;M01:P0:6Uc67z6AwHA=;a/9tnduP+CvK8JyQTZ1vohxplld
 ppTdxpzzLynEUbab7Tr3CWqpWqzXGVt1xEiWTz4nLeJdGAWb4Gw5ic1KusU3y6D0xmgznSMC6
 /MI54dTKUIPxLHwblH1sBgpeDese843V8SE+2hRbYaW4PaET3gltr2qbGXEf9EJI2lhPgXcdm
 Kx8vR7opAcpbB0rfuCM3vCnj9JPFkbbu8gP92NUvMwGysfY3f9Lf/QuoxVxUBR9MbcZAuBfod
 IVAzyjafGrb1d5FfDnGJ/9FlYD8wyLSXDSidADCWTeK0aK2ErAghFKaMZl7G231NgJjJUmPlP
 P83G/rT+g0WCWPWsfxL3rml2gYC/C5K2ZnexMu3KlMCRPE0HH2UR4IjESA3qh00d7MjtO1l9O
 DbIvAhQgWeRefVubFkMaYmK1aYYbxpecB5lBirwS7MQHcGewXYmVYPquuRi2FH3HToNw3cQxu
 c9/fDUoB3BxhLMWXiicAlsrQLCOdggB2YESkbRX+R3FcvKuXgeHFeBodUAacpxc4/XF1KPSNM
 v9jaafQ0fPg6NeyNfhJnqwRUcSzkutvWhPZRJ2XK4h0VwvdA5TnRZTLUeo2xplTtSgATVNdDN
 pDLHWrCo4c5+5mOBDKM1gq/6e/Gj+Xc+hsQ3N3WMjsN2BrDX6k718QhnlD1GyjB2cYTU1XDjj
 g2Ku5MkIT06uGcwkYR+N6tR3tM/LTcjaEblnW/PXBQ==
Archived-At: 
 <https://www.postgresql.org/message-id/103b95ea-75d1-0a1e-9fed-817c17f31b0f%40sqlexec.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------F0F35397413761CD79C31E97
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit


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

--------------F0F35397413761CD79C31E97
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html theme="default-light" iconset="color"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000"><br>
What happens if you take <span style="font-weight: bold;">pg_stat_statements
 </span>out of the picture (<span style="font-weight: bold;">remove from
 shared_preload_libraries</span>)?  Does your BIND problem go away?<br>
</body></html>

--------------F0F35397413761CD79C31E97--