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
