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 1rihfu-0017pj-9s for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Mar 2024 21:22:42 +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 1rihfs-00GC7G-44 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Mar 2024 21:22:40 +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 1rihfr-00GC78-R4 for pgsql-hackers@lists.postgresql.org; Fri, 08 Mar 2024 21:22:40 +0000 Received: from mail-pg1-x52a.google.com ([2607:f8b0:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rihfl-003Vdl-KR for pgsql-hackers@lists.postgresql.org; Fri, 08 Mar 2024 21:22:39 +0000 Received: by mail-pg1-x52a.google.com with SMTP id 41be03b00d2f7-5dbf7b74402so1936219a12.0 for ; Fri, 08 Mar 2024 13:22:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1709932952; x=1710537752; 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=Yoy1kFKjLp36UfJR4EA3IWfv+EKKPxEfUqNaQadWVbA=; b=CIY03mv9iL97ybziQ7TEwZSm+KsrV3zuMVmccIdoFeFW/5x8090403Ev1HhxCzXMWa Dg+Q187k2I5lES0V8qkQwVLVF8ZdRiGoieTCSw/K/+kNnzWwN8QkY+oGst+8+1EBQILT ONp980WH6IeYOHPW2a5q/q5CtgCQK/sOYe1wbXZgSII2IrBaeeBZb5fdM18kJAKTWXfZ BHBql/VqUVPIn4TpFHI0801AB/1Ec28Irrd4lbqkhkaLAfgw6TvYYv/LQh1sJtb1RB1y VHvAWXPNq8qm4+yhK+wFO4Z0+6WtYmqtV85nylGICFV8fEQH+FC4wzjzWyo0PoMJjx0C ICTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709932952; x=1710537752; 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=Yoy1kFKjLp36UfJR4EA3IWfv+EKKPxEfUqNaQadWVbA=; b=rm0BqiGqDujkUczoQZi5R9O9xPVqkJka2Qou0msPaynO1m6I1/o7c+U29kBqTQF+b1 OacN7ZBAtNjHM369E4iecuyoWf+8e7zg4OcqLuu1i1ZTiItjL5YM3pAz1BenXcmdmfLu 46x9AozTl3t3zopYKOlbkhqF0mQKSOdWGxpzyOXw0Ua0IEhbMj9NHWRUBb22v2uqEVo8 SiLfgoZxGIKi2LIUQU30LkQDomBuRQcOsouO/aVTLjalkPBMwLI0VzsE8ucVc4YMTqDC L0gxyXVnQu+lRozrqCYaZYx4Vr4wnZchwf3x33vOiqoNy28eGFDNAMM7EbGN8auf+1k9 xUgg== X-Gm-Message-State: AOJu0YyZW9Aln+wxDbaAtqwHCaDqIc2zqXERTVsZdG+xhBlyQ9IFw7Cb DD8NnGavpZSyRkrhoyeO+IeVvZ0Eaxf67QmXLcf6yQpjecSgpvbHU+tsst+pmQ== X-Google-Smtp-Source: AGHT+IGdrjPt7t3itnExY+2r27gA9UJH0dx3TSyeETdBL0sGn5bv0JwOb8xVDQeGw/rVCs5tOzT3ZQ== X-Received: by 2002:a17:902:7485:b0:1dc:66da:d21a with SMTP id h5-20020a170902748500b001dc66dad21amr305472pll.28.1709932951754; Fri, 08 Mar 2024 13:22:31 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id j5-20020a170902da8500b001dcb654d1a5sm92205plx.21.2024.03.08.13.22.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 08 Mar 2024 13:22:31 -0800 (PST) Message-ID: <3ee88744547f6865fe2f48b2b6f058a50796cb91.camel@j-davis.com> Subject: Re: Proposal to add page headers to SLRU pages From: Jeff Davis To: "Li, Yong" , Aleksander Alekseev Cc: PostgreSQL Hackers , "Bagga, Rishu" , Robert Haas , "Debnath, Shawn" , Andrey Borodin , "Shyrabokau, Anton" Date: Fri, 08 Mar 2024 13:22:30 -0800 In-Reply-To: <4B689BA2-270F-4B26-AAA2-65BB17C03AC4@ebay.com> References: <162841701969726@mail-sendbernar-corp-main-71.iva.yp-c.yandex.net> <76110763-F29E-469E-AA62-2EED17875BB7@ebay.com> <1404E248-F2B2-48BC-9B5E-BB318F3BE583@amazon.com> <628CFBEF-DF56-4D9A-A2F1-0A417848B6B6@ebay.com> <359BB3DC-A174-43AF-A9BA-064CB6D2C7E9@ebay.com> <48CDC195-5030-4426-9E02-931D8AE14DF7@ebay.com> <4B689BA2-270F-4B26-AAA2-65BB17C03AC4@ebay.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-03-06 at 12:01 +0000, Li, Yong wrote: > Rebase the patch against the latest HEAD. The upgrade logic could use more comments explaining what's going on and why. As I understand it, it's a one-time conversion that needs to happen between 16 and 17. Is that right? Was the way CLOG is upgraded already decided in some earlier discussion? Given that the CLOG is append-only and gets truncated occasionally, I wonder whether we can just have some marker that xids before some number are the old CLOG, and xids beyond that number are in the new CLOG. I'm not necessarily suggesting that; just an idea. Regards, Jeff Davis