3 ms·

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 ht

• 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.