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 1u2A0X-00DxL0-7b for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 14:32:57 +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 1u2A0V-009Rhl-Eh for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 14:32:55 +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 1u2A0V-009RhY-4d for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 14:32:55 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2A0T-0049D0-0X for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 14:32:55 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-ac2a81e41e3so1017948966b.1 for ; Tue, 08 Apr 2025 07:32:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1744122771; x=1744727571; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=OnOo2rKcS58KVEDY0SF2p9+T9nwquk80TWB1WiKLfQk=; b=C8Th0aEEOf5g6N84whdg2ob4vNZ/XSSa1KM6DmDfgyiapeW6KCdH18XmH+OrXQgLd+ xSJTKUJ8tUTJCSdiTHwbM8UZeLR+4qbbZAj4fz/i/6TGtvUl0oEFvre5fjEZe6CaItde JdUVinhBWj7xQ0ostvYvWLvor3ZBrgT2Y441jEV6Z5jo8VVMDLcw5lOsRRJ8Hde9NbG0 WzEkJtHcz8PN1VU4uvPGFgSUP+Ijez0GO66ZliDJj23+AlIlWDu2w5LqKjzJkddZWxB3 PynG7JnriAop/xdVZZD1813baxNadrtllT4bZljnR2sOJQEVm0PQoyv5TLuLXBYSqKCD urGA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744122771; x=1744727571; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=OnOo2rKcS58KVEDY0SF2p9+T9nwquk80TWB1WiKLfQk=; b=v0/HwoQE01f4VChPAcQhNjbwN7W+5/fJKbopar7Itcoi26CVYV3zsOZtmCta61/RnC 2qZ1VgIZ0q3nr5ndWXLWc55tPlcAjQQHnpBciOrgw9qO5MFpD48HHXGZV6rNM3pQpK2u LIlaB/+8l859VWjPIeAyBimVL7Sq7Atrwb4Ps289D5Xn9aYfWrse6Rq6mxiz8+Rzq2Th YWaJ4Lbz+h4P6qzvX7J+QfuK9mwGq3AjLbyzD4bRRM9w7/ntN8LPmRBZCjbkBZ4xZyBk OYVNKuCnO4LWx0hI9+5+QXk1CL83pI3Mu00CdX4Ha9UIF0g3oUsvLsRXMtG++kuWAywo R7CA== X-Forwarded-Encrypted: i=1; AJvYcCX+a1esMT+1xSolb45CO3gbWKpXD58bZfEZ+nGvwiLgybol7R5EYR/zToXL9XDyYCrmOjOetf/NOMWCSRYS@lists.postgresql.org X-Gm-Message-State: AOJu0YyNZd1uxRk2D5zjN6tIUmsixlWNGJtuhePIUozIJEHIWZrOnvzv Qk1L6fkAIcHNbmBJBaf94DarRiiDcOEvh/SB9WUTRBWgswTIM6/IAeeauNQ9Mc0= X-Gm-Gg: ASbGncu6xV+gVQ6v76JijOTrReSQh26dLDX1Du7N54X9Ri+nZQc+Z843BrvdlGVM6L4 B3iP02R5KrUR4dNoqI8xB5zX0AxqQjWyQVUkmAXdfQXs7PvWQ+MbsTIybeVRvVplbvgL0LWRwd5 nTvjARvrOWJ3zXZJ1cp/V7Kt0JjFJEoLtz3Xe7BNuAULdQjC9zbt+ZfNhU+kXiDVNKViy7c8P5c NFZ1/wmojdm2EHHPKNNZILqppnQxhxg7lErh9/7ZVxX8uf/rZFQeoRNqMHJfJhjmhGdwaAUdcgX e5ag9ERZ0QWeO7Aa8HTr4NTM0v5fOkbIn0kRVJEljbmQWt53fV3W6/+Zx21OEg== X-Google-Smtp-Source: AGHT+IFxFST6Km3bwBA3hwV7LSqyWgY3i+MUYiPUYmAWVGXmHr9IvVLvvOa5mvOT/FTAQnIupd661Q== X-Received: by 2002:a17:907:7f0f:b0:abf:749f:f719 with SMTP id a640c23a62f3a-ac7e7116b2bmr1253891766b.7.1744122771092; Tue, 08 Apr 2025 07:32:51 -0700 (PDT) Received: from localhost.localdomain ([41.66.99.137]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ac7bfe996easm931878166b.55.2025.04.08.07.32.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 08 Apr 2025 07:32:50 -0700 (PDT) Message-ID: Subject: Re: Set log_lock_waits=on by default From: Laurenz Albe To: Michael Banck , Tom Lane Cc: Nathan Bossart , pgsql-hackers@lists.postgresql.org Date: Tue, 08 Apr 2025 16:32:49 +0200 In-Reply-To: <5dc4e037f60467da7bf7d17b10f6ec632a7c9095.camel@cybertec.at> References: <659ffa38.170a0220.eea6a.28fc@mx.google.com> <65b146b9.170a0220.c645b.0891@mx.google.com> <20240206165343.GA3841415@nathanxps13> <524751.1707240550@sss.pgh.pa.us> <6698edb4.5d0a0220.df6fa.5b59@mx.google.com> <5dc4e037f60467da7bf7d17b10f6ec632a7c9095.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2024-07-19 at 11:54 +0200, Laurenz Albe wrote: > On Thu, 2024-07-18 at 12:25 +0200, Michael Banck wrote: > > this patch is still on the table, though for v18 now. > >=20 > > Nathan mentioned up-thread that he was hesitant to commit this without > > further discussion. Laurenz, Stephen and I are +1 on this, but when it= =20 > > comes to committers having chimed in only Tom did so far and was -1. > >=20 > > Are there any others who have an opinion on this? >=20 > If we want to tally up, there were also +1 votes from Christoph Berg, > Shinya Kato, Nikolay Samokhvalov, Jeremy Schneider and Fr=C3=A9d=C3=A9ric= Yhuel. >=20 > The major criticism is Tom's that it might unduly increase the log volume= . >=20 > I'm not trying to rush things, but I see little point in kicking a trivia= l > patch like this through many commitfests. If no committer wants to step > up and commit this, it should be rejected. Well, it didn't make v18. But this patch got enough votes in favor that I am not going to withdraw it= . Yours, Laurenz Albe