Re: Proposal: Global Index for PostgreSQL

Dilip Kumar <dilipbalaut@gmail.com>

From: Dilip Kumar <dilipbalaut@gmail.com>

To: Bruce Momjian <bruce@momjian.us>

Cc: Nikita Malakhov <hukutoc@gmail.com>, wenhui qiu <qiuwenhuifx@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-06-11T03:04:24Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

xml2: Improve error handling of libxml2 calls
- 732061150b00 19 (unreleased) cited

On Wed, Jun 11, 2025 at 1:08 AM Bruce Momjian <bruce@momjian.us> wrote:
>
> 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:

Oh interesting, I would be happy to have a look at it, Thanks.

-- 
Regards,
Dilip Kumar
Google