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 1uqtPw-00EmB0-Uu for pgsql-general@arkaria.postgresql.org; Tue, 26 Aug 2025 13:08:54 +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 1uqtPv-006AYJ-UK for pgsql-general@arkaria.postgresql.org; Tue, 26 Aug 2025 13:08:52 +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 1uqtPv-006AYA-JN for pgsql-general@lists.postgresql.org; Tue, 26 Aug 2025 13:08:52 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uqtPt-001xMh-2J for pgsql-general@lists.postgresql.org; Tue, 26 Aug 2025 13:08:51 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-30cce5be7d0so2551306fac.0 for ; Tue, 26 Aug 2025 06:08:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756213727; x=1756818527; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=5fMWzkhdQjTjBaQtpdB2gUGgAe2w9ichVANROJ0ZlDQ=; b=DwcpvxDyntFT3OwMi2zIQOqQzm1OSYAVkgBOezyrVuxntz5uizeTKNqeGMH1v6u98Z QP4sLhFh3iNsK1Yr5GOiBseo8xZF7A8pUdReN6wsQYsqUMgLpufKHexPQY/Sh0jIR3yV VNmcJnEQhTbhWzc4TVnV/vS6N4MfQ2R368xXxRLaq3bbM7ig1gzWB4mC0yXSqO+6VC4q 68UEeCM8EYmLPTHyscuFzRUDTKhyTvXxU6kr78lQTldWlMnfaeC7yCliDQzi/dk7wQWM 00fbLStt76pa3BIlsYQ2aneoqWjrCw6dLywUVveGdgPp4cntcdo2tT0+ONXXjFSX8eYG 6jEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756213727; x=1756818527; h=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=5fMWzkhdQjTjBaQtpdB2gUGgAe2w9ichVANROJ0ZlDQ=; b=hoVeHcN6fKppI6RUkNAnaUbV1uUs0GJ5bywtbrXpZJD05rPtmAmv2Bk7j8nG15wXYC VsT2G8X6gUwQHAvpO+HsygfJ5CvbUUBySLMnXPSrb+9vBAwipJ4vOY0AsCL4fEUYa6uf iX2K/thqXOlzlQIv204BR4hUXCrtUcY3dpAHmozQnfVn6637MlaYHg/5wcZ1KlAWXRCF QFsCGNo5Gek4NgezsG2tCQTbSScu2E3p7MjA7GtFvVyoPP6BkL7lPJUJM4j4MbTEcpmy R9wqoAmrBy4ZFDP5nhl1ZAJyADi8gK9NSsUNokdL7EtJVS3IWNYxKBgTNBCjg0+XxdGc wtZg== X-Gm-Message-State: AOJu0Ywis+hJgwHKDhr1AM8+Bp0Z6s/ngSEXCuYU8ChkndMJm7HUnrSI pgp0Xxa2A+1uNvX5neKN5p4K0Dqwk5DdoFHSBWjE9u5ew88PSGstd30xHBlz1vOf+/kBFCZowXn 5BlXQ0nrgrFtB1r7f2cEmAbI077bNctU6dw== X-Gm-Gg: ASbGncsJh/+ZDAPQP2N4CbSS6BPaYRYdH+FhZ+BSP3xDB2k8rWh46Qq9Ia3Iv/0/P/A 3yzJOAyudx011Eul9LPMfxOhtFt3rbfxMW2vSoV3VrgnHFZhORjXCiGQwnmZqjLoZJYlJkdyzbq EHvZosgQ+5YWLHyt2wWDL2J7lOa2Ht5dpxIm65KzCknGNUC5ir3X8Ezxx9tWK7EdCozOpVOA4rs 983yXXq X-Google-Smtp-Source: AGHT+IGzVYy1rJFxgHWEopJ5rai9X7b5rFBiaL9SvyvLhUqAoIrmB9iL9Nj8O4ddBqZwFGesNZDaliELSS+eUOi5FUY= X-Received: by 2002:a05:6808:6a87:b0:437:c839:ef3e with SMTP id 5614622812f47-437c83a069dmr321113b6e.11.1756213726969; Tue, 26 Aug 2025 06:08:46 -0700 (PDT) MIME-Version: 1.0 References: <185dd861-4e5a-47c0-9f2e-84dfa8a406ca@postgrespro.ru> <26239cd6-a13d-4137-9f1d-61e18c4cf0e6@aklaver.com> In-Reply-To: From: Ron Johnson Date: Tue, 26 Aug 2025 09:08:35 -0400 X-Gm-Features: Ac12FXzx96kISV36G5-7lahc032kYqSGyGe6AkuGZjBexpRMHSPfFWmNf1tB9gE Message-ID: Subject: Re: DISABLE TRIGGER doc wrong? To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000005884da063d445f2c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005884da063d445f2c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Aug 26, 2025 at 9:01=E2=80=AFAM Dominique Devienne wrote: > On Tue, Aug 26, 2025 at 2:54=E2=80=AFPM Ron Johnson > wrote: > > On Tue, Aug 26, 2025 at 3:01=E2=80=AFAM Dominique Devienne > wrote: > >> ERROR: permission denied: "RI_ConstraintTrigger_c_1226298044" is a > >> (yes, that's a large OID... For a 1 year old DB) > > > > PG's OID allocation of "user-land" OIDs doesn't start at 16384 anymore. > > This is a 17 cluster. So not even 1 year old then. > So getting to 1.2B OIDs in 10 months, > doesn't bode well for the longevity of that cluster. > But we're getting OT here. > This is not a "production" server, lots of CIs and manual testing there. > Like I said, it's not completely linear. The real question, though, is whether PG looks for gaps in oid allocation once it wants to try and allocate an oid of uint32 max. I bet it does. If it doesn't... pg_dump/pg_restore, baby! --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000005884da063d445f2c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Aug 26, 2025 at 9:01=E2=80=AFAM D= ominique Devienne <ddevienne@gmai= l.com> wrote:
=
On Tue, Aug 26, 2025 at 2= :54=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> On Tue, Aug 26, 2025 at 3:01=E2=80=AFAM Dominique Devienne <ddevienne@gmail.com&g= t; wrote:
>> ERROR:=C2=A0 permission denied: "RI_ConstraintTrigger_c_12262= 98044" is a
>> (yes, that's a large OID... For a 1 year old DB)
>
> PG's OID allocation of "user-land" OIDs doesn't star= t at 16384 anymore.

This is a 17 cluster. So not even 1 year old then.
So getting to 1.2B OIDs in 10 months,
doesn't bode well for the longevity of that cluster.
But we're getting OT here.
This is not a "production" server, lots of CIs and manual testing= there.

Like I said, it's = not completely linear.=C2=A0 The real question, though, is whether PG looks= for gaps in oid allocation once it wants to try and allocate an oid of uin= t32 max.

I bet it does.=C2=A0 If it doesn't...= pg_dump/pg_restore, baby!

--
Death to <Redacted>, and butter sauce.
Don't boil m= e, I'm still alive.
<Redacted> lobster!
<= /div>
--0000000000005884da063d445f2c--