Maurizio, the mentioned thread in the OpenACS forum is about speed, not functionality. The issue came up for large sites when postgres changed the rules for their optimizer. I would think that most OpenACS sites work fine with current pg versions. The 9.* support is in OpenACS CVS since July last year (rather large change, bring stored procedures to the level of current postgres, substantial changes in 55 files, see [1]). Since recursive queries are as well rather new in pg, and the changes for OpenACS to use recursive queries requires update-scripts that might run a few hours, we sent the recursive query optimizations to the main stakeholders at the begin of this year and received little feedback so far (maybe they prefer to be conservative for their large sites, maybe they don't have the mentioned performance issue). The recursive query optimizations are as well publically available [2]. Yes, the code will go from our point of view into future OpenACS, but we are not the only OpenACS users, and we do not want to break other installations...
This discussion is here somewhat off-topic, it has nothing to do with aolserver (or Windows support). -gustaf neumann [1] http://cvs.openacs.org/changelog/OpenACS/openacs-4/packages/acs-kernel [2] http://www.openacs.org/forums/message-view?message_id=3959984 On 29.09.12 13:15, Maurizio Martignano wrote: > Dear Gustav, > You wrote this post on the OpenACS forum: > http://www.openacs.org/forums/message-view?message_id=3847401 > > You are in the best position to explain this point, you decided to use > recursive queries (CTEs) and replace this way huge materialized tree tables. > I can only agree with this approach. > But what is this? Something you did in your installations, or something > commonly available in the OpenACS distributions, tar balls? Has the OpenACS > data model changed accordingly? > If yes my concern was a non-issue and I apologize for it. > If not my concern is real and OpenACS does not support the latest versions > of PostgreSQL. > > I hope to have been clearer this time. > > Maurizio > > ------------------------------------------------------------------------------ How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ aolserver-talk mailing list aolserver-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/aolserver-talk
