Re: indexes on partitioned tables
| От | Wasim Devale |
|---|---|
| Тема | Re: indexes on partitioned tables |
| Дата | |
| Msg-id | CAB5fag6kq8Zz6x-KBDn_2NzLGDjbYBukmYV7_qELPq82GuVuBg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: indexes on partitioned tables (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: indexes on partitioned tables
Re: indexes on partitioned tables |
| Список | pgsql-admin |
Hi Ron
I created the indexes on the parent table globally and ran the create script with partitioned tables script, the parent table with child tables are created and I can see indexes are created on child tables too.
Then I inserted data from existing table.
Thanks,
Wasim
On Thu, 11 Jul, 2024, 6:09 pm Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Thu, Jul 11, 2024 at 4:16 AM Wasim Devale <wasimd60@gmail.com> wrote:Hi All,I have partitioned a table and levied indexes on it but when I do maintenance activities like reindexing it's not happening and the error is index not present on the partitioned table.Please highlight some points on it, Is I am missing something?Show us the code. Maybe you're doing "CREATE INDEX ... ON ONLY ...;" Or something else; we don't know, since your question is light on details.
В списке pgsql-admin по дате отправления: