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

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Дата
Msg-id CAC9LFPc3xHYq40MWsKh1fgo9qLKUauPKx67GV543sGv8eN_BHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Следующее
От: John R Pierce
Дата:
Сообщение: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats