Re: Patch: Global Unique Index - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: Patch: Global Unique Index
Date
Msg-id 20221124160923.GO11463@telsasoft.com
Whole thread Raw
In response to Re: Patch: Global Unique Index  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Patch: Global Unique Index
List pgsql-hackers
On Thu, Nov 24, 2022 at 07:03:24AM +0100, Pavel Stehule wrote:
> I can imagine a unique index on partitions without a special mark, that
> will be partitioned, 

That exists since v11, as long as the index keys include the partition
keys.

> and a second variant classic index created over a partitioned table,
> that will be marked as GLOBAL.

That's not what this patch is about, though.

On Thu, Nov 24, 2022 at 08:52:16PM +0530, Dilip Kumar wrote:
> but now you will have one gigantic index and which will be vacuumed
> every time we vacuum any of the partitions.

This patch isn't implemented as "one gigantic index", though.

-- 
Justin



pgsql-hackers by date:

Previous
From: "Takamichi Osumi (Fujitsu)"
Date:
Subject: RE: logical replication restrictions
Next
From: T Adachi
Date:
Subject: Does pg_rman support PG15?