Re: indexes on partitioned tables

FYI

On Tue, Jul 16, 2024 at 11:56 AM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
wrote:

> Hi Wasim
>
>
>
> On Fri, Jul 12, 2024 at 10:23 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
>
>> Hi Kashif
>>
>> Is there a steps to create the the partition tables ?
>>
> Yes, you can check the following link
> https://www.postgresql.org/docs/current/ddl-partitioning.html
>
>>
>> I mean to say first create the tables and then insert the data lastly
>> create index on them ?
>>
> It's up to you which way you follow
> You can create the table and indexes first and insert data later and vice
> versa.
>
>>
>> What I did I created the table at once with all partition tables and
>> indexes and then I inserted data by insert script. Is it ok?
>>
> Yes
>
>>
>> And I also created the indexes globally on the parent table the partition
>> tables automatically took the indexes. Let me know what you think.
>>
>> Thanks,
>> Wasim
>>
>> On Thu, 11 Jul, 2024, 1:54 pm Kashif Zeeshan, <kashi(dot)zeeshan(at)gmail(dot)com>
>> wrote:
>>
>>> Hi
>>>
>>> When you create an index on Partition table then the index is created
>>> for all the Partitions so when you re-index then you need to re-index each
>>> partition separately.
>>>
>>> Regards
>>> Kashif Zeeshan
>>>
>>> On Thu, Jul 11, 2024 at 1:16 PM Wasim Devale <wasimd60(at)gmail(dot)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?
>>>>
>>>> Thanks,
>>>> Wasim
>>>>
>>>