Re: Proposal: Creating multiple indexes on a table using a single full table scan - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Proposal: Creating multiple indexes on a table using a single full table scan
Date
Msg-id CAJ7c6TPgzJ+jEAQQAkpYXtOu5bjqmW+v=vbBoJLWmjW3Z=Wweg@mail.gmail.com
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: plan shape work
Next
From: Corey Huinker
Date:
Subject: Re: someone else to do the list of acknowledgments