Re: (one more time) Patches with vacuum fixes available.

Sounds good to me. [Of course, I never met a patch I didn't like, or so
they say.]

> I know you guys are pretty busy with the upcoming release but I
> was hoping for more interest in this work.
>
> With this (which needs forward porting) we're able to cut
> vacuum time down from ~10minutes to under 30 seconds.
>
> The code is a nop unless you compile with special options(MMNB)
> specify the special vacuum flag (VLAZY) and doesn't look like it
> messes with anything otherwise.
>
> I was hoping to see it go into 7.0.x because of the non-intrusiveness
> of it and also because Vadim did it so he should understand it so
> that it won't cause any problems (and on the slight chance that it
> does, he should be able to fix it).
>
> Basically Vadim left it up to me to campaign for acceptance of this
> work and he said he wouldn't have a problem bringing it in as long
> as it was ok with the rest of the development team.
>
> So can we get a go-ahead on this? :)
>
> thanks,
> -Alfred
>
> ----- Forwarded message from Alfred Perlstein <bright(at)wintelcom(dot)net> -----
>
> From: Alfred Perlstein <bright(at)wintelcom(dot)net>
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: [HACKERS] Patches with vacuum fixes available for 7.0.x
> Date: Thu, 7 Dec 2000 14:57:32 -0800
> Message-ID: <20001207145732(dot)X16205(at)fw(dot)wintelcom(dot)net>
> User-Agent: Mutt/1.2.5i
> Sender: pgsql-hackers-owner(at)postgresql(dot)org
>
> 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."
>
> ----- End forwarded message -----
>
> --
> -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