[OPEN-ILS-DEV] 2.6 slowness

[Tim Spindler]

Ben,

Authorities is only a guess at this point.  The patch you refer to in the
bug has been applied.

I was only thinking about authorities because in comparing to NOBLE one of
our differences is the number of authorities.

On Wed, Oct 15, 2014 at 10:26 AM, Ben Shum <bshum at biblio.org> wrote:

> 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
>



-- 
Tim Spindler
tjspindler at gmail.com

*P**   Go Green - **Save a tree! Please don't print this e-mail unless it's
really necessary.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20141015/4c29f70a/attachment.htm>