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 1s5RV5-005PSP-7n for pgsql-admin@arkaria.postgresql.org; Fri, 10 May 2024 14:45:31 +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 1s5RV3-00GJBi-Jz for pgsql-admin@arkaria.postgresql.org; Fri, 10 May 2024 14:45:29 +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 1s5RV3-00GJBZ-95 for pgsql-admin@lists.postgresql.org; Fri, 10 May 2024 14:45:29 +0000 Received: from mail-qt1-x82f.google.com ([2607:f8b0:4864:20::82f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s5RUw-000MZx-6H for pgsql-admin@lists.postgresql.org; Fri, 10 May 2024 14:45:29 +0000 Received: by mail-qt1-x82f.google.com with SMTP id d75a77b69052e-43de92e234dso21436651cf.1 for ; Fri, 10 May 2024 07:45:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aweber.com; s=2018090500; t=1715352321; x=1715957121; darn=lists.postgresql.org; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=hoFwHIHmRmiEcN/z1TTEC71mR10gl76uW/GtMZrbaK8=; b=FNH7XkeHQxSbBRpVFYQ5Wz8V02B7xMc6bLsIlTCSCPNHZUSNP+Fgt9Whsyhsmo698l Bv/Gw5YOI8slz9s/iEVLYjy57ZJAIMttHWeMekyW6PTPYpURKs5cgDJheRxjxAY1K8fS 5rJUhU/99XmIoKVuIcHJXMa3/fzi32dX97NIHysS47fmlWBZLDzpiRKkHv7TeW7FbqtK GVN4c4wu2lQnopTXz1VnroAq9DsTXR+LEBDD29c0fP3B0FYAGl5yc2J8UNE8Z1GrsW2e nE4/XxFksSjmx1tZAD2IGxL0O4PYt3d5/Pgwl6F74H6L27x8aSRCyFI0Hg4eJ7AjF8G1 Q1Ug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715352321; x=1715957121; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=hoFwHIHmRmiEcN/z1TTEC71mR10gl76uW/GtMZrbaK8=; b=H8KAjF6z2OThruhqqcVHiGodTUZ6CHBe2fEJWKcWCdK8IyFLWfEJFzbk6OHLegzBzu SQj8DpCAMnVUeMLW8yZk7cR9Sd1r7RxEN+c8Csg0tq8U+XVl6B0v3pGJa4/LzRew1EKy aN2j9PIj6H0qeN3vmV6sBFDsu2oPIv6X03oi9qKKg/8FQJuc5Px2bStuLTEdVycLeNzX aMlqEenrOeCj3lNIYo8cJdbG8M/jtMgvr+F79kvmA637+wZ6P6XTn/lAMQkB4ghS6GCs bOUkfomEI0Y3PBACSEGpfdYiz+ce8FT2TxVop2BNYDHpQGh7itPB1zUTMTwZZzvDLkx/ y3yA== X-Gm-Message-State: AOJu0YxYYRjnujbUeMHqKDG6PNtdm4M7STO6gIlw29wdjMCLFGV/s09o hE97B5S6eKspEhuW++VMmBaio5HpT2JHxVW6RGS/DymkHkmO2/qezq3oXLqrLTg= X-Google-Smtp-Source: AGHT+IG2NrPxJR9EjmoXwQHUmUqrXTiSr76JgatT459wa2XL3bv0Qty6NX+BTHE2QLyqqRhugmOSfw== X-Received: by 2002:ac8:5844:0:b0:43a:fa49:8096 with SMTP id d75a77b69052e-43dfcc8624dmr51152641cf.8.1715352321575; Fri, 10 May 2024 07:45:21 -0700 (PDT) Received: from smtpclient.apple ([172.59.220.236]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-43df5698470sm21794321cf.63.2024.05.10.07.45.20 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 10 May 2024 07:45:21 -0700 (PDT) From: Chris Hoover Message-Id: <37FDC145-81FD-4828-87AF-1488B0D1540C@aweber.com> Content-Type: multipart/alternative; boundary="Apple-Mail=_7A8E5F15-768F-4A45-8370-5FDDDDADBC89" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\)) Subject: Re: Adding future partition causes deadlock??? Date: Fri, 10 May 2024 10:45:09 -0400 In-Reply-To: <5DAE56BE-9611-4E79-854A-56A26A2FFE34@elevated-dev.com> Cc: pgsql-admin@lists.postgresql.org To: Scott Ribe References: <5DAE56BE-9611-4E79-854A-56A26A2FFE34@elevated-dev.com> X-Mailer: Apple Mail (2.3774.500.171.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_7A8E5F15-768F-4A45-8370-5FDDDDADBC89 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 PG 16.1 No, this specific table does not have a default. The app controls the = creation of partitions if they do not exist. Thanks, Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269 Email: chrish@aweber.com > On May 10, 2024, at 10:36=E2=80=AFAM, Scott Ribe = wrote: >=20 > What version of PG? I know that some releases in recent years have = reduced the scope of locks which get taken during creation of a = partition. >=20 > And do you have a default partition? --Apple-Mail=_7A8E5F15-768F-4A45-8370-5FDDDDADBC89 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 PG = 16.1

No, this specific table does not have a default. =  The app controls the creation of partitions if they do not = exist.

Thanks,


Chris = Hoover
Senior DBA
AWeber.com
Cell: (803) = 528-2269
Email: chrish@aweber.com



On May 10, 2024, at 10:36=E2=80=AF= AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:

What version of PG? I know = that some releases in recent years have reduced the scope of locks which = get taken during creation of a partition.

And do you have a = default = partition?

= --Apple-Mail=_7A8E5F15-768F-4A45-8370-5FDDDDADBC89--