[OPEN-ILS-GENERAL] [OPEN-ILS-DEV] 2.6 slowness

[Ben Shum]

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 <tjspindler at gmail.com> 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
> tjspindler at gmail.com
>
> 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