Re: Proposal: Global Index for PostgreSQL

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>

To: Dilip Kumar <dilipbalaut@gmail.com>

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

Date: 2025-06-10T19:38:11Z

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 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.