Top Development Mistakes When Working with PostgreSQL

on YouTube ↗53m

" summary

A PostgreSQL consulting team from Data Egret reviews the most common mistakes developers make when working with PostgreSQL, illustrating how development practices can create serious operational problems for DBAs. The talk covers concrete developer-side issues observed in real projects and offers examples and lessons drawn from consulting experience and post-mortems.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 5:21Planning and monitoring
3. 15:52Scaling PostgreSQL
4. 22:59Transactions and impact
5. 28:39Overengineering and queues
6. 33:17Automation and containers
7. 42:30Q&A

" related talks

• 41mApplication Development Challenges with PostgresDian Fay · PGConf.dev 2025
• 51mTypical application mistakes that lead to bloat in PostgreSQLAndrey Salnikov · Backend Conf 2018
• 01h 00mThe 10 Deadly PostgreSQL SinsMatt Yonkovit · Percona Community Live 2022
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 50mPostgreSQL gotchas for app developersMagnus Hagander · foss-north 2019
• 35mThe PostgreSQL Twin Bill: The 7 Deadly PostgreSQL Mistakes & Review of What's New in PostgreSQL 14Matt Yonkovit, Kishore Dahlstrom · Open Source Summit + Embedded Linux Conference + OSPOCon 2021
• 47mPostgreSQL worst practicesIlya Kosmodemyanskiy · HighLoad++ 2017
• 45mDebugging Databases for DevelopersKaren Jex · Devoxx France 2024