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

On 3/6/2015 10:46 AM, Bryce Nesbitt wrote:
> Given the use case on these machines, turning off auto vacuum
> completely was appropriate.
> The 1 minute vacuum is just fine for an active cluster, but the write
> churn on the SSD
> was not worth it here.  A read only workload would be fine.


eventually, you HAVE to vacuum for various reasons.  you might use a
cron job (or task scheduler) to setup a weekly job that does a vacuumdb -a).


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast