RE: Unique constraint across all partitions?

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(at)gmail(dot)com>
Sent: tiistai 26. tammikuuta 2021 11.54
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Unique constraint across all partitions?

вт, 26 янв. 2021 г. в 09:48, Thomas Kellerer <shammat(at)gmx(dot)net<mailto:shammat(at)gmx(dot)net>>:
> 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.

--
Victor Yegorov