Re: Proposal: Global Index for PostgreSQL - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Proposal: Global Index for PostgreSQL
Date
Msg-id aEiJo1kayLgMuDwl@momjian.us
Whole thread Raw
In response to Re: Proposal: Global Index for PostgreSQL  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Mon, Jun  9, 2025 at 05:51:25PM -0400, Bruce Momjian wrote:
> On Mon, Jun  9, 2025 at 03:28:38PM +0530, Dilip Kumar wrote:
> There are certainly use cases where this would be helpful, but I think
> the big question is whether it would have so many negatives that most
> people who try to use it would eventually remove it.  I have heard that
> happened to other relational systems who support global indexes, so I
> think we have to consider that possibility.  The problem is you might
> need to actually write the patch to find out.

FYI, I wrote a blog about global indexes in 2020:

    https://momjian.us/main/blogs/pgblog/2020.html#July_1_2020

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Improve tab completion for COPY
Next
From: Andres Freund
Date:
Subject: Re: Non-reproducible AIO failure