Re: ATTACH PARTITION "hangs"

Поиск
Список
Период
Сортировка
От kyle Hailey
Тема Re: ATTACH PARTITION "hangs"
Дата
Msg-id CADsdiQhNM3G6hHRz=et-3G2sidN05U5scARyYt578-C8ego6yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ATTACH PARTITION "hangs"  (Jeff Janes <jeff.janes@gmail.com>)
Список 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.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 по дате отправления:

Предыдущее
От: Keith
Дата:
Сообщение: Re: ATTACH PARTITION "hangs"
Следующее
От: "Singh, Gambhir"
Дата:
Сообщение: pgsql code is not working.