[OPEN-ILS-GENERAL] Evergreen & Software Performance Analysis

[Rogan Hamby]

Picking back up an old thread...

I was hoping at some point to hear more about the db work Command Prompt
has done for KCLS and perhaps see some work in git. I was sad to see that
in the new LJ article that Jed Moffitt said that at this point KCLS has
forked Evergreen so I suppose the work Catalyst and Command Prompt has done
isn't relevant to the rest of the Evergreen community.  I suppose that also
means that any experience gained in working on the KCLS system isn't
transferrable.






On Thu, Aug 22, 2013 at 11:05 AM, Rogan Hamby <rogan.hamby at yclibrary.net>wrote:

> Hi Joshua,
>
> I don't know if you had a chance to see my message below so I'll copy you
> in directly as well and maybe touch base again after labor day.  With the
> Evergreen community having a rich collection of input from various
> contributors (many like yourself paid to do individual development by
> community members) all participating in the open source spirit and putting
> their code out there, allowing others to build on top of it or modify it or
> package it into master it would be exciting to see this work since you've
> indicated it's had a big impact for your customers.
>
> I did a quick mark mail search since I sometimes lose emails to spam
> filters and noticed that back in Feb you mentioned that your Evergreen
> customer has been KCLS.  I know that at the conference they talked about
> setting up a public repo that would be available right after the
> conference.  Maybe they can chime in on an update on that?
>
>
>
> On Fri, Aug 9, 2013 at 11:52 AM, Rogan Hamby <rogan.hamby at yclibrary.net>wrote:
>
>> HI Josh,
>>
>> Can you share with folks some more specifics?
>>
>> For example:
>>
>> In regards to optimizing the conf file can you share what kind of
>> optimizations and the benchmarks?  E.g. with X records we see Y performance
>> in activity Z.
>>
>> A lot of other changes obviously touch on changes to code and/or schema
>> changes.  Are these going to be released on a public repo or fed back into
>> master?
>>
>>
>>
>>
>>
>> On Thu, Aug 8, 2013 at 2:01 PM, Joshua D. Drake <jd at commandprompt.com>wrote:
>>
>>>
>>> On 08/07/2013 10:12 AM, Rogan Hamby wrote:
>>>
>>>> I'm guessing maybe Joshua doesn't keep track of the list serv but is
>>>> there someone else from Command Prompt or whomever they did the
>>>> development work for that could chime in?  When he says they've made
>>>> improvements do those include GPLed code?
>>>>
>>>
>>> Sorry folks, I do watch this list but not as much as the postgresql
>>> lists. We have also been very busy. Here are some of the basic things we
>>> have done:
>>>
>>> 1. Optimized the postgresql.conf, it is amazing how much you can get
>>> from some minor tweaks after some performance analysis.
>>>
>>> 2. Converted some of the procedures to C, for example translate_isbn1013
>>>
>>> 3. Modified the holds process to use a look up table.
>>>
>>> 4. Changed the process for holds so they don't indefinitely exist but
>>> get migrated out for reporting but does not affect performance of the
>>> active table.
>>>
>>> 5. Partitioning of larger tables
>>>
>>> 6. Upgraded versions of PostgreSQL to more modern versions (this can
>>> also result in noticeable gains in performance).
>>>
>>> 7. Lots of query tuning, adding indexes where appropriate, increasing
>>> maintenance on particular tables to reduce bloat more aggressively etc...
>>>
>>> As well as various other things (stabilizing the system so there isn't
>>> weird overloads, unexpected apache load events etc..). It certainly has
>>> been a rather wild ride over the last 9 months as we get further and
>>> further into the adventure that is the Evergreen software.
>>>
>>> Sincerely,
>>>
>>> Joshua D. Drake
>>>
>>>
>>>
>>>
>>> --
>>> Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
>>>
>>> PostgreSQL Support, Training, Professional Services and Development
>>> High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
>>> For my dreams of your image that blossoms
>>>    a rose in the deeps of my heart. - W.B. Yeats
>>>
>>
>>
>>
>> --
>>
>> Rogan Hamby, MLS, CCNP, MIA
>> Managers Headquarters Library and Reference Services,
>> York County Library System
>>
>> "You can never get a cup of tea large enough or a book long enough to
>> suit me."
>> -- C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
>>
>
>
>
> --
>
> Rogan Hamby, MLS, CCNP, MIA
> Managers Headquarters Library and Reference Services,
> York County Library System
>
> "You can never get a cup of tea large enough or a book long enough to suit
> me."
> -- C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
>



-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services,
York County Library System

"You can never get a cup of tea large enough or a book long enough to suit
me."
-- C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130924/8fc48968/attachment-0001.htm>