Description
At some point, every application is limited by the database. You don’t have to be a Postgres expert to get started with a few key performance improvements. This gentle introduction is meant for folks who’ve never ventured into their database before, or those who have been turning knobs blindly. I’ll present how Postgres uses memory. Then, I’ll connect that to how you can monitor, tune, and optimize queries. You’ll be ready to take on the challenge as your application grows.
#### Review of how Postgres uses memory Measuring cache hit ratio Measuring memory usage and tuning Measuring shared buffer usage and tuning
#### Connection settings Default connection settings, knowing when you need more
#### Stop runwaywas Setting a statement timeout Finding and stopping transactions
#### Query performance Using EXPLAIN Reading and understanding EXPLAIN plans Logging EXPLAIN plans Adding Indexes