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.96) (envelope-from ) id 1vVi8z-006ady-00 for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 03:24:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVi8x-009k6H-2e for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 03:24:04 +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.96) (envelope-from ) id 1vVi8x-009k68-0h for pgsql-hackers@lists.postgresql.org; Wed, 17 Dec 2025 03:24:04 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vVi8w-0014qx-16 for pgsql-hackers@lists.postgresql.org; Wed, 17 Dec 2025 03:24:02 +0000 Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-2a0d6f647e2so47525465ad.1 for ; Tue, 16 Dec 2025 19:24:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1765941841; x=1766546641; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=iTkPCGa5P3DbR3dF4yddfVMSBv//F/wkQXP46p3Q6qQ=; b=WcxjJkToc8lQlKm6aRlRWCv5rd984hyZ5MOk8u4xRYQfLkUIjIPPS+VhKWw4nnJi+5 tjaL+CdwO5Vyx1r4V6ZheUZWUicQe5EQxpJlZNeZoBPeedy+H+O0rH3MdAdGfMfXcKGa RuOsoyqk2paWTyQvfbRQm74Gl3ERHvwRoTUHU= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765941841; x=1766546641; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=iTkPCGa5P3DbR3dF4yddfVMSBv//F/wkQXP46p3Q6qQ=; b=Nu00t9mhspfDF/rALyv/Fv5EvrxQyWHbGThI+649MXvu3eI5YgGIxM742OZHTLbmWQ /OjDi/ew8O/w6B3oLwr463EeI/pjxHco0yzmRBdxfSAtiV2Q8hTGd5cKW5rxC5Jvt2o6 LRYZsRZPJS4007kX+ssZRg/YgBR7WLvcRHrKgRGtqpoqkkO8h/bCWOTmSnqCGYuZcOoG AzYoplIP6Y8UhSUET/+1oC4CN532BCoi7ZWvtIHsGx+Qrq7Ui/+KG0Q4Nbnuwp+d1t9c eQd3m1v0lXF4zf5tQSvJaoaH5PwHBdNZ8biJpnOCp8zLpzZPw+loAIiSVVJj0sjjWtMQ 1tBA== X-Forwarded-Encrypted: i=1; AJvYcCU22sM+EpNeNwYhr1AXuohJ/z6MXHP/N1+9PpEg+dK7ZaHUgSbgpcIm7ykoKwPiR7fiU0fHrwWm58SvGWRE@lists.postgresql.org X-Gm-Message-State: AOJu0YzSDzjyGmgOOmmciMLnkhNOamAnoOPadnfQsS9mCFRwfz8Or0TQ AwC5+GYQK7hsiKi+6aGJTJ8i1HWhyDiOetbWlwAYDfDVdHTwdK1vSeagHlA5qIWGNg== X-Gm-Gg: AY/fxX72O0SponXZdA+kKqqLIczaoddVyudK4l/jAybfr0rQQIMQ09SpcnUCFoUWaVS DfLpO/i5Sl2UbcNjsbjwkQTRf/PdruRrTbHojhLe6lATvvCSJrOMW7OtYINPAD3xHmsloynBFLF NKlYsYmua1zeK+BA3c+XvK5AR1qsFr10CXL6jXfX7IDsih7eqZOk5E3sO9KszJXY+JHsVXnao12 YVR90SMInCZMPAH3GftdBn2Aj/jg3IlagpbshY4y2SlquZAqe8Qgr8pyp4P7Vd9wYfCqTOVlttO V0Beci6YIRiPaJTVeykELLm9+MGpj8yvW8sOZ3dTHByawtQNBWaGjcCNqbHZE3BMR8tJwoy57k6 8qMWeDPvilTgRNMdj8IkhP/pZ9BePa7iAuo7teccDGO17wWybJP8iXNHt7x6BdzYT/qCya9GxO7 zH77/1yvqymPBNhMPLoV35GlHr+HoqPfbCp3P4HIY= X-Google-Smtp-Source: AGHT+IH7s2pbn6kbt/h0FXDaHnX53M5m0mKr8EuNyhGUwDoWeHv0Ap9KK5WgDee93gQxHtr/EupPUw== X-Received: by 2002:a05:701b:2816:b0:11b:88a7:e1ac with SMTP id a92af1059eb24-11f34bc8184mr9346428c88.19.1765941840839; Tue, 16 Dec 2025 19:24:00 -0800 (PST) Received: from google.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-11f2e153e7esm47916532c88.0.2025.12.16.19.23.59 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 16 Dec 2025 19:23:59 -0800 (PST) Date: Tue, 16 Dec 2025 19:23:57 -0800 From: Noah Misch To: Paul A Jungwirth Cc: Alexander Lakhin , Nitin Motiani , Andres Freund , Ilyasov Ian , PostgreSQL Hackers , Surya Poondla Subject: Re: Inval reliability, especially for inplace updates Message-ID: <20251217032357.32.nmisch@google.com> References: <20241101233829.9f.nmisch@google.com> <20241103182925.93.nmisch@google.com> <20250510151423.c2.nmisch@google.com> <20250824233927.89.nmisch@google.com> <20251205001902.7a.nmisch@google.com> <20251212002437.2f.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Dec 12, 2025 at 09:48:48AM -0800, Paul A Jungwirth wrote: > On Thu, Dec 11, 2025 at 4:24 PM Noah Misch wrote: > > On Thu, Dec 04, 2025 at 04:19:02PM -0800, Noah Misch wrote: > > > Thanks for the review. > > > > > The attached version doesn't need a comprehensive re-review, but I'd > > > particularly value hearing about any places where you find it's reducing > > > comprehensibility rather than enhancing. > > > > I'd like to get this into the back branches well in advance of the 2026-02 > > releases, in case the buildfarm catches some defect at low probability. If > > there are no objections in the next week, I'll proceed that way. > > I'm happy with these new comments. The explanation in > heap_inplace_lock before calling CacheInvalidateHeapTupleInplace is a > lot better I think. And removing the last param means there is less to > think about. I pushed the patch bundle to v17-v14. Thanks for the reviews! The https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2025-12-17%2001%3A34%3A36 "double free or corruption (!prev)" likely witnessed a defect in how I back-patched this to v14. I am looking into it.