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 <[email protected]>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 <[email protected]>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 >> <[email protected]>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>
