ERROR: cannot create index on partitioned table concurrently

Поиск
Список
Период
Сортировка
От James Pang
Тема ERROR: cannot create index on partitioned table concurrently
Дата
Msg-id CAHgTRfc16_Riu9j=erY9GeY7a6bw1n8fHNhhJuqJ4o24obJxpw@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR: cannot create index on partitioned table concurrently  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Hi,
    PGv14 , we migrated from Oracle to Postgresql, recently, we migrate index job from Oracle to PG. in Oracle, it's ok to create index online on partitioned table, but in Postgresql, ERROR:  cannot create index on partitioned table concurrently. Instead, I go to create index concurrently on each child table separately. 
    my question is, from SQL optimizer perspective, any difference between "create index on partitioned root table" and  "create each index on child table directly", looks like optimizer still can use indexes with directly created on each child table.

Thanks,

James

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Log file retention
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Log file retention