Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSgux-00FIHV-Rr for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 17:20:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rSguw-006pgJ-P3 for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 17:20:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSguw-006pgB-FN for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 17:20:02 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rSgup-003VUf-RJ for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 17:20:01 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-a26ed1e05c7so646173766b.2 for ; Wed, 24 Jan 2024 09:19:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706116794; x=1706721594; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=w4t3hc5PD35QpD1xab54PAwAmu1EZxGUPOhtjCBve+4=; b=VoY4ceB/q88xHKLmX7ibzmUn0yuQTIANG/MsQWb2uO+TVXJotoDhz9eTHy8BNOeT4W Mg8VUeNFhD0jLDDbO7jNCHx1IXLWby0I1F6GFgqDAHwcEuc/iRBCIVqJEciWrGA4mA2v tDT/TWgHO3yQCZOrHDvXnwNqHLJ1KFSAlVTmcgoEKtfGqBpea4L1ZiRjchUrzD6zBy50 T7A4VM74JkvxO8qXCUNOKmM1l59Xsn9Pz63OVYiXUeFWapFfUQ7r+kF7PvMLCFdrldWv 0YqsZBNtb3DnsIkaayYjqsOzJx0rUnJsojs2MPUSHFChhdXTGK+8i2jy+zSTLh1v3CiA 3oRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706116794; x=1706721594; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=w4t3hc5PD35QpD1xab54PAwAmu1EZxGUPOhtjCBve+4=; b=e2vQaWNzGubOpphhRGxsB9sQu61WKKOkUswoQ+5vxgrPHSvMPTXehMhM0uLcvxV3BO Vs2Wbj9WaOWiwYaNNgtsHH1uTsv4yEPSpXiIcug8lFwytTKo3pbXsIaqMzMgTvuIlhor 7RSzScRnwuRL+tjCO5Z3q2Fdnt0NntualIMsVWdlHlB4Y7KdDLPfe9caC9MxyJRGcgWU W6hBe8vpqU6k8i75S+l7X21TAkIvXYr3nPyV61btiNuXooLcnCgB4FqU8JUvjJG9Jlho FLV4Sye1TL4fbORB60mVPW+/cMh1mJTJISMHOM2f/clAfHUiTLsQLyUlyC85Axvn39oi l4Ug== X-Gm-Message-State: AOJu0YyRwXgKeV/KnxIAsv8muQ7QcbKiAW++Gvxss9o10XCUWn9gvP6i +Dadpr3j95DlL6Ev+d3rkf9HqN1XOBgfsp1nMah+jCaSzoShB1gv X-Google-Smtp-Source: AGHT+IHVIdHyj0vKgjHwSk1bclumviXU/gC9KyFMocRcfnqGiamwmZmQ97XsNKW4hBFvRDlEgjRRzA== X-Received: by 2002:a17:907:3a03:b0:a28:6600:3b7f with SMTP id fb3-20020a1709073a0300b00a2866003b7fmr625615ejc.197.1706116794352; Wed, 24 Jan 2024 09:19:54 -0800 (PST) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:10cd:8701:ed11:b7eb:8de7:fbd6]) by smtp.gmail.com with ESMTPSA id r17-20020a1709067fd100b00a2c7d34157asm84877ejs.180.2024.01.24.09.19.53 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Jan 2024 09:19:53 -0800 (PST) Message-ID: <65b146b9.170a0220.c645b.0891@mx.google.com> X-Google-Original-Message-ID: <20240124171953.GE17618@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1rSgun-0004AF-C5; Wed, 24 Jan 2024 18:19:53 +0100 Date: Wed, 24 Jan 2024 18:19:53 +0100 From: Michael Banck To: Laurenz Albe Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Set log_lock_waits=on by default References: <659ffa38.170a0220.eea6a.28fc@mx.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <659ffa38.170a0220.eea6a.28fc@mx.google.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, Jan 11, 2024 at 03:24:55PM +0100, Michael Banck wrote: > On Thu, Dec 21, 2023 at 02:29:05PM +0100, Laurenz Albe wrote: > > Here is a patch to implement this. > > Being stuck behind a lock for more than a second is almost > > always a problem, so it is reasonable to turn this on by default. > > I also think that this should be set to on. > > I had a look at the patch and it works fine. > > Regarding the documentation, maybe the back-reference at > deadlock_timeout could be made a bit more explicit then as well, as in > the attached patch, but this is mostly bikeshedding. I've marked it ready for committer now, as the above really is bikeshedding. Michael