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 1vHOku-0069MG-Ir for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Nov 2025 15:52: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 1vHOks-00FKhh-2v for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Nov 2025 15:52:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vHOkr-00FKhY-Iv for pgsql-bugs@lists.postgresql.org; Fri, 07 Nov 2025 15:52:01 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vHOkp-005veX-2w for pgsql-bugs@lists.postgresql.org; Fri, 07 Nov 2025 15:52:00 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfhigh.phl.internal (Postfix) with ESMTP id 80FFC14001AD; Fri, 7 Nov 2025 10:51:59 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Fri, 07 Nov 2025 10:51:59 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1762530719; x= 1762617119; bh=h9bvoOx9QCvcYXkC81WyL0iKOsHRzV+3sMnNLPMBuYc=; b=j swjlqnpPPRueeTXBz9HrbozCKpw62+mZLhsAN13aC6xcIhWGg1DKOlVTIUMwILDC WUgylZ+U2C0SXin6SkBAQoEV5ff/bzbe+Zwn027h9lQZt9h+8vEWcvBeln3SeE7i gEnH6PSSN1JEkHRxgy8fO/yuD/+nLyTKrmq42plHGpEJC/1+7q8yHFvjG8DRh9No 054+t/JWxic8CbvHTvSs/T8LibTlzO0sU+LI+48cGhJujbLnv37ylu6y/pq98dTQ m/byXvit2CPdz5JegYkmq90UuU8HlcmvR4IWfx2NV7fnNx+a3GrNHhpTG8Ravb6m qtHbk6x39SZe2kLWjzijQ== 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1762530719; x=1762617119; bh=h 9bvoOx9QCvcYXkC81WyL0iKOsHRzV+3sMnNLPMBuYc=; b=hlRxrTtqZ/sGr62if 8BRBhSmKglf+5yt1oAUeWNvP6NlbHXKUpRKMlYR7YgzxOD483L7HhtI7l/i+1H7s Ee7onAUPgcPuknYXD/jSbCq/u/r9h4AYmUG+L3224K7Z+tFbDTsW+4f43Ifh6L0J wGdAqCoP6yIwsUn+Vom6E5rYxkEi1DScYteVOarnoPJWteL4xoSgqHTqThaOdqx+ PsLgPGF2yrOsoLtovJG7G2UW1QJBG97e736wxdqXQ8SKfuGw1STDSb8w55R9ULeW 7Hpr2+KMgC05lqXQJpDltW0wjLaT62DIL6u6r8guE9ILyGYLOwz706UjvMQFf8Lp D2DPg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduledttdeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegurghvihgurdhgrdhjohhhnhhsthhonhesghhmrghilhdrtgho mhdprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqh hlrdhorhhgpdhrtghpthhtohepjhhinhhhuhhirdhlrghisehqqhdrtghomhdprhgtphht thhopehtghhlsehsshhsrdhpghhhrdhprgdruhhs X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 7 Nov 2025 10:51:58 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1762530714; bh=pmFvNPvAtYRT4JFnIyAYN15s8f05iYABwczKmZUxPsE=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=MstN+Q1Lv6FPiUrSQ/J0njl6c0KOMfuzSgb4He5wvSgSivUKIN23cndlgr0t3pq+I clBdCz108gSycRpSkPKgnB/xKkol9jMhFPjgIZsy+fIJXjdDxBOtIyoBx4xGCD1vst UkLKUonM9K6lMi4Z60PqJVfZHV2o7C+05KMX8QSXRJCsKsDAcmnW6MuddyDsSRtOF5 jr84ce2dr/gA4lrUfqGDoTXad3q9+hippIPShRcC33RHPQpkdYaHsJLMyxdjD4RBE2 46HaalgtV9FMWZxIdRVIYq8ZDKJ1Z36dVPxZYL1di9rY9nJW9+cbJZyoaIi1dZqVKx VeXy/mQLytXkA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 3ABC176; Fri, 07 Nov 2025 17:51:54 +0200 (EET) Date: Fri, 7 Nov 2025 16:51:54 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Tom Lane Cc: "David G. Johnston" , "jinhui.lai@qq.com" , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement Message-ID: <202511071550.ldw6ikbkcn4k@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <517270.1762268128@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Nov-04, Tom Lane wrote: > It is not. The reason ROLLBACK is essentially free in Postgres > is that some of the ensuing cleanup work gets done during > subsequent table accesses. Some other DBMSes do that differently, > but that's our choice and we're not likely to revisit it. At least, it's the choice we have made in heapam. It's possible to make different choices for other table AMs -- for instance, I bet OrioleDB has made a different choice here, because of its claim that vacuum is not needed. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)