--- title: "Postgres 19 Beta 1 is here" publication: "Postgres Weekly" issue: 652 published_at: "2026-06-10" canonical_url: "https://postgresweekly.com/issues/652" --- Plus Supabase valued at $10bn, graph-query inside baseball, and the history of ORDER BY. #โ€‹652 โ€” June 10, 2026 [Web Version](https://postgresweekly.com/issues/652) Together with [![Microsoft\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://posetteconf.com/2026/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/krjjheur4jzublurtcvw.jpg)](https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/) [PostgreSQL 19 Beta 1 Released](https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/) โ€” One of the more exciting major releases of Postgres is a step closer with graph queries, faster inserts, [pg_plan_advice](https://www.postgresql.org/docs/19/pgplanadvice.html), parallel-worker autovacuuming, [online toggling of data checksums](https://www.postgresql.org/docs/19/checksums.html#CHECKSUMS-ONLINE-ENABLE-DISABLE), and more, all ready to try now. Final release will be around late September/early October. PostgreSQL Global Development Group ๐Ÿ’ก Ready to give Postgres 19 a spin? Here's [how to get it running in Docker](https://andyatkinson.com/postgresql-beta-testing-docker) or [on a Kubernetes cluster](https://cloudnative-pg.io/blog/postgresql-19-beta1/). [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/1c6a7113.png)](https://posetteconf.com/2026/) [Come for Great PostgreSQL Talks, and Yes, Thereโ€™s Swag](https://posetteconf.com/2026/) โ€” POSETTE: An Event for Postgres is around the corner (16-18 Jun). Pick & attend your must-sees. Join the Hallway Track on Discord for limited, exclusive event swag for attendees to the live event from anywhere in your slippers. Last call: [Register now](https://posetteconf.com/2026/). Microsoft | AMD sponsor **IN BRIEF:** - ๐Ÿ“˜ The [official Postgres 19 documentation](https://www.postgresql.org/docs/19/) is now taking shape, such as [this page on property graphs](https://www.postgresql.org/docs/19/ddl-property-graphs.html) and [the draft release notes](https://www.postgresql.org/docs/19/release-19.html). - ๐Ÿ’ฐ [Supabase has raised a $500m Series F round](https://supabase.com/blog/supabase-series-f) at a valuation of $10bn. - Spectral Core has [unveiled SQL Tran](https://www.spectralcore.com/blog/why-we-built-sql-tran-oracle-to-postgresql-migration), a (commercial) tool for automating Oracle to Postgres migrations. โšพ [Comparing the Graph Capabilities of Postgres, DuckDB, and LadybugDB](https://theconsensus.dev/p/2026/05/29/ladybug-duckdb-and-postgresql.html) โ€” A baseball-oriented comparison of how three databases fare (both in terms of developer experience and raw performance) with making graph-style queries across millions of rows of player, venue, and game data. John Nevin [`EXPLAIN` Prettier (or Post-Processing Query Plans)](https://www.pgedge.com/blog/explain-prettier-or-post-processing-query-plans-in-postgres) โ€” `EXPLAIN` output can be tricky to read at the best of times and it can also change subtly between machines and versions. Andrei shows off [explain_prettier](https://github.com/danolivo/conf/blob/main/2026b-explain-prettier/explain-prettier.sql), which makes `EXPLAIN` output cleaner and simpler by stripping away unnecessary info. Andrei Lepikhov ๐Ÿ“„ [The Postgres Developer's Guide to Vector Index Tradeoffs](https://www.tigerdata.com/blog/the-postgres-developers-guide-to-vector-index-tradeoffs) โ€“ Find out what HNSW, IVFFlat, DiskANN, and SPFresh indexes are and when to pick each of them. Hien Phan (Tiger Data) ๐Ÿ“„ [SQLโ€™s `ORDER BY` Has Come a Long Way](https://modern-sql.com/blog/2026-05/order-by-history) โ€“ A feature tour from the 80s through to the ISO-specified SQL:2023 present. Markus Winand ๐Ÿ“„ [Does pgBackRest Work with `pg_tde`?](https://pgstef.github.io/2026/06/04/pgbackrest_and_pg_tde.html) โ€“ Can pgBackRest handle encrypted WAL segments transparently? Mostly, yes! Stefan Fercot ๐Ÿ“„ [File Descriptors: The OS Limit That Takes Down Postgres](https://stormatics.tech/blogs/file-descriptors-the-os-limit-that-takes-down-postgresql) Warda Bibi ๐Ÿ“ฐ Classifieds ๐Ÿงฎ [Build a full RAG stack inside Postgres](https://www.pgedge.com/download/ai-toolkit). Docloader, Vectorizer, RAG, & MCP. [100% open source](https://www.pgedge.com/download/ai-toolkit). --- ๐Ÿ˜ AI wrote the migration. Who reviews it? Open-source multi-agent PR review - a custom review lens per PR, cents per run. [Star & deploy โ†’](https://agentfield.ai/github/pr-af/?utm_source=postgres&utm_medium=newsletter&utm_campaign=postgres-260610&utm_id=postgres-260610-pr-af&utm_content=pr-af) **RELEASES AND CODE:** [Absurd: A Postgres-Native Durable Workflow System](https://earendil-works.github.io/absurd/) โ€” Described as _โ€œthe simplest durable execution workflow system you can think ofโ€_, Absurd is [an SQL file](https://github.com/earendil-works/absurd/blob/main/sql/absurd.sql) that implements a multi-step task/queue/worker system on regular Postgres. There are [SDKs](https://earendil-works.github.io/absurd/sdks/) to make it easy to use from TypeScript, Python, and Go. Armin Ronacher (Earendil) [Multigres v0.1 Alpha: An 'Operating System' for Postgres](https://supabase.com/blog/multigres-v0-1-alpha) โ€” A year ago, [Supabase announced](https://supabase.com/blog/multigres-vitess-for-postgres) it was hiring the co-creator of Vitess to work on a Vitess-like horizontally-scaling database clustering system but for Postgres. This alpha is an early public look at what theyโ€™re building. Sugu Sougoumarane - [TimescaleDB 2.27](https://www.tigerdata.com/blog/timescaledb-2-27) โ€“ Tiger Data's time series extension continues its focus on performance with more efficient operations on compressed data in particular. - [pg_clickhouse 0.3](https://justatheory.com/2026/06/pg_clickhouse-0.3.1/) โ€“ FDW for querying ClickHouse databases from Postgres. The underlying C++ library gets switched out for a faster, more robust C alternative. - [pg_background 2.0](https://vibhorkumar.wordpress.com/2026/06/08/pg_background-2-0-run-sql-in-the-background-now-cleaner-safer-and-ready-for-postgresql-19/) โ€“ Run SQL in background workers. Now works with Postgres 19. - [Kanel 4.0](https://github.com/kristiandupont/kanel) โ€“ Generate TypeScript types from a live Postgres database. - [pgrls](https://github.com/pgrls/pgrls) โ€“ Static analyzer for RLS (Row-Level Security) to catch common policy bugs. - [NeonD](https://github.com/matisiekpl/neond/) โ€“ Open-source Neon-based control plane daemon for Postgres that runs as a single Docker container. - [pgcheck](https://github.com/xiongcccc/pgcheck) โ€“ A lightweight Postgres health-check CLI written in Go. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).