| From: | kyle Hailey <kylelf(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: ATTACH PARTITION "hangs" |
| Date: | 2023-05-12 00:02:19 |
| Message-ID: | CADsdiQhNM3G6hHRz=et-3G2sidN05U5scARyYt578-C8ego6yg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)janes(at)gmail(dot)com> wrote:
> On Thu, May 11, 2023 at 3:06 PM kyle Hailey <kylelf(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Singh, Gambhir | 2023-05-12 07:34:21 | pgsql code is not working. |
| Previous Message | Keith | 2023-05-11 22:44:37 | Re: ATTACH PARTITION "hangs" |