Configuration Tuning for PostgreSQL 9.1 PostGIS 1.5 Ubuntu 12.04 Server

Did you tune your PostgreSQL server or are you using it OOTB after doing an apt-get install postgresql-server?

PostgreSQL is known for being installed with very, very conservative settings. You can gain a lot by properly tuning your server. Luckily there's an excellent post on this by the guys from opengeo: http://workshops.opengeo.org/postgis-intro/tuning.html