Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique constraint across all partitions? - Mailing list pgsql-admin

From Victor Yegorov
Subject Re: Unique constraint across all partitions?
Date
Msg-id CAGnEbog8zbwc4_TBd7hZJALR5mUL_yZxm5+EUtgZCv3D34-wPQ@mail.gmail.com
Whole thread Raw
In response to Re: Unique constraint across all partitions?  (Thomas Kellerer <shammat@gmx.net>)
Responses RE: Unique constraint across all partitions?
List pgsql-admin
Tree view
вт, 26 янв. 2021 г. в 09:48, Thomas Kellerer <shammat@gmx.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

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Unique constraint across all partitions?
Next
From: Kanninen Anssi EXT
Date:
Subject: RE: Unique constraint across all partitions?