On Dec 29, 2006, at 12:30 PM, Chris Browne wrote:
How you get the work to spread consistently across 6 hours is a challenge; personally, my preference would generally be to try to get the work done ASAP, so the goal seems a tad off to me...
Agreed. If we're going to monkey with automatically setting vacuum cost GUCs I'd *much* rather work towards having some kind of I/O priority scheme; that would allow vacuum to use as much I/O as it wants, provided nothing else in the system needs it.
-- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
