Re: how to investigate GIN fast updates and cleanup cycles?

Steve Kehlet <steve.kehlet@gmail.com> writes:
> Yeah head scratch. That is really weird. Still gathering data, any way I
> can see for sure when these cleanup cycles are occurring?

contrib/pgstattuple has a function that can report the current size of the
pending list for a GIN index.  If you were to capture that every so often,
it'd be pretty easy to confirm or refute whether these episodes are
associated with list cleanup.

            regards, tom lane