Russell Smith <mr-russ(at)pws(dot)com(dot)au> writes:
> Given vacuum must then touch every page, is there a win in only setting
> hint bits on pages where vacuum has to do some other work on the page?
> As vacuum is causing significant IO load for data that may not be
> accessed for some time.
Well, if vacuum doesn't do it then some other poor sod will have to.
My feeling is that vacuum's purpose in life is to offload maintenance
cycles from foreground queries, so we should be happy to have it setting
all the hint bits. If Kevin doesn't like the resultant I/O load then he
should use the vacuum_cost_delay parameters to dial down vacuum speed.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Heikki Linnakangas||Date: 2007-12-14 11:03:56|
|Subject: Re: Need help on parameters and their values to tune the
|Previous:||From: Russell Smith||Date: 2007-12-14 07:30:11|
|Subject: Re: Heavy write activity on first vacuum of fresh TOAST