Josh Kupershmidt <schmiddy@xxxxxxxxx> writes: > The solution for me was simply to run pg_stat_reset(), and the problem > went away within a few seconds. The $PGDATA/global/pgstat.stat file > was 1.2GB before the reset, and went down to ~250KB after the reset. > It looks like this file is adding on 4MB or so per day at the current > rate, so I'll likely have to do this again in a few months. Hm. It sounds like you are "leaking" stats collector table entries for some reason. It would be good to fix the underlying problem rather than just resign yourself to a manual workaround. Is there anything unusual about your workload that might trigger this? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
