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 1wElBe-004Mu2-2y for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 09:45:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wElBd-001rq3-31 for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 09:45:01 +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 1wElBd-001rpv-1y for pgsql-general@lists.postgresql.org; Mon, 20 Apr 2026 09:45:01 +0000 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wElBb-00000001u7L-2d8G for pgsql-general@postgresql.org; Mon, 20 Apr 2026 09:45:00 +0000 Received: by mail-pg1-x52f.google.com with SMTP id 41be03b00d2f7-c795eacbeb0so1028238a12.2 for ; Mon, 20 Apr 2026 02:44:59 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776678299; cv=none; d=google.com; s=arc-20240605; b=iZL2LuC1+cPvrPByE9zTu3Y6+ckbEuElhJcrOKCSfEFunerrNo5IGCpxpmpLSZRRuV OJnbPL8IO8JgHXs40nQwvq5RP+2JoyNweigCSbZEZ9uABu+mbMiVnHGSK1cQ29JYo/UP 5eFu84hkHf+ZRQJj+v2GzRAPiDwZKJcWzK/1koOkQMghz4InRYmbKtAPY1W5VqNRZ8ve EMf68xb8zFqSijD9n/BioB8TuLiGsCSYKf4bBURCunKjjfPLV3obkWMif3HU7QM1dL7S 8F8fQ8TAxeoGIROyP7UjClS7ok+LqsRCBh0DZUTiQ3/W1hNyA32nPOULBN2U6YG5CCuP kNmQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=8/87TI3BtQb4iJUIMj+byX6W+3AOSiIVbZeTehi4O1M=; fh=x9Jmr8+FtiCQKUvo/7/je6SkcsG+V48pI/LmEXQOSec=; b=kCPysG/Cye/hZx5mr1HNrY1+Q7ueQPkmoVoeSM/NRafdBCF4BO74fJeOzjwf03Zwz/ yCRPKyOMd+7dsKbnedJkPZl6qz9fszWgdyQyoptQQRrcYh0Ou62H8WFF+hY8rIQ3SnbM D2dHd5UEbH04QAVJue3oXK2l73xIphe04IzRqj+l93za8B5WI3q6NgHI8XZ/D/GRG1dl 8P8BTOsAXAeZFp0CiOuYia65CQNjlmkohsdXVRBLEofu7HQFwp1KWdCX+x8rd3gMCLE3 GegIwmjfvK5ZQfbxurU3DAnpVZxcI5ROGtiJV7N9PtNyTsZheHKpWglgTl1AlTzjXWA7 nObw==; darn=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=1776678299; x=1777283099; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=8/87TI3BtQb4iJUIMj+byX6W+3AOSiIVbZeTehi4O1M=; b=fmLoNREImmNYuEOM2J2J7Jh/QsgvkoEJEeVGZYEcaM61Ml8p6gXgTJ1P3e2anv+Xgu MQpDEWmFOWtnbULxRTG9X4XxAt5mMh2tNv86iYjA9VYXD7vH6JuC22nnhShuNKcqycXc te0MBGXcM9/DxjBlezJybADqbJTHrHQiV64tWWpuBPj53dsMfYtFI3jGgfh6pc14wV6k E8KnE67dIkYKRWfh0s6DznKE6U/en7nU52ZpVFLeutUSIUiKz6PVDfxSMFQDPdvCMceD IoOIZffbDQo+s3FnyFd0uY1pjy3CBLynctQHCDKXyiwbDuqiBybeQrDJHP3FD9IVyEQD sbMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776678299; x=1777283099; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8/87TI3BtQb4iJUIMj+byX6W+3AOSiIVbZeTehi4O1M=; b=rMm8SW130MlNNNglHf6cubyhdFvK/g/ZikuDKnn1SpQ2YNI+4Io1SGW6a30+SGLHVp YkmfEeRAk7VLm02e4R0AZFjNpJ0YhZQI4TCO73h4bhb1+sD6WI3auIJr2cIeqqE/Mkmw FBIh2kslDqhfcvIbKqJWvYfBkM8iphjN+qJehnD51fRd2IqSXukjRTnHDlvMXvqkIfUi wNnUk2QiV/h49q+Ruo/ETH15qVQ03W4AckpMMbm6mMZiv5ezO1kv/d9FtZskL3Bj2Lqk bHxPxj6j6S5EaRAPcJnpLRini3gb8xnPzxc755lqDoNXIZ4ZinY8lw9lKR3jdA9hi8rB 04xg== X-Gm-Message-State: AOJu0Yx/dAOqvsJa6JP/PbilPl/KaaXL0sbIM069tZvc4s8kZGz71VnG H5//ZT2vwHwr1NB6DBY/dNHDoaI1I3YCIFo70fA+gJiiWxK40OetV58bNrRMj54/58cTXb5ImBm YEaj1/9oT4uTbUdKT8KZ8k3JZJ8x4DqBLBw== X-Gm-Gg: AeBDieutGrYKm3BBIRhWEBpdgsIw52fhJ3tYF54Kh3nc2hkshmIP7wJvK1aT/kq17SL 9pHoXiQn8TYuCUKF2ZnhzH6UaJHFRB6OfWAuaQiDlJ8+yf/d+qkQPKFn9zKHNw0JnEo2mvltYUN pyYdU/IRkpr5d4Ef6A0/683sODyxqsG4+lzV+QOqiJOXuHg9Kqh/nA9aowWE5REVrRA/0tm0PQG CWNHE0WZox0vViy8i986igl0B8EuH5JGi4Wl5fNyvSs904MnUPXobisqViKSe1pDQtM+j6z2Sug 3wFHvlv3baxFANpM X-Received: by 2002:a05:6a20:728c:b0:39b:8b8b:39ce with SMTP id adf61e73a8af0-3a08d8a8993mr14090576637.28.1776678298897; Mon, 20 Apr 2026 02:44:58 -0700 (PDT) MIME-Version: 1.0 From: Dominique Devienne Date: Mon, 20 Apr 2026 11:44:46 +0200 X-Gm-Features: AQROBzAwL_F8_88Ei60DRsF-hGkQ16j8btKQYE7KC-89j-kdgOEFB7NnRqsvjTY Message-ID: Subject: Test cluster with high OIDs above the signed-int limit (2B+) To: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi. A few weeks ago, one of our clusters, with high DDL churn from UTs, crossed the 2B mark for OIDs, which exposed a bug in our code. I'm moving into creating clusters on-the-fly for testing, and would like to force that situation to avoid a future silent regression, since it takes a long time to cross that threshold, and we do move up in major versions, so the over-the-threshold cluster will be abandoned. How can I achieve that? A quick AI query yielded nothing, but this is unusual enough that there's little to no material to have good answers. Can PostgreSQL experts/hackers weigh in on this please? If not possible now, can this be supported in the future please? --DD