Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats

bryce2(at)obviously(dot)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