Thanks Jun for bringing this to the forums. Let me add some more specifics.
We're using OpenACS pre-Alpha on postgres 7.1.3.
The OpenACS 4 production site that I handle in particular uses
ACS-Message extensively and most of the 40,000 are actually acs_message objects.
Along the road to reaching the 40,000 + records on acs_objects we
noticed that restarting the server slows down on two querries ( I will
try to post them later ) even with regular nightly vacuuming.
Also, I have just recently found out that the Package Manager page takes a very long time to load.
The rest of the site is running splendidly except for the above two
observations.
Jun mentions that some of the above may have already been resolved in the newer CVS / tarballs of OpenACS but we are not 100% sure.
Many Thanks....
