Re: indexes on partitioned tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



FYI

On Tue, Jul 16, 2024 at 11:56 AM Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx> wrote:
Hi Wasim



On Fri, Jul 12, 2024 at 10:23 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:
Hi Kashif

Is there a steps to create the the partition tables ? 
Yes, you can check the following link

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@xxxxxxxxx> 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@xxxxxxxxx> 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 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux