Re: Patches with vacuum fixes available for 7.0.x

* Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> [010122 19:55] wrote:
>
> Vadim, did these patches ever make it into 7.1?

According to:
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/parser/gram.y?rev=2.217&content-type=text/x-cvsweb-markup

nope. :(

>
> > 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

--
-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."