Hi, we have a postgresql 9.0, I setup collectd to gather some information. It frequently ask the database about the bgwriter state by requesting "select * from pg_stat_bgwriter" (among other stats). It seems that this requets takes 6-7s to answer and in the log we got "pgstat timeout" Note: The database is constantly loaded with insert (but not overloaded).
Does someone have an idea why such request can take so long to answer. I was thinking bgwriter stats is just a matter of picking global info in memory. Can it be due to locks of some sort ? Cordialy, Nicolas Zin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
