On Tue, Dec 07, 2010 at 03:00:59PM -0500, Spencer Lamm wrote: > We're running DSpace 1.5.1 and Postgres 8.1.11 on a Linux machine. In the > last week we've been experiencing significant slowdowns; it now takes about > 30 seconds to add or delete items or metadata. If anybody has suggestions > for how to start tackling this, they would be greatly appreciated.
Upgrading Pg would be a good idea. 8.1 is no longer maintained. Should we understand that *only* adding and deleting items has slowed down? Or is your DSpace slower all over? > To date, we have done the following: > - ensured that extraneous/idle postgres processes are not slowing things > down. We do see what looks to be a high number of idle processes but killing > them and restarting tomcat does not address the speed issue. > - ensured that vacuumdb is running on the dspace database > - from the command line verified that simple adds/deletes to the item and > metadata tables in the database are working fine. > - turned on DEBUG for log4j.properties and saw a number of select > statements First: is the machine busy? What is it busy with? You've checked that the machine is not doing a lot of swapping? that your servlet container (e.g. Tomcat) is not starved of memory and spending too much time collecting garbage? that your Pg configuration is appropriate to the available memory and number of connections? -- Mark H. Wood, Lead System Programmer [email protected] Balance your desire for bells and whistles with the reality that only a little more than 2 percent of world population has broadband. -- Ledford and Tyler, _Google Analytics 2.0_
pgp779gNQiH7W.pgp
Description: PGP signature
------------------------------------------------------------------------------ What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
