4 ms·
> If you committed a row update but didn't update the index, a subsequent query using the not yet updated index would not find the updated row correctly. I won
by SkiFire13 5mo ago
> If you committed a row update but didn't update the index, a subsequent query using the not yet updated index would not find the updated row correctly.
I wonder if you could make it so that queries read from both the index and the unindexed changes. It would be slightly slower but as long as the unindexed changes are kept small it might be fine.