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 <j...@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>