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

[Joshua D. Drake]

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