Blogged: 12 practices for optimizing PostgreSQL queries for large datasets

https://blog.elmah.io/12-practices-for-optimizing-postgresql-queries-for-large-datasets/

Boost PostgreSQL performance with 12 expert tips for large datasets from partitioning to partial indexes and avoiding bloat. Stay fast and scale.