Hacking On Postgres is Hard! | Scaling Postgres 315
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic.
Content Discussed
- Hacking on PostgreSQL is Really Hard
- The Notifier Pattern for Applications That Use Postgres
- Histograms worked
- Saturation Arithmetic with a PostgreSQL Extension
- Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage
- LIMIT vs Performance
- What's new in pgvector v0.7.0
- (Bi)Temporal Tables, PostgreSQL and SQL Standard
- How not to change PostgreSQL column type
- cursor_tuple_fraction and the PostgreSQL JDBC driver
- Nazir Bilal Yavuz
- Understanding Postgres Database Schemas and the search_path
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
- Bringing IvorySQL to Neon Autoscaling Platform
- Mini Summit Five
- Ingesting 1M Inserts per Minute to Help Save Devs’ Resources
- April 2024 Recap: Azure PostgreSQL Flexible Server
- Syncing Postgres Partitions to Your Data Lake in Bridge for Analytics
- Using Automatic DDL Replication with pgEdge Distributed PostgresQL