Hi, Antonin! On Thu, Nov 27, 2025 at 6:40 PM Mihail Nikalayeu <[email protected]> wrote: > > 1. Create an empty index. > Yes, patch does exactly the same, introducing special lightweight AM - > STIR (Short Term Index Replacement) to collect new tuples.
Initially understood incorrectly - in your solution you propose to use a single index. But STIR is used to collect new coming tuples, while the main index is built using a batched way. > To avoid insertions of tuples that concurrent transactions have just > inserted, we'd need something like index.c:validate_index() (i.e. insert > into the index only the tuples that it does not contain yet), but w/o > snapshot because we already have the heap tuples collected. And later main and STIR are merged. Best regards, Mikhail.
