Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding future partition causes deadlock??? - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Adding future partition causes deadlock???
Date
Msg-id 37FDC145-81FD-4828-87AF-1488B0D1540C@aweber.com
Whole thread Raw
In response to Re: Adding future partition causes deadlock???  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Adding future partition causes deadlock???
List pgsql-admin
Tree view
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 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?

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Adding future partition causes deadlock???
Next
From: Scott Ribe
Date:
Subject: Re: Adding future partition causes deadlock???