Re: massive update on gin index - Mailing list pgsql-general

From Tom Lane
Subject Re: massive update on gin index
Date
Msg-id 2869288.1663185350@sss.pgh.pa.us
Whole thread Raw
In response to Re: massive update on gin index  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: massive update on gin index
List pgsql-general
Marcos Pegoraro <marcos@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



pgsql-general by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: massive update on gin index
Next
From: Marcos Pegoraro
Date:
Subject: Re: massive update on gin index