Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

Looking Ahead to Postgres 19

Snowflake is offering the PostgreSQL 19 Beta to allow developers to test new features before general availability. This early release includes over 270 commits and enhancements in areas like performance, observability, and SQL/JSON functionality.

Background

- PostgreSQL (often called "Postgres") is the world's most advanced open-source relational database, widely used by companies of all sizes. Major new versions are released roughly once per year, each bringing performance, security, and usability improvements. - This post is from Snowflake's engineering team. Snowflake is a competing cloud data platform (data warehousing / data lakehouse) that also builds and contributes to Postgres internally. Their interest in Postgres signals that even cloud-native competitors see Postgres as strategically important. - Postgres 19 is the next upcoming version (the current stable release is Postgres 18). As of the post, Postgres 19 is in a beta / development phase — meaning the features described are locked in but the final release hasn't shipped yet. - Some of the highlighted features include: faster query parallelism for `MERGE` (upsert) operations, improved partitioning for large tables, better incremental backup tools, and more robust logical replication. These are technical improvements that matter to engineers running Postgres at scale.

Related stories