Re: Patches with vacuum fixes available for 7.0.x

Vadim, did these patches ever make it into 7.1?

> We recently had a very satisfactory contract completed by
> Vadim.
>
> Basically Vadim has been able to reduce the amount of time
> taken by a vacuum from 10-15 minutes down to under 10 seconds.
>
> We've been running with these patches under heavy load for
> about a week now without any problems except one:
> don't 'lazy' (new option for vacuum) a table which has just
> had an index created on it, or at least don't expect it to
> take any less time than a normal vacuum would.
>
> There's three patchsets and they are available at:
>
> http://people.freebsd.org/~alfred/vacfix/
>
> complete diff:
> http://people.freebsd.org/~alfred/vacfix/v.diff
>
> only lazy vacuum option to speed up index vacuums:
> http://people.freebsd.org/~alfred/vacfix/vlazy.tgz
>
> only lazy vacuum option to only scan from start of modified
> data:
> http://people.freebsd.org/~alfred/vacfix/mnmb.tgz
>
> Although the patches are for 7.0.x I'm hoping that they
> can be forward ported (if Vadim hasn't done it already)
> to 7.1.
>
> enjoy!
>
> --
> -Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
> "I have the heart of a child; I keep it in a jar on my desk."
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026