PostgreSQL

Follow PostgreSQL development. The world's most advanced open source database.

Episodes

PostgreSQL: Memory Safety and Query Optimization Fixes 2026-06-03T13:03:42Z
PostgreSQL's latest commits focus on fixing memory leaks and query planner edge cases, with particular attention to aggregation handling and pipeline error management that could affect application stability.
PostgreSQL: Beta Release Milestone 2026-06-02T13:03:39Z
PostgreSQL has reached the beta 1 milestone for version 19, marking a significant step toward the next major release. The stamping commit updates build configuration to reflect the new beta status.
PostgreSQL: Release 19 Documentation Push 2026-06-01T13:00:58Z
PostgreSQL's development team focused heavily on polishing Release 19 documentation, with multiple commits adding markup and cross-references to release notes. Translation updates also landed covering six languages.
PostgreSQL: Weekly Recap - Data Integrity & Infrastructure Hardening 2026-06-01T09:08:21Z
This week's 30 commits focused heavily on data checksums reliability and infrastructure compatibility, with significant fixes for standby promotion scenarios and encoding handling in the new JSON copy format.
PostgreSQL: Partition Split Validation Rollback 2026-05-21T10:01:10Z
Alexander Korotkov reverted a partition splitting validation feature after buildfarm failures. The original commit attempted to prevent degenerate SPLIT PARTITION operations with DEFAULT partitions.
PostgreSQL: Weekly Recap - Security Fixes and Performance Diagnostics 2026-05-17T10:00:54Z
PostgreSQL development this week focused on critical security fixes for logical replication and temporary table access, alongside enhanced TSC timing diagnostics and several bug fixes across core functionality.
PostgreSQL: The Art of User-Friendly Maintenance 2026-05-06T10:00:59Z
Today's PostgreSQL activity focused on three thoughtful maintenance improvements that show how much the team cares about user experience. The highlights include better documentation for deprecated options, fixing a long-standing issue…
PostgreSQL: Weekly Recap - Error Handling and Query Correctness 2026-05-04T00:00:00Z
PostgreSQL developers focused on fixing critical bugs and improving error handling this week, with 30 commits addressing ECPG crashes, JSON array handling, and query optimization issues. Key fixes include preventing segmentation faults…
PostgreSQL: Build Directory Path Fix 2026-04-26T00:00:00Z
Noah Misch committed a fix for a test failure that occurred when PostgreSQL build directories contained comma characters in their paths. The fix adds proper quoting to pg_hosts.conf fields to handle comma characters correctly.
PostgreSQL: String Formatting Fix 2026-04-25T00:00:00Z
A single commit by Peter Eisentraut fixes internationalization formatting in the pg_test_timing utility by replacing INT64_FORMAT with PRId64 in translatable strings.
PostgreSQL: Weekly Recap - Bug Fixes and Security Infrastructure 2026-04-13T00:00:00Z
PostgreSQL developers focused on critical bug fixes this week, addressing issues with foreign key constraints, logical decoding, and statistics handling. A significant fuzzing infrastructure was briefly added then reverted due to an…
PostgreSQL: Database Statistics and Array Coercion Fixes 2026-04-11T00:00:00Z
Two commits address critical bugs in PostgreSQL's statistics system and query planning. The fixes resolve incorrect database OID handling in statistics reporting and prevent crashes during array type coercion in set operations.
PostgreSQL: Weekly Recap - Shared Memory Architecture Overhaul 2026-04-06T00:00:00Z
PostgreSQL underwent a major infrastructure modernization this week with 30 commits completely rewriting the shared memory allocation system. The changes introduce a new subsystem registry and convert all built-in components to use…
PostgreSQL: Performance Revolution - ARM Acceleration and Smart Index Scanning 2026-04-05T10:02:11Z
Today's PostgreSQL development focused heavily on performance optimization with ARM CRC32C acceleration, AVX2-powered page checksums, and smarter index scanning strategies. Notable contributors include John Naylor's ARM crypto extensions…
PostgreSQL: The Great Memory Makeover 2026-04-04T10:00:37Z
PostgreSQL had an impressive day with 16 commits focused on major architectural improvements. The biggest story is a complete overhaul of how shared memory hash tables work, led by Heikki Linnakangas, making memory allocation more…
PostgreSQL: Speed Demons and Smart Optimizations 2026-04-03T10:00:36Z
Today we're diving into some incredible performance wins in PostgreSQL! Amit Langote delivered a massive 2.9x speedup for foreign key checks through clever batching optimizations, while the team also enhanced JSON path operations and…
PostgreSQL: Temporal Queries and Performance Wins 2026-04-02T10:00:41Z
PostgreSQL made major strides with the introduction of UPDATE/DELETE FOR PORTION OF commands for temporal data handling, alongside significant improvements to async I/O performance monitoring and tuple handling optimizations. The team…
PostgreSQL: Spring Cleaning & Auth Polish 2026-04-01T10:00:34Z
The PostgreSQL team delivered 21 focused commits on April 1st, 2026, with major improvements to authentication systems including OAuth bearer token handling and SASL exchange management. Notable work included C23 standard adoption,…
PostgreSQL: Performance Boosts and Thread-Safe Foundations 2026-03-31T10:00:40Z
Today's PostgreSQL update features a massive foreign key performance optimization that delivers 1.8x speedup for bulk inserts, plus important groundwork for future multi-threading capabilities. The team also refined OAuth authentication,…
PostgreSQL: Polish and Consistency Edition 2026-03-30T10:00:47Z
The PostgreSQL team delivered 16 commits focused on consistency and reliability improvements. Major highlights include Peter Smith's work on making psql output formatting more consistent, multiple contributors enhancing error safety in…
PostgreSQL: Building a More Resilient JSON Future 2026-03-29T10:00:57Z
Today we're diving into a small but significant change that's laying the groundwork for something much bigger. Jian He's contribution, merged by Peter Eisentraut, makes JSON cast functions error-safe - a crucial stepping stone toward…
PostgreSQL: Buffer Management Revolution - Async I/O Gets Smarter 2026-03-28T10:04:52Z
Today's PostgreSQL development focuses heavily on making database I/O operations more efficient and concurrent. The team delivered major improvements to buffer management with smarter async I/O handling, a new table prioritization system…
PostgreSQL: Query Planning Gets Smarter 2026-03-27T10:04:30Z
Today we're diving into some fascinating improvements to PostgreSQL's query planner, with Robert Haas leading the charge on making pg_plan_advice more robust and intelligent. We also see quality-of-life improvements for developers…
PostgreSQL: Base32hex Encoding and Code Quality Cleanup 2026-03-26T10:03:21Z
Today we're diving into PostgreSQL's latest additions with a shiny new base32hex encoding feature that's perfect for UUID handling, plus a solid day of code cleanup and bug fixes. The team tackled everything from file descriptor leaks to…
PostgreSQL: The Great WAL Record Cleanup 2026-03-25T10:07:19Z
Today we're diving into a major cleanup effort in PostgreSQL's write-ahead logging system, led by Melanie Plageman's impressive work to remove the XLOG_HEAP2_VISIBLE record type entirely. We also see important improvements to…
PostgreSQL: Lock Statistics Revolution 2026-03-24T10:02:03Z
PostgreSQL just got a massive upgrade to its monitoring capabilities with the introduction of comprehensive lock statistics tracking. Michael Paquier and Bertrand Drouvot delivered a game-changing feature that gives developers…
PostgreSQL: Performance and Quality Improvements 2026-03-23T10:02:10Z
Today we're diving into 14 commits focused on performance optimization and code quality improvements. The highlights include Melanie Plageman's visibility map corruption detection enhancements, Peter Geoghegan's preparation work for…
PostgreSQL: Testing the Hidden Heroes 2026-03-22T10:06:33Z
Today we dive into a single but meaningful commit that adds crucial test coverage for PostgreSQL's hash index vacuum functionality. Michael Paquier committed work by Alexander Kuzmenkov that tests a previously uncovered code path in hash…
PostgreSQL: Performance Optimizations and Better Backup Tools 2026-03-21T10:04:14Z
Today's PostgreSQL development brings significant performance improvements with Tom Lane's PL/pgSQL SELECT optimization that speeds up common database operations, plus major enhancements to backup tooling. The team also improved…
PostgreSQL: Performance Breakthroughs and Developer Experience Wins 2026-03-20T10:02:06Z
Today's PostgreSQL development brought some fantastic performance improvements and developer-friendly features. We've got a major hash join optimization that could save you from those nightmare scenarios with thousands of batches, plus…
PostgreSQL: Security Gets Smarter with SNI Support 2026-03-19T10:02:22Z
Today's PostgreSQL brought us some exciting security enhancements, led by Daniel Gustafsson's major serverside SNI support implementation that enables hostname-specific SSL certificates. We also saw Michael Paquier add comprehensive…
PostgreSQL: SQL Property Graphs Land with a Bang 2026-03-16T00:00:00Z
A massive day for PostgreSQL with the landing of SQL Property Graph Queries (SQL/PGQ) - a complete implementation of the ISO/IEC 9075-16:2023 standard. Along with this major feature, the team delivered 14 other commits including header…
PostgreSQL: Foundation Fixes and Platform Polish 2026-03-15T10:01:32Z
Today's PostgreSQL updates focus on infrastructure improvements and cross-platform reliability. Tomas Vondra tightened up parallel worker safety with better assertions, Tom Lane modernized Solaris semaphore handling and fixed a bootstrap…
PostgreSQL: Performance Revolution - SIMD Powers and Index Optimizations 2026-03-14T10:03:08Z
Today we're diving into some serious performance improvements in PostgreSQL! The team shipped SIMD optimizations for COPY operations that can dramatically speed up data imports, plus major index improvements with fake LSNs and streaming…
PostgreSQL: Performance Week - Smart Domains & Lightning-Fast Indexes 2026-03-13T10:02:10Z
This week brought major performance wins to PostgreSQL with 10 commits focusing on speed optimizations. Key highlights include enabling fast defaults for domain constraints (avoiding costly table rewrites), nbtree index optimizations…
PostgreSQL: Query Optimizer Gets Smarter with NOT IN Magic 2026-03-12T10:04:39Z
Today's PostgreSQL update brings a major query optimization breakthrough with Richard Guo's work converting NOT IN subqueries to anti-joins when safe, plus important improvements to CHECK constraint management and buffer handling. We…
PostgreSQL: The REPACK Revolution 2026-03-11T10:06:19Z
Today we're diving into a massive day for PostgreSQL with 14 commits that include a game-changing new REPACK command that unifies VACUUM FULL and CLUSTER functionality. We'll also explore performance improvements for standby servers,…
PostgreSQL: Optimizing the Engine from the Inside Out 2026-03-10T10:02:23Z
Today we're diving into six commits that show PostgreSQL's continuous refinement, featuring Robert Haas leading the charge with three significant optimizer improvements. We also see important fixes for incremental backups, error handling…
PostgreSQL: When Booleans Go Wrong 2026-03-08T10:02:30Z
Today we're diving into a subtle but important bug fix in PostgreSQL's pg_dump utility where a boolean array was being tested incorrectly. Álvaro Herrera tackled this tricky issue that affected binary-upgrade dumps of inherited table…
PostgreSQL: Major Auth Upgrade and Subscription Revolution 2026-03-07T11:05:22Z
A big day for PostgreSQL with 6 substantial commits focusing on authentication improvements and database connectivity. Jacob Champion delivered a major OAuth authentication upgrade with backward-compatible versioning, while Jeff Davis…
PostgreSQL: Monitoring Gets a Major Upgrade 2026-03-06T11:03:13Z
Today we're diving into 23 commits that bring some fantastic improvements to PostgreSQL, with the star being a brand new system view for monitoring database recovery. We've got authentication enhancements, better error handling, and some…
PostgreSQL: The LZ4 Compression Dance 2026-03-05T11:03:40Z
Today we're diving into PostgreSQL's journey with LZ4 compression as the new default for TOAST data - including a fascinating revert and retry story. We'll also explore improvements to pg_restore, hash join optimizations, and several…
PostgreSQL: Publishing Power-Up and Performance Gains 2026-03-04T11:17:48Z
A substantial day for PostgreSQL with major improvements to logical replication through the new EXCEPT TABLE functionality in publications, plus a significant performance boost by switching the default TOAST compression from pglz to LZ4.…
PostgreSQL: Fixing the Little Things That Matter 2026-02-22T11:11:18Z
Today we're diving into two thoughtful commits that show how PostgreSQL keeps getting more robust and user-friendly. Álvaro Herrera tackled a tricky constraint naming collision bug, while Michael Paquier improved documentation for…
PostgreSQL: Code Clarity and Speed Wins 2026-02-21T11:06:53Z
Today we're diving into two solid improvements to PostgreSQL's codebase that show the community's commitment to both code quality and performance. Heikki Linnakangas cleaned up some confusing data structures in the process management…
PostgreSQL: Switch Case Safety and Background Worker Improvements 2026-02-19T11:11:28Z
Today we're diving into 6 commits that focus on code safety and reliability improvements in PostgreSQL. The highlight is a major modernization effort replacing fallthrough comments with proper attributes across 66+ files, plus important…
PostgreSQL: The ABI Evolution and System Cleanup 2026-02-18T11:11:46Z
Seven commits focused on improving PostgreSQL's internal architecture, led by a major switch to typedef enums for better ABI checking. Notable work from Michael Paquier, Álvaro Herrera, and Heikki Linnakangas tackled everything from…
PostgreSQL: Cleanup Chronicles - Small Fixes, Big Impact 2026-02-16T11:07:42Z
Today we're diving into three thoughtful cleanup commits that showcase the ongoing polish work in PostgreSQL. Peter Eisentraut and Bertrand Drouvot wrapped up some static assertion consistency work, Fujii Masao fixed a tricky recovery…
PostgreSQL: Fixing the Substring Bug That Bit Back 2026-02-15T11:06:51Z
Noah Misch delivered two important commits fixing a tricky bug in PostgreSQL's SUBSTRING() function that was causing errors with multibyte characters in toasted data. The fix improves how PostgreSQL handles character encoding validation…
PostgreSQL: Sorting Gets a Speed Boost 2026-02-14T11:07:31Z
Today we're diving into a fantastic performance improvement in PostgreSQL's sorting engine with John Naylor's implementation of radix sort for tuple sorting, plus a helpful documentation update that closes a long-standing TODO. It's all…
PostgreSQL: Spring Cleaning and Performance Polish 2026-02-13T11:07:46Z
A productive day in PostgreSQL with 9 commits focused on code cleanup and optimization. Nathan Bossart led a significant simplification of popcount implementations, while Michael Paquier and team improved memory allocation patterns in…
PostgreSQL: Security Shield Activated 2026-02-09T11:10:49Z
The PostgreSQL team delivered a major security update with fixes for three CVEs addressing buffer overflow vulnerabilities. Thomas Munro, Michael Paquier, and Heikki Linnakangas led comprehensive changes to multibyte character handling,…
PostgreSQL: Protocol Evolution and Ecosystem Stress Testing 2026-02-07T11:11:16Z
PostgreSQL contributors made important infrastructure moves this week, with Jacob Champion and team introducing protocol "grease" testing to stress-test the ecosystem during beta. The team also focused on code quality with alignment…
PostgreSQL: File System Flexibility and Polish Day 2026-02-06T11:13:58Z
Today's PostgreSQL commits focused on giving developers more control and cleaning up rough edges. Thomas Munro added a new configuration option to handle file system compatibility issues, while Michael Paquier and Fujii Masao polished…
PostgreSQL: Upgrades Get Smarter 2026-02-05T11:12:13Z
Today we're diving into five commits that showcase PostgreSQL's continuous refinement, led by a major performance optimization for logical replication slot migration in pg_upgrade. We'll also explore backend process improvements,…
PostgreSQL: Polish, Performance, and Developer Experience Wins 2026-02-03T11:10:21Z
Today's episode covers 10 commits focused on code quality and developer experience improvements. Highlights include Tom Lane's performance optimization work on tuple alignment that speeds up array operations by 10%, better synchronous…
PostgreSQL: Cleaning House and Building Better Foundations 2026-01-31T11:09:02Z
Today we're diving into PostgreSQL's latest housekeeping efforts with four thoughtful commits focused on code organization and test reliability. Heikki Linnakangas led a major shared memory allocator refactor for better modularity, while…
PostgreSQL: Polish Week - Eight Quality Commits Clean Up the Codebase 2026-01-30T11:11:40Z
Today we're diving into eight focused commits that showcase the PostgreSQL team's dedication to code quality and performance. From replacing magic numbers with proper constants to fixing memory leaks and optimizing table scans, these…
PostgreSQL: Statistics Revolution and Code Cleanup 2026-01-29T11:13:57Z
Today's PostgreSQL episode dives into a major advancement in extended statistics with new MCV (most-common values) support in pg_restore_extended_stats(), plus important replication origin refactoring and query planner enhancements. We…
PostgreSQL: Backup & Performance Polish Party 2026-01-27T11:08:40Z
Today brings 14 solid commits focused on making PostgreSQL more robust and user-friendly. The highlight is major improvements to pg_dump's statistics handling, plus important fixes for replication slot races and vacuum logic…
Statistics Revolution and Performance Polish 2026-01-26T11:09:27Z
Today brings major enhancements to PostgreSQL's statistics system with new extended stats restoration functions, plus some solid performance optimizations and code cleanup. Michael Paquier and team deliver powerful new tools for database…
Database Reliability Deep Dive 2026-01-25T11:05:43Z
Today we're diving into some serious database engineering with three focused commits that show PostgreSQL's commitment to stability. Dean Rasheed tackled a tricky MERGE operation bug involving trigger transition tables, Michael Paquier…
Protocol Prep and Memory Math Fixes 2026-01-24T11:11:39Z
Today we're diving into some fascinating infrastructure work on PostgreSQL! Jacob Champion is laying groundwork for future protocol improvements by reserving version 3.1 and updating pipeline tests, while Nathan Bossart tackled some…
Error Messages, Testing Love, and C++ Bridges 2026-01-21T11:16:06Z
Today we're diving into 9 commits that show PostgreSQL's commitment to user experience and developer tooling. The highlights include major improvements to logical replication error messages led by Hayato Kuroda, and Peter Eisentraut's…
Bug Hunting Season in PostgreSQL 2026-01-20T11:09:31Z
Today's PostgreSQL adventure takes us deep into bug-fixing territory with 5 solid commits tackling everything from query normalization crashes to backup restoration failures. The team is cleaning house with fixes from Michael Paquier,…
Query Safety First - PostgreSQL's Latest Security and Stability Fixes 2026-01-19T11:10:41Z
Today we're diving into two important maintenance commits that show PostgreSQL's commitment to reliability. Richard Guo delivered a critical fix for unsafe query optimization that could cause unpredictable results, while Tom Lane kept us…
Polish and Precision Day 2026-01-18T11:21:56Z
Today we're diving into the art of code refinement with PostgreSQL's latest commits from Michael Paquier. We've got two focused improvements that showcase how attention to detail makes all the difference - fixing a confusing error…
Test Fixes and Build Improvements Day 2026-01-17T11:23:03Z
Today we're covering four focused commits to PostgreSQL that show the ongoing care for code quality. Highlights include Heikki Linnakangas fixing a tricky test timing issue and a crash in test utilities, Peter Eisentraut improving…
The Restrict Revert and Replication Safety 2026-01-14T16:05:22Z
Today we dive into a fascinating technical reversal where PostgreSQL had to backtrack on a seemingly simple change due to C++ compatibility issues. We also explore crucial improvements to replication origin safety and several…