--- title: "How Notion took Postgres to the data lake" publication: "Postgres Weekly" issue: 561 published_at: "2024-07-03" canonical_url: "https://postgresweekly.com/issues/561" --- Plus Postgres 17 beta 2, Tembo's fund raising, and a big Psycopg release. | #​561 — July 3, 2024 [Web Version](https://postgresweekly.com/issues/561) Together with [![Percona logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_600,h_120/e_make_transparent/co_white,e_outline:7/iplxngwgax1ktho5k45h.png)](https://hubs.ly/Q02DBDHT0) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xhtzylhdtbjhlgly9xga.jpg)](https://www.postgresql.org/about/news/postgresql-17-beta-2-released-2885/) [PostgreSQL 17 Beta 2 Released](https://www.postgresql.org/about/news/postgresql-17-beta-2-released-2885/) — A month on from [beta 1](https://www.postgresql.org/about/news/postgresql-17-beta-1-released-2865/) comes the next step in the long journey to the final release of Postgres 17, expected this September or October. [The draft release notes](https://www.postgresql.org/docs/17/release-17.html) remain the best way to update yourself on what’s new. PostgreSQL Global Development Group [Building and Scaling Notion’s Data Lake](https://www.notion.so/blog/building-and-scaling-notions-data-lake) — [_Notion_](https://www.notion.so/help/guides/what-is-notion) is a popular Web-based note taking and wiki app and, therefore, has a lot of data under its control. Starting from a purely Postgres-based approach (which they [wrote about scaling here](https://www.notion.so/blog/sharding-postgres-at-notion)), they’ve grown significantly and had to integrate with numerous other technologies in order to adopt a data lake approach. Tie, Louie, Chow, et al. (Notion) [![\](https://copm.s3.amazonaws.com/130836b1.png)](https://hubs.ly/Q02DBDHT0) [Optimize PostgreSQL: Essential Tuning Strategies](https://hubs.ly/Q02DBDHT0) — Discover proven PostgreSQL performance tuning strategies from Percona’s expert Support Engineers. Free eBook includes real-world examples and advice on query optimization, indexing, partitioning, schema design, and more. [Get your copy now](https://hubs.ly/Q02DBDHT0). Percona sponsor [Looking at the New Built-in Collation Provider in Postgres 17](https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html) — There’s a built-in UTF-8 locale and collation provider with binary string comparisons in the Postgres 17 beta. Here’s why it’s interesting, how to use it and how it performs. Daniel Vérité [PGExtensions: A Comparison of Extension Support Across Clouds](https://www.pgextensions.org/) — Getting extensions running on your own Postgres server is one thing, but when it comes to using hosted Postgres services or cloud providers, you’re often restricted to what the provider has made available. DataCloudGaze Consulting **QUICK BITS:** - 🇬🇷 [Registration for PGConf.EU 2024](https://2024.pgconf.eu/registration/) has opened. It takes place in Greece this October, and if I'm not mistaken, only _three_ earlybird tickets remain at the time of publication. - Postgres platform [Tembo.io](https://tembo.io/) has announced [it's raised $14m in funding](https://www.businesswire.com/news/home/20240703585965/en/Tembo-Secures-14M-Funding-to-Fuel-Postgres-Ecosystem-Growth). - [EDB's Dilip Kumar](https://postgresql.life/post/dilip_kumar/) is this week's _PostgreSQL Person of the Week._ 📄 [Supporting Postgres Named Prepared Statements in Hyperdrive](https://blog.cloudflare.com/postgres-named-prepared-statements-supported-hyperdrive) – Hyperdrive is Cloudflare’s globally distributed SQL connection pooler and cache. Andrew Repp (Cloudflare) 📄 [Ensuring Safe Data Modifications with `SELECT FOR UPDATE`](https://stormatics.tech/blogs/ensuring-safe-data-modifications-in-postgresql-with-select-for-update) Semab Tariq 📄 [Using Transaction Chaining to Reduce Server Round-Trips](https://bugfactory.io/articles/using-transaction-chaining-to-reduce-server-round-trips/) Christoph Schiessl 📄 [Kubernetes Just Turned Ten: Where Does Postgres Stand?](https://www.gabrielebartolini.it/articles/2024/06/kubernetes-just-turned-ten-where-does-postgresql-stand/) Gabriele Bartolini 📄 [Using Short Lived Postgres Servers for Testing](https://kaveland.no/posts/2024-05-27-shortlived-postgres-servers/) Robin Kåveland 📄 [ORMs in Production Postgres: Friend or Foe?](https://www.timescale.com/blog/orms-in-production-postgresql-friend-or-foe/) Timescale 🛠 Code and Tools [Psycopg 3.2 Released](https://www.psycopg.org/articles/2024/06/30/psycopg-32-released/) — Psycopg is the most popular Postgres adapter for Python. _(As an aside, we interviewed Psycopg’s creator in [issue 390](https://postgresweekly.com/issues/390) – three years ago! – when he had begun work on Psycopg 3.)_ Daniele Varrazzo [pg_dirtyread: Read Dead But Unvacuumed Tuples from a Relation](https://github.com/df7cb/pg_dirtyread) — So if a row has been deleted, say, you could potentially still read it. Christoph Berg [pg_back 2.4: A Simple, Thorough Backup Tool for Postgres](https://github.com/orgrim/pg_back) — A Go-powered tool for dumping your databases to files, including roles, server parameters, and more, in the format of your choice. Nicolas Thauvin - [pgAdmin4 8.9](https://www.pgadmin.org/docs/pgadmin4/8.9/release_notes_8_9.html) – Popular admin dashboard for Postgres. - [Hasql 1.8](https://github.com/nikita-volkov/hasql) – Efficient Postgres driver for Haskell with a typesafe mapping API. - [postgres-meta 0.83.1](https://github.com/supabase/postgres-meta) – A RESTful API for managing Postgres. - [FerretDB 1.22](https://github.com/FerretDB/FerretDB) – MongoDB-a-like but atop Postgres. **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|*).