Scaling Postgres Episode 5 | Constraints | User Order | PG Terrible | Logical Upgrades
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication for upgrades.
Content Discussed
- Database constraints in Postgres: The last line of defense
- User-defined Order in SQL
- PostgreSQL: Speeding up analytics and windowing functions
- Why is PostgreSQL Terrible?
- Time Series Database Lectures #6 - Mike Freedman (TimescaleDB)
- An Overview of Logical Replication in PostgreSQL
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Slides)
- Announcing general availability of Azure database services for MySQL and PostgreSQL
- Using pg_badplan to CREATE STATISTICS is a good plan
- PostgreSQL Replication Slots
YouTube Video
