Hello, Sergey!
This is a great idea, so great as I have implemented it :) Check [0] and
[1] for details.
Review and comments are welcome.
[0]:
https://www.postgresql.org/message-id/flat/CADzfLwVOcZ9mg8gOG%2BKXWurt%3DMHRcqNv3XSECYoXyM3ENrxyfQ%40mail.gmail.com#52c97e004b8f628473124c05e3bf2da1
[1]
Hi PostgreSQL Hackers,
I've been exploring the process of concurrent index creation and noticed a
potential area for performance improvement, especially for large indexes.
Currently, the process involves multiple stages: creating the index
(initially invalid and not ready), builing the index, vali