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 1weYWQ-004rqM-07 for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jun 2026 13:29:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1weYWO-008TJg-30 for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jun 2026 13:29:04 +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.96) (envelope-from ) id 1weYWO-008TJY-2A for pgsql-bugs@lists.postgresql.org; Tue, 30 Jun 2026 13:29:04 +0000 Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1weYWM-0000000119o-2Qtd for pgsql-bugs@lists.postgresql.org; Tue, 30 Jun 2026 13:29:04 +0000 Received: by mail-wr1-x42d.google.com with SMTP id ffacd0b85a97d-474bf35cccdso363477f8f.1 for ; Tue, 30 Jun 2026 06:29:02 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782826141; cv=none; d=google.com; s=arc-20260327; b=qBbq+nIxNt0BnRPa2YpNX0wgHgqyNSouj/Njxj2y+dr9aMs9ytbLkjr2z4fz5KALf0 64vXrdWYApSlu6uAYgnZJTTH6MPSBC5LaPCYfZTU3/Vu4Drvb0wLxHts2E90GhybefAu eKrw8b93wg6sxn47mO3QVnY1iKOXLHKuPNNm+oHWSvJuymgPKBZvy0l47Kha9J3AB83W e4AX+NsX/GBrwzwclcL2NchM5GF1IbD1M/Z1YSllixsjNyWgoDxskrqkbuV0GKixn5Ue PsqI7m+EvcoBDY4+5Z/yfd31KXJ+o0rQevqDBJu8x77mgTVOJs3itgX3HUk5Xe5TKG+K bW7g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=6QtskuusK407UBXqqdgfYsRVx+uepHx1jamURgM5UmE=; fh=rJws19gQ6l2aWtgQhb2ptnC28OQi6f3Bm2onmUMJjGc=; b=HFCYjUfD0JL7/rmmCaB10oyHWJzevEAJsqsyuWD9h2wqcgKg5DmjhQJb7mdCsPndSP 4ZYVJiWDXxkJVoHKlNe8m8m5OYYejCv70v0HkvTqYIf3Fd1YrWsWgeFUqL2jYLZaWZjo aBsnILHJEfDUZnWa980HptNrWZQCstmTUHfDm8zJpVEn2eTKNApFnTIrWnACIIka1el2 /aVb/mqlnnGD3NT6nLFQGXfea4VOFKyIj0Wx3Q7sdEJbotwMuJAz/ae3fhCOhD99fyDq /nqAGRUlFQ7Jc4YXGiAmrb3Q9ESHsZF+hYLcm1r+5963iBiW6pWkgvlshoN5LaDJcikj aRxA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782826141; x=1783430941; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=6QtskuusK407UBXqqdgfYsRVx+uepHx1jamURgM5UmE=; b=bcVKsGM/zSKlNynRBIWoph2wHVxL8IrnqfirzaRZ3rsgGCPpuEBxuxgzuM3hl+5o1g QaH7FS5pLLez9pDabklAvFv1Gz4a9JCBa5uRS+NRA43Fm2xcqG+Lud4Iomzwng1IsUfu OpCGBbUgatsTRimDcPMDFmTvzAB8llvRiLOinuKNNvR94IZKw5z+5F0c1PjQ+eAeAZ1x QzFjC8LHRlGmFOs9vEAtp/Y19csOnrgskUwrCMVlakTKqwFFznqR3xFhXWCdBQxEWZKB fjRXzmCsvlDQt6Yogdj/Fwy2QY82vN6Q9+DYQ9kMBOw7s0yYcCDwgpM7H9OL/HlRyHiG LAug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782826141; x=1783430941; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=6QtskuusK407UBXqqdgfYsRVx+uepHx1jamURgM5UmE=; b=MWcRNHmx/HU+zaxp+WKWDSEz+g+GQjTIrM5v5lezOtYoGefW7l7BhPFxhJ4fUf4Mzx DnucZUK9tRxuMgv4MG/v+IYb5ESQuDQHOL1uT4IBZF0Uh4KBIOBH5LF/QWHZx4IAdbCy js5cmTvTSo+aoSEWGunTwGZMk4LdyAh+6KRttBjtJLTJMMfSWHsNdP0IGKXUbHec3GnS 1y3TTshKNEmnuyHHOLETKto7fcg8xIpuaiP/cAxRlIV/CZVDYPgf8kJklJ4vjuDUjaph 2vWKZU77pZUnPj3+TzEXHwBCY93r+vHL8Mfh0VD81W1Wp7Ic9N5lURivYo6QmOmrI/xB DIVw== X-Forwarded-Encrypted: i=1; AHgh+Rqjb3o8NiS/69Htr0VW87djhpxiB6NnglO8Leg2KSQYQiCR09RVIBt9Ym7Jl1bcSUW0wDiikRdXzfJa@lists.postgresql.org X-Gm-Message-State: AOJu0Yzm5LRB33zGvEFkoPMpSrFA72IASAYayD3T84mbfVWXLkOmhuCG r40l1SyKhmoBXeeSz47IZ5cDJ3l4F30IuILTSdOppZdHWxEuVsR775xBZUkWwL/aCTtTasyUyZs TyijA2VUv3O9RzsdJYZG04AGsul8FgOGXjMfqb0I= X-Gm-Gg: AfdE7cmwsNZUDiyPflikYcBTLengWXAXcgnv34gcS7iPCN74hQViKfN1JzCe0SsxKVK z1dEB5+32+sV6WMcAHx+7psW6OBZe800bFw0CqnwJCw25kCbC03T2VLyvB6E7b5ow9W8UTsklK1 8WpxE9qS2omEsdZrk67BGsEvA8njzPfPDGdDJiE9iuas8wVAC7mdFpgN6ADbfZ2V4v1wV6kX9kF VZidbalXQiyeqoOKYfKyWyCc+HgmsxfJAuiYSyX7Z1DfgyUk28AV97GidsJsC+cgMfdzSXF X-Received: by 2002:a5d:5c89:0:b0:472:326c:a4a1 with SMTP id ffacd0b85a97d-475530280dbmr5159352f8f.22.1782826140933; Tue, 30 Jun 2026 06:29:00 -0700 (PDT) MIME-Version: 1.0 References: <20260626.132415.904994526137946499.horikyota.ntt@gmail.com> <20260626.171307.1289242154888665760.horikyota.ntt@gmail.com> In-Reply-To: From: Daria Shanina Date: Tue, 30 Jun 2026 16:23:59 +0300 X-Gm-Features: AVVi8CfVdm8DxJD5flYIrE3_45UzbvofejJzKGKlEC8R7owFVPuzN-gJvD_O2Ic Message-ID: Subject: Re: Set huge_page_size on 32bit system To: Michael Paquier Cc: Kyotaro Horiguchi , pgsql-bugs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d3a0bf0655788e9a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d3a0bf0655788e9a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, Kiyotaro and Michael, thank you so much for your answers! Using MAX_KILOBYTES as the upper bound is indeed absolutely accurate, and now everything is working correctly. --- Best regards, Daria Shanina =D1=81=D0=B1, 27 =D0=B8=D1=8E=D0=BD. 2026=E2=80=AF=D0=B3. =D0=B2 05:50, Mic= hael Paquier : > On Fri, Jun 26, 2026 at 05:16:23PM +0900, Michael Paquier wrote: > > Changing the states of the GUC tables in the stable branches would be > > OK in this case. Now, it took so many years for somebody to complain > > that setting huge pages at 1TB on a 32b build does not work that I > > cannot really get excited about a backpatch. So I would just do the > > switch on HEAD, and call it a day. > > And just applied a patch doing so, HEAD-only. > -- > Michael > --=20 =D0=A1 =D1=83=D0=B2=D0=B0=D0=B6=D0=B5=D0=BD=D0=B8=D0=B5=D0=BC, =D0=A8=D0=B0=D0=BD=D0=B8=D0=BD=D0=B0 =D0=94=D0=B0=D1=80=D1=8C=D1=8F =D0=90= =D0=BB=D0=B5=D0=BA=D1=81=D0=B0=D0=BD=D0=B4=D1=80=D0=BE=D0=B2=D0=BD=D0=B0 --000000000000d3a0bf0655788e9a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,
Kiyotaro and Michael, thank you so much for your= answers!
Using MAX_KILOBYTES as the upper bound is indeed absolutely ac= curate, and now everything is working correctly.

