Alvaro Herrera wrote:
To be frank, I'm not sure I understand what you're saying here. I'm
sure more analysis is good; that's easy to agree with.
However, I don't want to be trapped in a design that's too hard to
implement, or too hard for DBAs to manage.
+1
> There have been proposals to add these knobs:
- maximum number of simultaneous processes (and make it more than 1)
- times of day on which to change parameters (i.e. disable vacuum
altogether, or make it more agressive or less)
Of all the autovacuum improvement discussions that I've seen recently
the one additional knob that sounds like a good idea to me is a way to
specify "HOT" tables that get special attention from autovacuum. There
has been a lot of conjecture as to a good implementation, and I don't
have a position on that, but I do think it's a good idea.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
