Re: Patch: Global Unique Index
| От | Justin Pryzby |
|---|---|
| Тема | Re: Patch: Global Unique Index |
| Дата | |
| Msg-id | 20221124160923.GO11463@telsasoft.com обсуждение |
| Ответ на | Re: Patch: Global Unique Index (Dilip Kumar <dilipbalaut@gmail.com>) |
| Ответы |
Re: Patch: Global Unique Index
|
| Список | 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 по дате отправления: