Running libraries on PostgreSQL: PGCon 2012 talk

Posted on Sun 20 May 2012 in Libraries • Tagged with Evergreen, PostgreSQL, evergreen, postgresql

On Friday, May 18th I gave a talk at the PGCon 2012 conference on the use of PostgreSQL by the Evergreen project. My talk fell in the case study track, which meant that I had been asked to describe to PostgreSQL developers what Evergreen was, why it was a project …


Continue reading

Running libraries on PostgreSQL: PGCon 2012 talk

Posted on Sun 20 May 2012 in Libraries • Tagged with Evergreen, PostgreSQL, evergreen, postgresql

On Friday, May 18th I gave a talk at the PGCon 2012 conference on the use of PostgreSQL by the Evergreen project. My talk fell in the case study track, which meant that I had been asked to describe to PostgreSQL developers what Evergreen was, why it was a project …


Continue reading

Tuning PostgreSQL for Evergreen on a test server

Posted on Mon 14 April 2008 in Libraries • Tagged with Evergreen, PostgreSQL

Update 2008-05-01: Fixed a typo for sysctl: -a parameter simply shows all settings; -w parameter is needed to write the setting. Duh.

Once you have decided on and acquired your test hardware for Evergreen, you need to think about tuning your PostgreSQL database server. Once you start loading bibliographic records …


Continue reading