Comment by semiquaver

  > You rebuild the index periodically to fix this, but during the rebuild (which can take hours for large datasets), what do you do with new inserts? Queue them? Write to a separate unindexed table and merge later?

What is wrong with REINDEX CONCURRENTLY?