Postgres at any scale [EuroPython 2018 - Talk - 2018-07-25 - Lammermuir] [Edinburgh, UK] By Craig Kerstiens We’ll start with the basics you need to know as an app developer about interacting with your database, then dig into how you can start to analyze performance. We’ll look at things you need to know for a small application, then the things you should be cautious of as you start to layer in other items you need to be aware of for performance including: Cache hit ratio Index hit ratio Proper use of indexes Bloat Efficient joins Sharding License: This video is licensed under the CC BY-NC-SA 3.0 license: https://creativecommons.org/licenses/by-nc-sa/3.0/ Please see our speaker release agreement for details: https://ep2018.europython.eu/en/speaker-release-agreement/