Best Practices for Optimizing Postgres Query Performance
Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk.
In this book you will learn:
- Database Performance = Application Performance
- Missing indexes are the #1 database performance problem
- How to figure out what’s going on in your database(s)
- Gathering EXPLAIN plans automatically using auto_explain
- Determining missing indexes based on EXPLAIN plans