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 1sWbcI-00GBtc-TT for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2024 13:01:14 +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 1sWbcH-004eB7-BM for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2024 13:01:13 +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 1sWbcH-004eAx-0r for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2024 13:01:13 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sWbcE-001EGZ-CM for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2024 13:01:12 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-1fbc3a9d23bso11780475ad.1 for ; Wed, 24 Jul 2024 06:01:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1721826067; x=1722430867; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=OCetEuztis2zUZqidy9b4cxgMLlK0MEeizNgKgMZL6w=; b=aYM1wqGkb1tIF8WHkYE2OaqdYGK+IfuSLg0R3hf5DxiJdNrgRDT31q+QrpGJHDtizD 3CUm7PiB+c5MaVfIdSlsd9nQXjhlDRAG63phUHe0JbQV/MVackkjHGZdF7g0oXkd89c7 ElrJ8WclGW8hMYlU/wXd5YW6xRSD2Ft60RSWs= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721826067; x=1722430867; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=OCetEuztis2zUZqidy9b4cxgMLlK0MEeizNgKgMZL6w=; b=JHFtVh83Y9Cz8pppUBStO+V22GGAB2iepfDEdodia/BY8NcMdGzuyErwwB9l1PzL53 HrB8iqv43yHXCnSidKKppLx0OaciMqNAVRsckO8Hx72jWmtaLtJbMTNuWKrObuHE/Je3 Nz12Pp7oTZiJAxd3sWQxCJ30DL9VNd3N/hquUYYyQdiWQOmHgrKsc6Iv1tpC2nmDUb+K tEsD9ZW96gWFHzOK0Epgzr0W5kl+/OzXNRiaEzPg7WunSN2xJpmOFmCSmIUlDi8a1TZU jQylJN13SrBhKRErj+Qj3aD/FuG7FEscuDByQrJj0uvLmwmeSXYQXENfln9C8aCl1vIV bX6Q== X-Forwarded-Encrypted: i=1; AJvYcCWg25z8h9efoR3kxiySRLpX7El3Eg9gqZjnL7smNh/N47vadPso1hI+2M1blVFltfA+sLvY2ovx9HOuJqr07M4Vyd0IkQm9bGYT3jTSTzOGYA3j X-Gm-Message-State: AOJu0Yy/SOSpRezkPbu3wjd5N30v3otzIwRVDPqke3MrRjHF8i57o/W8 4WR/3A4yJQlHYh2v62V5GNG4HE9VWlOIFHbNFriscX1NAbW2aDaKSsK+gcwD1g== X-Google-Smtp-Source: AGHT+IE/HjBxkBp2wpLUiNCkpiC1+MiaUyZCPRgEmEKqygk+ujN6/tq41LEyIDakmApcxDecQP5Avw== X-Received: by 2002:a17:903:2346:b0:1fb:719a:28e2 with SMTP id d9443c01a7336-1fdd5512b9emr25280655ad.21.1721826067242; Wed, 24 Jul 2024 06:01:07 -0700 (PDT) Received: from google.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-1fd6f44f4c4sm93457215ad.224.2024.07.24.06.01.05 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 24 Jul 2024 06:01:06 -0700 (PDT) Date: Wed, 24 Jul 2024 06:00:59 -0700 From: Noah Misch To: Michael Paquier Cc: Aleksander Alekseev , Postgres hackers , Alexander Korotkov , Maxim Orlov , Heikki Linnakangas , Japin Li , Andres Freund , Pavel Borisov , Peter Eisentraut Subject: Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Message-ID: <20240724130059.1f.nmisch@google.com> References: <20240626002747.dc.nmisch@google.com> <20240626185844.00.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 Tue, Jul 23, 2024 at 06:01:44PM +0900, Michael Paquier wrote: > Hearing nothing but cicadas as now is their season, I have taken the > initiative here to address this open item. > > 0001 felt a bit too complicated in slru.h, so I have simplified it and > kept all the details in slru.c with SlruFileName(). > > I have reviewed all the code that uses SLRUs, and spotted three more > problematic code paths in predicate.c that needed an update like the > others for some pagenos. I've added these, and applied 0002. We > should be good now. I'm still seeing need for s/int/int64/ at: - "pagesegno" variable - return value of MultiXactIdToOffsetSegment() - return value of MXOffsetToMemberSegment() - callers of previous two Only the first should be a live bug, since multixact isn't electing the higher pageno ceiling.