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

On Fri, Mar 6, 2015 at 5:45 PM, John R Pierce <pierce@hogranch.com> wrote:
> 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).


Or put a naptime of 6h.