On Fri, Aug 28, 2015 at 10:27 AM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Steve Kehlet <steve.keh...@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. > Thank you, I found it, this could be very helpful, we'll try it out on some dev boxes.
