From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Patches with vacuum fixes available for 7.0.x |
Date: | 2000-12-07 22:57:32 |
Message-ID: | 20001207145732.X16205@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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."
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-12-07 23:17:20 | Re: v7.1 beta 1 ...packaged, finally ... |
Previous Message | Nathan Myers | 2000-12-07 22:45:49 | Re: CRCs (was: beta testing version) |