Postgres Pro
Downloads
Home   >   mailing lists

Re: ATTACH PARTITION "hangs" - Mailing list pgsql-admin

From kyle Hailey
Subject Re: ATTACH PARTITION "hangs"
Date
Msg-id CADsdiQhNM3G6hHRz=et-3G2sidN05U5scARyYt578-C8ego6yg@mail.gmail.com
Whole thread Raw
In response to Re: ATTACH PARTITION "hangs"  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
Tree view

Maybe there is a missing index.
I made all the indexes but eye balling it.
That's' why I asked earlier if there is a compare two objects.

It would be awesome if the ATTACHED said what it was doing, what was missing



On Thu, May 11, 2023 at 3:14 PM Jeff Janes <jeff.janes@gmail.com> wrote:
On Thu, May 11, 2023 at 3:06 PM kyle Hailey <kylelf@gmail.com> wrote:

I created a constraint to make the ATTACH command work immediately

You also need to create any indexes which exist on the parent table onto the incoming partition, otherwise they will need to be created during the attach operation.

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: ATTACH PARTITION "hangs"
Next
From: "Singh, Gambhir"
Date:
Subject: pgsql code is not working.