Forum OpenACS Improvement Proposals (TIPs): Re: TIP #29: [Implemented] Tree_sortkey improvements for performance and concurrency on postgresql

Collapse
17: Re: TIP #29: [Implemented] Tree_sortkey improvements for performance and concurrency on postgresql (response to 1)
Posted by Caroline Meeks on 12/02/03 07:45 PM
Thanks again Jeff. I just applied this fix and the others from upgrade5.0.0b1 to b2 to b3 to b4 to a OACS4.6.3 site running pg 7.3 with 200,000 objects. It seems to work fine on 4.6.3 and it was a huge improvement in performance!

This is a great benefit to the toolkit.

For anyone who wants to experiment with these fixes on 4.6.3 the upgrades scripts I used are here:

http://cvs.openacs.org/cvs/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/