| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
| Cc: | Nikita Malakhov <hukutoc(at)gmail(dot)com>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Proposal: Global Index for PostgreSQL |
| Date: | 2025-06-10 19:38:11 |
| Message-ID: | aEiJo1kayLgMuDwl@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2025-06-10 20:09:53 | Re: Non-reproducible AIO failure |
| Previous Message | Masahiko Sawada | 2025-06-10 19:37:48 | Re: Improve tab completion for COPY |