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