Steve Kehlet <steve(dot)kehlet(at)gmail(dot)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