User Tools

Site Tools


Optimizing the performance of your Evergreen server

PostgreSQL Database Configuration

NOTE: Originally compiled at the Developer Hack-a-way, November 2015

Operation System Considerations

Hardware Considerations:

  • RAID Cache + Battery + Writeback Cache (when battery is present / enabled)
  • separate RAID volumes for the data directory
  • separate RAID volume for the xact_log
  • BIOS
    • hyperthreading disabled (bshum)
  • Ideally enough RAM to cache entire database (or at least metabib tables and indexes) – RAM is faster than SSD


  • Use recent version of MARC::File::XML that uses DOM rather than SAX
  • Avoid running anything other than Pg on the database server
  • Check page size for searching
  • Tuning opensrf.xml - max children - cstore/pcrud in particular
  • Separate tasks onto different physical (or virtual) machines



Apache server optimization (written in 2009)

There are a number of steps you can follow to optimize your Apache server.

  1. Enable mod_deflate to send compressible content over the network in gzipped format:
    1. a2enmod deflate # on Debian or Ubuntu
    2. Edit /etc/apache2/mods-enabled/deflate.conf to set CSS and JavaScript to the set of file types that will be compressed. You can't currently keep text/html and text/xml as XMLENT currently conflicts with DEFLATE:
      <IfModule mod_deflate.c>
                AddOutputFilterByType DEFLATE text/css application/javascript
  2. Cache content that does not change often using the mod_expires Apache module. You can set some simple caching rules in /etc/apache2/sites-enabled/eg.conf:
    ExpiresActive On
    # Set default expiry time to one month - we could probably make this 6 months
    ExpiresDefault "access plus 1 month"
    ExpiresByType text/html "access plus 25 hours"
    ExpiresByType application/xhtml+xml "access plus 25 hours"
  3. Requires Evergreen 1.6 or higher: Parallelize the requests to your server using multiple hosts. Most browsers will send a maximum of 2 to 4 concurrent requests to the same hostname, and as Evergreen pages pull in a lot of CSS, JavaScript, and image files, this can result in some unpleasant loading delays. A simple workaround is to set up CNAME entries to point multiple hostnames at the same IP address, but be warned that unless you have a valid wildcard SSL certificate, your users may have an unpleasant experience if they try to log in to their account.
    1. Set up hostnames to serve your JavaScript, CSS, and image files separately from your core content. If "" is your primary hostname, you could set up "", "", and "" as hostnames that point to the same IP address as "". Then, edit /etc/apache2/eg_vhost.conf to set the environment variables for the various included files as follows:
      <LocationMatch /opac/>
          ... other stuff, snipped
          SetEnvIf Request_URI ".*" OILS_OPAC_BASE=/opac/
          # This gives you the option to configure a different host to serve OPAC images from
          # Specify the hostname (withouth protocol) and path to the images.  Protocol will
          # be determined at runtime
          SetEnvIf Request_URI ".*"
          SetEnvIf Request_URI ".*"
          SetEnvIf Request_URI ".*"
documentation/performance.txt · Last modified: 2022/02/10 13:34 by

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.