Hi,
what you proposed seems correct to me.
I don't know how to list indexes from a partitionned index.
You can check if your indexes are valid using:
select i.relname as indexname,i.relkind, t.relname as tablename,
t.relkind, idx.indisvalid
from pg_class i
join pg_index idx on idx.ind
I apologize for the lengthy post. I'm trying to get in all the details.
We recently upgraded our Postgres AWS RDS from 9.5 to 11.1.
We have several large partitioned tables implemented using inheritance that
we are considering converting to declarative partitioning.
(I'm talking about 5TB of par
