Over 5X Faster Postgres? | Scaling Postgres 345 скачать в хорошем качестве

Over 5X Faster Postgres? | Scaling Postgres 345

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episo... In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Scaling Postgres 345 Timestamps: 00:00 - Intro 01:10 - OrioleDB beta7: Benchmarks 05:36 - OrioleDB Public Alpha 06:18 - Performance archaeology: OLAP 08:19 - SQL best practices – don’t compare count(*) with 0 09:42 - pg_stat_statements track_planning 11:29 - Unique Constraint Violations During Inserts Cause Bloat in PostgreSQL 12:30 - What I Wish Someone Told Me About Postgres 13:50 - Cloud Neutral Postgres Databases with Kubernetes and CloudNativePG 15:11 - Amazon Aurora DSQL 15:45 - Unsupported PostgreSQL features in Aurora DSQL 16:11 - [YouTube] PostGIS Day 2024 16:24 - PostGIS Day 2024 Summary 16:36 - Outro #postgres #postgresql