> Filtering out with the pid showed that it was the file > pgdata/global/pgstat.tmp >> Filtering out with the pid showed that it was the file >> pgdata/global/pgstat.tmp > > That's the statistics collector -- which makes sense, depending > on your settings, it has to write stats for every operation done in the > database. > This smells of anti-virus software to me (usually the cause of problems with Postgres on windows). Are you running any? I had almost exactly the same problem on xp and 8.3 with pctools antivirus. This was causing the statistics collector to use 100% of a cpu core. You won't look back moving to Ubuntu - I haven't :-). Best regards, Will T -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
