From: | "Stephen" <jleelim(at)xxxxxxx(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Experimental patch for inter-page delay in VACUUM |
Date: | 2003-11-03 15:04:52 |
Message-ID: | o7upb.8716$qL7.8160@nntp-post.primus.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I don't mind the long delay as long as we have a choice as we clearly do in
this case to set vacuum_page_delay=WHATEVER. Of course, if VACUUM can be
improved with better code placement for the delays or buffer replacement
policies then I'm all for it. Right now, I'm pretty satisfied with the
responsiveness on large DBs using vacuum_page_delay=10ms delay.
Any ideas if this patch will be included into 7.4 before final release?
Stephen
"Andrew Dunstan" <andrew(at)dunslane(dot)net> wrote in message
news:3FA57532(dot)3020902(at)dunslane(dot)net(dot)(dot)(dot)
>
> Not surprising, I should have thought. Why would you care that much?
> The idea as I understand it is to improve the responsiveness of things
> happening alongside vacuum ("real work"). I normally run vacuum when I
> don't expect anything else much to be happening - but I don't care how
> long it takes (within reason), especially if it isn't going to intefere
> with other uses.
>
> cheers
>
> andrew
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2003-11-03 15:33:21 | Experimental ARC implementation |
Previous Message | Tom Lane | 2003-11-03 15:04:39 | Re: equal() perf tweak |