Original author here, the adding an index on every column is very much a joke. A better solution would be taking advantage of pg_stat_statements in Postgres 9.2. It normalizes all queries which are run and tracks total time spent in your DB on those queries, this would be a clear way to determine where indexes can likely improve your performance. There's actually an earlier post I did which talks a bit more about this - http://www.craigkerstiens.com/2013/01/10/more-on-postgres-pe...