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