Hi Josh, it's "known" issue, see this thread: http://archives.postgresql.org/pgsql-hackers/2010-02/thrd6.php#01290 HTH, Kuba Dne 8.2.2011 2:39, Josh Berkus napsal(a):
Ooops. It looks like you are right, see ./src/backend/postmaster/pgstat.c 3c2313f4 (Tom Lane 2008-11-03 01:17:08 +0000 2926) if (last_statwrite< last_statrequest) 70d75697 (Magnus Hagander 2008-08-05 12:09:30 +0000 2927) pgstat_write_statsfile(false);This is a different issue. This is happening because we have a bunch of databases (25 to 35) and as a result autovacuum is requesting the stats file rather frequently. And autovacuum for whatever reason won't accept a stats file more than 10ms old, so it pretty much rewrites the stats file on every request. At least, that's my reading of it after poking around and talking to Gierth. It seems like that 10ms window for autovac is way too small.
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
