Re: Unique constraint across all partitions?

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Unique constraint across all partitions?
Date: 2021-01-26 09:54:28
Message-ID: CAGnEbog8zbwc4_TBd7hZJALR5mUL_yZxm5+EUtgZCv3D34-wPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

вт, 26 янв. 2021 г. в 09:48, Thomas Kellerer <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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kanninen Anssi EXT 2021-01-26 10:09:07 RE: Unique constraint across all partitions?
Previous Message Thomas Kellerer 2021-01-26 08:48:01 Re: Unique constraint across all partitions?