Henrietta Dombrovskaya’s Post

Thanks, this article was very interesting! I noticed that Postgres changes the index names on partitions, but never understood why. I didn't face your issue because of a whole different setup we had. In our setup, I used pg_cron to create new partitions monthly. The script also creates properly named indexes on each newly created partition. The index could be attached to the index on the partitioned table, and this way PostgreSQL won't bother creating an index.