Postgres 18: The Deep Cuts | Scaling Postgres 386

In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart.

Content Discussed

• Pipelining in psql (PostgreSQL 18)
• Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly
• Postgres 18
• Going down the rabbit hole of Postgres 18 features
• Cumulative Statistics in PostgreSQL 18
• What's New in PostgreSQL 18 - a Developer's Perspective
• PostgreSQL 18 and beyond: From AIO to Direct IO?
• Waiting for PostgreSQL 19 – Add GROUP BY ALL.
• How to do UPDATE ... LIMIT in PostgreSQL
• How I learned to use wal_inspect
• Run PostgreSQL 18 on Kubernetes Today with CloudNativePG
• Exploration: CNPG Point In Time Recovery
• From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 1 – Basics
• PostgreSQL 18 Old & New
• Losing Data is Harder Than I Expected
• PostgREST 13
• Elasticsearch, PostgreSQL, and the ACID Test
• PostgreSQL 18 Release Notes
• Query optimizations in Odoo versions 17–19 for faster PostgreSQL performance
• PgPedia Week, 2025-09-21
• PgPedia Week, 2025-09-28
• PGDay UK does not fail to deliver once again
• Identifying and resolving performance issues caused by TOAST OID contention in Amazon Aurora PostgreSQL Compatible Edition and Amazon RDS for PostgreSQL
• Introducing pganalyze Query Advisor: Proactive Query Plan Optimization for Postgres
• A PostgREST-Compatible Data API, Now on Neon
• Enterprise speed, enterprise standards with Bolt Cloud + Supabase

YouTube Video

Podcast Audio