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 1u8vAP-00DThP-Sj for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Apr 2025 06:07:06 +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 1u8vAL-008hHf-8o for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Apr 2025 06:07: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 1u8vAK-008hHX-Uy for pgsql-hackers@lists.postgresql.org; Sun, 27 Apr 2025 06:07:01 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u8vAI-002Ho0-1G for pgsql-hackers@lists.postgresql.org; Sun, 27 Apr 2025 06:07:01 +0000 Received: by mail-lj1-x236.google.com with SMTP id 38308e7fff4ca-30db1bd3bddso37269241fa.3 for ; Sat, 26 Apr 2025 23:06:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745734018; x=1746338818; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=wPaU11m6+CWYIVW8H3xD6joOM4seiSNsjjuG57c4Sho=; b=Zixx14WNRa8B4NI0yQ3gUcsuWaXPhxOPz/iL9Z8Hp83rx2+iPIX2THMu5syFMUf2H3 /2naDmGcvs8eaALR9VL2lAdXDIPmicD+Ae8oIe0taH/ZAGdfsf1FqFhkKea/qXDJzyzR OQ2+qseqE+0e+ZmMtVHWf5HFvvTVoQ7V3SbTwd3S0uI/AUrecalcYagQsQtNusXy8Ao0 a8MXUAIz+eTV9i5MoIZBsQ63/EjNYabfDTdDTNJrLJgal0P8gfDAlNe2myQ9tsMacpFw I7Bny/IN+Av8aW+KyMBcfBQkKOE0glOepH4fRuBmgyFJCXvKecfTjyDcAFfpT52+AqG5 wWWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745734018; x=1746338818; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=wPaU11m6+CWYIVW8H3xD6joOM4seiSNsjjuG57c4Sho=; b=MRUKkZvwiipswHASw63X2gVn+hEHirhO/hnLlsXhpIDoJFELI2I6FCofViybIiUy4W JIVVabkSkP61zMfpk46EgvUde3foMd36ALCfYEpGubQ6iNJkN3pJ52PA/+xA1euV83ee 1sxCrx2QK3UJ6BgcxM0zmZVRBWyhTai/JJ5btJzmz2Twp4EQvzMNVmZUHR5Nnu1nqOtr 87L3BU79/wYhQovnZH3he0XUV1JyTYmaVGWiDZoUiFRO1RO+CDyNF/9d+djBAl9HL2ZC YQIKQ/bIpDiKnnWZGEFtuURmwmITP4Vb8qDatDkUpovRDPsjtj1nSVGpxpNXcYM3tpCc Qq6w== X-Forwarded-Encrypted: i=1; AJvYcCXCs7jg+d88u+xAZRQP4VQQdMt8Wq3HC50Ram28PXpv7HQMDxMMr3OXReOFOSK/l+CwRuoAsOjogsvn2sVM@lists.postgresql.org X-Gm-Message-State: AOJu0Yw33NTxfhNX6Z8pbMMGiQN9HmQ60RCC2RaUNgVMLfQ+VqBeA0JP l/pDvEUYHA/v7XxpvyiBYQdQ83rABDdyMElE6UsCZT/2HEvSNt24cmnOfMKiyk28m3YFlHonzZN g7fRaxuDTsEBtV0vUFW4NrgisJpg= X-Gm-Gg: ASbGncvuR4X95EPLisMGZ9xRvUGppoITU+coMKGx4jRTaLT9p84ybtXoVEt2NdpIsjn 174beOzKT810FxpsQTOoMltPPY/RhBM4iO6dV6BziMTPy6jStn/Ge7TRqLhlmg6r9vNHBBccpeF C3lO/6sphqSVkaWD3vNzOyxkU= X-Google-Smtp-Source: AGHT+IERPAaO6yh0CbkqYGV6Ja5A0cXb6E9rPrhGt2nI9/4q7HlKFrUEGvbJ5Krut8nBtH9yfUkY7tBSBKHJ8Pr4xpw= X-Received: by 2002:a05:651c:1542:b0:30d:e104:a495 with SMTP id 38308e7fff4ca-319dde5d081mr9454361fa.39.1745734017862; Sat, 26 Apr 2025 23:06:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Masahiko Sawada Date: Sat, 26 Apr 2025 23:06:21 -0700 X-Gm-Features: ATxdqUHNWolJSHU_Hbbl2vWrkgc1VxVx_l6R8wYku_Ss5KVtUe3iv0GeNFgvOUE Message-ID: Subject: Re: Fix premature xmin advancement during fast forward decoding To: Amit Kapila Cc: "Zhijie Hou (Fujitsu)" , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Apr 26, 2025 at 5:01=E2=80=AFAM Amit Kapila wrote: > > On Sat, Apr 26, 2025 at 12:01=E2=80=AFAM Masahiko Sawada wrote: > > > > On Fri, Apr 25, 2025 at 4:42=E2=80=AFAM Amit Kapila wrote: > > > > > > Can you think of any better ideas? > > > > No idea. Hmm, there seems no reasonable way to fix this issue for back > > branches. I consented to the view that these costs were something that > > we should have paid from the beginning. > > > > Right, I feel we should go with the simple change proposed by Hou-San > for now to fix the bug. If, in the future, we encounter any cases > where such optimizations can help for fast-forward mode, then we can > consider it. Does that sound reasonable to you? Yes, agreed with this approach. Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com