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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general