Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats - Mailing list pgsql-bugs

From Claudio Freire
Subject Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Date
Msg-id CAGTBQpaB4UbhcZKe4OUhiosxh4+bFjNV_x9tz2LwWVo0yJDeQg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Next
From: Jean-Pierre Pelletier
Date:
Subject: Cluster set to French_France when French_Canada selected in 9.4.1 x64 Windows Installer