Re:Optimizing Postgres text search with trigrams
by thom on Wednesday February 23, 2022 @09:41AM
(#30441459)
As long as there's a key on the materialized view you can rebuild it concurrently with no locks, and if you remember to vacuum there's no particular overhead to doing this regularly. Smaller more targeted updates seem good to me though if you want things instantly in the index.
[ Parent
| on HN ]
There are no comments on this comment yet.