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

Bryce Nesbitt wrote:

> That all sounded really reasonable.    So I checked into turning off vac
> for this particular laptop
> and discovered:
>
> /etc/postgresql/9.3/main/postgresql.conf
> #autovacuum = on
> #autovacuum_naptime = 1min
>
> (At Ubuntu's default).

You need to uncomment and set off.

> So autovacuum is *not the droid we're looking for...*

Use "SHOW autovacuum" in psql to avoid being confounded by
mind-controlling superpowers.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services