> 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?
Don't think the database setup is that unusual. I did overestimate how quickly pgstat.stat is growing; it's only gone up to 800KB in the 20 hours since I ran pg_stat_reset(). I thought it was growing 4MB per day because last night it had grown to 500KB in just 3 hours. Also, it had ballooned to 1.2 GB after running for around a year, I think. Relevant stats-related info I can think of: * default_statistics_target = 10 * I don't think any tables have had ALTER TABLE SET STATISTICS done * the two really active databases have 2300 and 490 rows in pg_class * mostly bulk updates/inserts * PGDATA is 1.6 TB If there's some useful debugging info on the stats collector process I can gather from the server, I'd be happy to try. Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
