Re: Adding future partition causes deadlock???

From: Chris Hoover <chrish(at)aweber(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Adding future partition causes deadlock???
Date: 2024-05-10 14:45:09
Message-ID: 37FDC145-81FD-4828-87AF-1488B0D1540C@aweber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)aweber(dot)com

> On May 10, 2024, at 10:36 AM, Scott Ribe <scott_ribe(at)elevated-dev(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2024-05-10 14:56:53 Re: Adding future partition causes deadlock???
Previous Message Scott Ribe 2024-05-10 14:36:52 Re: Adding future partition causes deadlock???