Marcos Pegoraro <mar...@f10.com.br> writes: > I know I have other options, and possibly better, but I was trying to > understand what happens with gin indexes, just that.
GIN does have a "pending list" of insertions not yet pushed into the main index structure, and search performance will suffer if that gets too bloated. I don't recall much about how to control that, but I think vacuuming the table will serve to empty the pending list. Also see https://www.postgresql.org/docs/current/gin-implementation.html#GIN-FAST-UPDATE regards, tom lane
