Em qua., 14 de set. de 2022 às 16:55, Tom Lane <tgl@xxxxxxxxxxxxx> 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
