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