Re: Proposal for Improving Concurrent Index Creation Performance

2025-06-12 Thread Mihail Nikalayeu
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]

Proposal for Improving Concurrent Index Creation Performance

2025-06-11 Thread Sergey Sargsyan
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