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 1rCcbW-00GfH4-2L for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Dec 2023 09:29:34 +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 1rCcbU-00ChUx-GO for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Dec 2023 09:29:32 +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 1rCcbU-00ChUn-6y for pgsql-hackers@lists.postgresql.org; Mon, 11 Dec 2023 09:29:32 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rCcbS-00BMDG-K1 for pgsql-hackers@postgresql.org; Mon, 11 Dec 2023 09:29:31 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id DA5375C01F5; Mon, 11 Dec 2023 04:29:28 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Mon, 11 Dec 2023 04:29:28 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to; s=fm3; t=1702286968; x=1702373368; bh=FTEwoTG04hti0BI57DwVYZsWS ec/M9CtaQHGrLy3tsw=; b=Wtl92XS4mOLxbm+S7LsQXhWmCykPuBWNQSo3e3UFY WB5M5CrAPOJ8j0tEzYkOGDWQtAfUgPaos7XV8rUEB9TW42t+sWl896I5tFnxYGa2 J0t3P3/pEz6W72CH8AaJEuv5gwAvepnXs5GF0s5K0Ndzx21Zr77NgvkVv4c9wS/w xo3OUREtAkJoJxOiNn78Bn+rYrvi4V+ZzLkRKA/qpme835+FKXJJM19wwsty6G+M +3Jx5ltLDhCbICY1bTSXEBiied1VeRbR32cuBx/X9LdfwKXb5vHR0nJ+cYS2Hg5N YsUDCF4p+INiby3G8DoICWf9aGlAHI6VjmtuYEMy8bMnQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1702286968; x=1702373368; bh=FTEwoTG04hti0BI57DwVYZsWSec/M9CtaQH GrLy3tsw=; b=JGWwT/0prJwhdSqqeFE8ud+DFzZVuSsjy+MAfcYn33SEBXzlSwR PbEy+9SWNer+xmpTgAMSprGciznsgffyfe5uFH7LSK0v1UdFs2Zf8Tm8fWGLt2hB 21p2tpgWftfP6GMmv85kydsjNQQLepfkfL5+milvUgRdvMdhuMPGt9nCgmQ1J2d8 g+4Os1GLR148mINi4A2xSvk7C4uxVD/eKOPNS9fLjqBpWkV7OJGTmF3a2qWpgaEY ew/8gZiKRXD3PexzWf4xiRTriYCkvuwL6vuiTwITEwj9CwMeagn80bZZCQ6fx9z4 5V1yZ+i30Hot1IJLIq6IOIxxYg1HNjdD53Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudelvddgtdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh eqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileehteeljeeghfeuledthfeu tedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 11 Dec 2023 04:29:27 -0500 (EST) Message-ID: <60705ae9-6f2a-4a04-8416-a096b4ff11d5@eisentraut.org> Date: Mon, 11 Dec 2023 10:29:26 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: backtrace_on_internal_error Content-Language: en-US To: Andres Freund , Tom Lane Cc: pgsql-hackers References: <93f32d1a-9309-48dc-9b7f-c110c4d48126@eisentraut.org> <1266459.1701958930@sss.pgh.pa.us> <1439034.1702047909@sss.pgh.pa.us> <20231208181451.deqnflwxqoehhxpe@awork3.anarazel.de> From: Peter Eisentraut In-Reply-To: <20231208181451.deqnflwxqoehhxpe@awork3.anarazel.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 08.12.23 19:14, Andres Freund wrote: > FWIW, I did some analysis on aggregated logs on a larger number of machines, > and it does look like that'd be a measurable increase in log volume. There are > a few voluminous internal errors in core, but the bigger issue is > extensions. They are typically much less disciplined about assigning error > codes than core PG is. Good point. Also, during development, I often just put elog(ERROR, "real error later").