Hi Tim, When we upgraded to Evergreen 2.6, we also changed a lot of our infrastructure in terms of moving to better database server equipment (faster CPU, memory, using SSDs, etc.) so at first, we felt things were nice and speedy. Things became slow for us due to unforeseen performance issues related to large numbers of entries in our uncontrolled record attribute values table. See this bug (due to be fixed in upcoming maintenance releases of Evergreen): https://bugs.launchpad.net/evergreen/+bug/1374091. When we fixed this in our systems, we saw significant improvement in catalog performance.
That all said, the way you phrased your questions makes me wonder if you've already identified slowness in your catalog specifically relating to authorities. Have you guys pinpointed any specific queries that are slow on your systems? What makes you suspect authorities (which I wouldn't expect to impede regular keyword searches, or checkin/checkout)? When we were at the Hack-A-Way in South Carolina a few weeks ago, we started logging and then running explain analyze on specific queries from our PostgreSQL logs that appeared to be taking longer than generally expected. We do not have authorities yet in our Evergreen system, so we can't test that particular round of things in our environment. Also, I wonder about other areas, like not having enough memory to keep your database fully cached and getting disk I/O issues. Or postgresql.conf tuning choices. -- Ben On Wed, Oct 15, 2014 at 9:29 AM, Tim Spindler <[email protected]> wrote: > I was wondering if others experienced any slowness when upgrading tot 2.6. > On our test server we have seen a a lot slower searches and checkins and > checkouts going from 2.5 to 2.6 and are trying to determine what the issue > is. We are running Postgres 9.1 and have a little more than 1 million > authorities and we were wondering if anyone has seen similar issues. > > I am particular interested in your experience if you have a full set of > authorities loaded, linked and indexed. > > -- > Tim Spindler > [email protected] > > C/W MARS > http://www.cwmars.org > > P Go Green - Save a tree! Please don't print this e-mail unless it's > really necessary. > > -- Benjamin Shum Evergreen Systems Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 203-577-4070, ext. 113
