But why use global indexes?
Oracle also has local partitioned indexes which are just like we would like to have in PostgreSQL.
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Sent: tiistai 26. tammikuuta 2021 11.54
To: Thomas Kellerer <shammat@xxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Unique constraint across all partitions?
> Global indexes are likely more pain than gain.
While not extremely popular, many Oracle users do find them useful.
I've heard and been advised many times exactly the opposite for ORACLE,
especially when performance is important.
Global indexes makes a 15-minute maintenance job into a 9-hour downtime experience.
--
