[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: ATTACH PARTITION "hangs"
From:       kyle Hailey <kylelf () gmail ! com>
Date:       2023-05-12 0:02:19
Message-ID: CADsdiQhNM3G6hHRz=et-3G2sidN05U5scARyYt578-C8ego6yg () mail ! gmail ! com
[Download RAW message or body]

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
>

[Attachment #3 (text/html)]

<div dir="ltr"><br>Maybe there is a missing index.<div>I made all the indexes but eye \
balling it.</div><div>That&#39;s&#39; why I asked earlier if there is a compare two \
objects.</div><div><br></div><div>It would be awesome if the ATTACHED said what it \
was doing, what was missing</div><div><br></div><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 11, 2023 at \
3:14 PM Jeff Janes &lt;<a \
href="mailto:jeff.janes@gmail.com">jeff.janes@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
dir="ltr"></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, \
May 11, 2023 at 3:06 PM kyle Hailey &lt;<a href="mailto:kylelf@gmail.com" \
target="_blank">kylelf@gmail.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div><span \
style="white-space:pre-wrap;color:rgb(52,53,65);font-family:tahoma,sans-serif;font-size:large">I \
created a constraint to make the ATTACH command work \
immediately</span></div></div></blockquote><div><br></div><div>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.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jeff</div></div></div>
 </blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]