bryce2@obviously.com writes:
> Every minute postgresql runs the "stats" process which writes the following
> files:
> postgres(3814): CW /var/lib/postgresql/9.4/main/pg_stat_tmp/db_0.tmp
> postgres(3814): CW /var/lib/postgresql/9.4/main/pg_stat_tmp/global.tmp
> postgres(3814): CW /var/lib/postgresql/9.4/main/pg_stat_tmp/db_12066.tmp
> postgres(3814): CW /var/lib/postgresql/9.4/main/pg_stat_tmp/global.stat
> postgres(568): CW /var/lib/postgresql/9.4/main/base/12066/11868
> unknown(568): CW /var/lib/postgresql/9.4/main/global/12062
> unknown(568): CW /var/lib/postgresql/9.4/main/base/12066/11828
> unknown(568): CW /var/lib/postgresql/8.4/main/base/12066/11833
The stats collector only writes something when asked to. In this
case what's asking for stats is probably the autovacuum launcher.
You could dial back the autovacuum naptime if you want fewer
autovacuum wakeups.
regards, tom lane