Hacking On Postgres is Hard! | Scaling Postgres 315

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

YouTube Video

Podcast Audio