Em qua., 14 de set. de 2022 às 16:55, Tom Lane <t...@sss.pgh.pa.us> escreveu:
> 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 > Correct, if I want use that index immediately with same performance I have to call select pg_catalog.gin_clean_pending_list('idxphones'); Or wait next autovacuum. thanks Marcos
