PostgreSQL performance and features have increased so much in recent versions that time spent trying to optimize an older version might be better spent planning an upgrade. Minor PostgreSQL releases focus on bug fixes, and can be effective at removing performance issues caused by bugs too.
At last this book has covered all the aspects of the performance of PostgreSQL. Including, performance improvement from hardware benchmarking to PostgreSQL benchmarking and how to detect the performance bottleneck using different tools and resolve that issue. Therefore this is a complete handbook for developers and database administrators.