Re: Proposal: Creating multiple indexes on a table using a single full table scan

From: Aleksander Alekseev <aleksander(at)tigerdata(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: Ильдар <igaraev77(at)yandex(dot)com>
Subject: Re: Proposal: Creating multiple indexes on a table using a single full table scan
Date: 2025-09-10 14:12:44
Message-ID: CAJ7c6TPgzJ+jEAQQAkpYXtOu5bjqmW+v=vbBoJLWmjW3Z=Wweg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Ildar,

> I’m curious:
> - Has this been discussed before?
> - Are there any technical reasons why this wouldn’t be feasible?
> - Would such a patch be of interest to the community?

This might be a promising area for research. I suggest starting with
figuring out where exactly the bottleneck is when you execute 10
queries CREATE INDEX on your particular database. There is a decent
chance that the actual bottleneck is far from the place you think it
might be (writing to the disk, as an example).

--
Best regards,
Aleksander Alekseev

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Corey Huinker 2025-09-10 15:11:09 Re: someone else to do the list of acknowledgments
Previous Message Robert Haas 2025-09-10 14:11:54 Re: plan shape work