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

From Bryce Nesbitt
Subject Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Date
Msg-id CAC9LFPc3xHYq40MWsKh1fgo9qLKUauPKx67GV543sGv8eN_BHg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats  (Kevin Grittner <kgrittn@ymail.com>)
Responses 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 10:33 AM, Kevin Grittner <kgrittn@ymail.com> wrote:

> Bryce Nesbitt <bryce2@obviously.com> wrote:
>
> > Autovac was the droid I was looking for. On orders of the Empire,
> > that droid has been eliminated on twenty five laptops.
>
> What, exactly, did you do to "eliminate" that?
>

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.

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Next
From: John R Pierce
Date:
Subject: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats