Patches with vacuum fixes available for 7.0.x
От | Alfred Perlstein |
---|---|
Тема | Patches with vacuum fixes available for 7.0.x |
Дата | |
Msg-id | 20001207145732.X16205@fw.wintelcom.net обсуждение исходный текст |
Ответы |
Re: Patches with vacuum fixes available for 7.0.x
Re: Patches with vacuum fixes available for 7.0.x Re: Patches with vacuum fixes available for 7.0.x Re: Patches with vacuum fixes available for 7.0.x |
Список | 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 indexcreated 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@wintelcom.net|alfred@freebsd.org] "I have the heart of a child; I keep it in a jar on my desk."
В списке pgsql-hackers по дате отправления: