Re: how to investigate GIN fast updates and cleanup cycles? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to investigate GIN fast updates and cleanup cycles?
Date
Msg-id 25673.1440782828@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to investigate GIN fast updates and cleanup cycles?  (Steve Kehlet <steve.kehlet@gmail.com>)
Responses Re: how to investigate GIN fast updates and cleanup cycles?
List pgsql-general
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


pgsql-general by date:

Previous
From: Steve Kehlet
Date:
Subject: Re: how to investigate GIN fast updates and cleanup cycles?
Next
From: Tom Lane
Date:
Subject: Re: how to investigate GIN fast updates and cleanup cycles?