5 ms·

Currently using Postgres, but not utilising any of its more powerful features.

• wfn 12y ago
  I'd start with going over the points of this article (assuming you haven't done just that:) -- https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
  • akurilin 12y ago
    The PostgreSQL 9.0 High Performance book has been great for us, goes in depth into most interest variables that you can tweak on your instance to make sure you're making the most out of your machine's resources: http://www.packtpub.com/postgresql-90-high-performance/book http://www.packtpub.com/postgresql-90-high-performance/book A bit of a lengthy read, but worth it.
    • sciurus 12y ago
      Seconding this. Packt Publishing is really hit or miss, but PostgreSQL 9.0 High Performance is a hit.