Salman Ahmed gives us a 10,000 foot view of two topics:
When it comes to managing large and complex databases in PostgreSQL, an important decision you’ll face is how to optimize your data storage and retrieval strategies. Two common techniques for improving database performance and manageability are indexing and partitioning in PostgreSQL.
Read on for a quick overview of each topic, including the variety of index types and partitioning strategies available.