Re: Background vacuum - Mailing list pgsql-performance

From Ron Mayer
Subject Re: Background vacuum
Date
Msg-id 464F7C54.7090902@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Background vacuum  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Greg Smith wrote:
>
> Let's break this down into individual parts:

Great summary.

> 4) Is vacuuming a challenging I/O demand?  Quite.
>
> Add all this up, and that fact that you're satisfied with how nice has
> worked successfully for you doesn't have to conflict with an opinion
> that it's not the best approach for controlling vacuuming.  I just
> wouldn't extrapolate your experience too far here.

I wasn't claiming it's a the best approach for vacuuming.

From my first posting in this thread I've been agreeing that
vacuum_cost_delay is the better tool for handling vacuum.  Just
that the original poster also asked for a way of setting priorities
so I pointed him to one.

pgsql-performance by date:

Previous
From: "s d"
Date:
Subject: QP Problem
Next
From: Tom Lane
Date:
Subject: Re: QP Problem