2011/2/4 Josh Berkus <josh@xxxxxxxxxxxx>: > All, > > Seeing an issue which is new on me. On a mostly idle PostgreSQL server, > the stats collector is rewriting the entire stats file twice per second. > > Version: 8.4.4 > Server: Ubuntu, kernel 2.6.32 > Server set up: ApacheMQ server. 25 databases, each of which hold 2-3 > tables. > Filesystem: Ext4, defaults > Active connections: around 15 > Autovacuum settings: defaults > > Symptoms: on a server which gets around 20 reads and 15 writes per > minute, we are seeing average 500K/second writes by the stats collector > to pg_stat.tmp. pg_stat.tmp is around 270K. > > An strace of the stats collector process shows that the stats collector > is, in fact, rewriting the entire stats file twice per second. > > Anyone seen anything like this before? > it is the expected behavior, IIRC -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ ; PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
