Re: indexes on partitioned tables - Mailing list pgsql-admin

Hi Wasim

On Fri, Jul 12, 2024 at 10:23 AM Wasim Devale <wasimd60@gmail.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.zeeshan@gmail.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@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?

Thanks,

Wasim