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

[Rogan Hamby]

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130809/fe2d4ac1/attachment.htm>