This blog article discusses several different method you can use to optimize the write and read operations of large databases using PostgreSQL.