---
Best regards= ,
Daria Shanina

=D1=81=D0=B1, 27 =D0=B8=D1=8E=D0=BD= . 2026=E2=80=AF=D0=B3. =D0=B2 05:50, Michael Paquier <michael@paquier.xyz>:
On Fri, Jun 26, 2026 at 05:16:23PM +0900,= Michael Paquier wrote:
> Changing the states of the GUC tables in the stable branches would be<= br> > OK in this case.=C2=A0 Now, it took so many years for somebody to comp= lain
> that setting huge pages at 1TB on a 32b build does not work that I
> cannot really get excited about a backpatch.=C2=A0 So I would just do = the
> switch on HEAD, and call it a day.

And just applied a patch doing so, HEAD-only.
--
Michael


--
=D0=A1 =D1=83=D0=B2=D0=B0=D0=B6=D0=B5=D0=BD=D0= =B8=D0=B5=D0=BC,
=D0=A8=D0=B0=D0=BD=D0=B8=D0=BD=D0=B0 =D0=94=D0=B0=D1= =80=D1=8C=D1=8F =D0=90=D0=BB=D0=B5=D0=BA=D1=81=D0=B0=D0=BD=D0=B4=D1=80=D0= =BE=D0=B2=D0=BD=D0=B0
--000000000000d3a0bf0655788e9a--