--- title: "User, User, Who is the User?" publication: "Postgres Weekly" issue: 597 published_at: "2025-04-24" canonical_url: "https://postgresweekly.com/issues/597" --- Plus Supabase raises $200m in series D funding. | #​597 — April 24, 2025 [Web Version](https://postgresweekly.com/issues/597) 👋 We took last week off for Easter, but now we're back every week till early June. Let's go! __ _Peter Cooper, your editor_ Together with [![Aiven\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_336/e_make_transparent/co_white,e_outline:17/uzfqfoiqru4e6zm6ierx.png)](https://fnf.dev/42AlM2M) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/aw6mlanfbli8zg39j7rg.jpg)](https://www.crunchydata.com/blog/hacking-the-postgres-statistics-tables-for-faster-queries) [Hacking the Postgres Statistics Tables for Faster Queries](https://www.crunchydata.com/blog/hacking-the-postgres-statistics-tables-for-faster-queries) — Postgres’s internal statistics drive query planning and index choices, but the process isn’t perfect. This practical post shows how to manually add extended statistics to teach Postgres about useful correlations — and how even a single `CREATE STATISTICS` can make a query 97x faster. Louise Grandjonc Leinweber [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/d10078a2.png)](https://fnf.dev/42AlM2M) [Fully Managed Postgres with Aiven for PostgreSQL®](https://fnf.dev/42AlM2M) — Set up a fully managed Postgres database in 10 minutes and focus on your code – let Aiven do the heavy lifting. Aiven sponsor **IN BRIEF:** - Back in January, Supabase's CEO Paul Copplestone [tweeted](https://x.com/kiwicopple/status/1883441078843605055) about an investor making a 17 hour journey to visit him in the far flung regions of New Zealand. Turns out it wasn't for nothing as [Supabase has now raised a $200m Series D](https://fortune.com/2025/04/22/exclusive-supabase-raises-200-million-series-d-at-2-billion-valuation/) at a $2bn valuation. - ⭐ Bruce Momjian has released the slidedeck for his [_User, User, Who is the User?_ talk](https://momjian.us/main/writings/pgsql/user.pdf)[PDF] – it's a dense deck packed with practical examples of how users, roles, and permissions work in Postgres. - The latest release of _Crunchy Data Warehouse_ adds full support for [native logical replication from Postgres tables to Iceberg.](https://www.crunchydata.com/blog/logical-replication-from-postgres-to-iceberg) - YugabyteDB shows off its new [in-place, zero-downtime major version Postgres upgrade mechanism.](https://www.yugabyte.com/blog/postgresql-upgrade-framework/) [Scaling Certificate Transparency with 100B+ Rows of Data](https://blog.transparency.dev/merklemap-scaling-certificate-transparency-with-100b-rows-of-data) — [Merklemap](https://www.merklemap.com/) is a service that aggregates together [certificate transparency](https://en.wikipedia.org/wiki/Certificate_Transparency) data for issued TLS certificates – here’s how they use Postgres for task of managing data spanning 20TB of storage and 100 billion rows. Pierre Barre [Striping Postgres Data Volumes - A Free Lunch?](https://kmoppel.github.io/2025-04-24-is-striping-postgres-data-volumes-a-free-lunch/) — Depending on your usage patterns, yes, striping together cheap cloud volumes can yield significant throughput and latency benefits. Kaarel Moppel [Reordering Expressions in SQL Queries for Performance](https://danolivo.substack.com/p/on-expressions-reordering-in-postgres) — Techniques to speed up query execution, with a focus on rearranging conditions in filter expressions, JOINs, HAVING clauses, and similar constructs. Andrei Lepikhov 📄 [Fixing a Postgres `strchrnul` Compile Error on macOS 15.4](https://justatheory.com/2025/04/fix-postgres-strchrnul/) – An issue `pgenv` users, in particular, might be running into. David E. Wheeler 📄 [Converting JSON Documents to Relational Tables](https://www.postgresonline.com/journal/index.php?/archives/420-Converting-JSON-documents-to-relational-tables.html#jsontorelational) Leo Hsu and Regina Obe 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/subasehyoapln4o5xf4g.jpg)](https://www.dolthub.com/blog/2025-04-16-doltgres-goes-beta/) [Doltgres Beta Launch: A Version Controlled SQL Database](https://www.dolthub.com/blog/2025-04-16-doltgres-goes-beta/) — Doltgres is a Go-powered Postgres-flavored variant of the [Dolt](https://docs.dolthub.com/) SQL database that offers Git-style merging and forking in a Postgres-wire compatible form. Zach Musgrave (DoltHub) 💡 The Dolt folks also report [Django works with Doltgres](https://www.dolthub.com/blog/2025-04-24-doltgres-django/) out of the box. [A Postgres Language Server for Your IDE](https://supabase.com/blog/postgres-language-server) — Most modern code editors support _language servers_ for providing language-specific coding enhancements like auto-complete, syntax highlighting, and refactoring. Supabase has come up with such a server for Postgres too, offering linting, autocompletion, error highlighting and type-checking out of the box. Steinrötter and Domke (Supabase) - [PostgreSQL Anonymizer 2.1](https://www.postgresql.org/about/news/postgresql-anonymizer-21-blurring-images-3061/) – Extension that hides or replaces personally identifiable information, now with support for blurring images too. - [oid2bytea 1.0](https://github.com/HexaCluster/oid2bytea) – Tool to convert large objects columns to`bytea`. - [QuestDB 8.3](https://github.com/questdb/questdb) – Java-powered time-series database with Postgres wire protocol compatibility. - [VectorChord 0.3](https://github.com/tensorchord/VectorChord) – Scalable, fast, and disk-friendly vector search. - [BemiDB 0.51](https://github.com/BemiHQ/BemiDB) – Single binary Postgres read replica optimized for analytics. - [PeerDB 0.27.8](https://github.com/PeerDB-io/peerdb) – Stream data from Postgres to data warehouses, queues and storage engines. - [pgmoneta 0.16.0](https://pgmoneta.github.io/_posts/2025-04-22-pgmoneta-0.16.0.html) – Backup / restore solution. ([Docs.](https://pgmoneta.github.io/documentation.html)) - [Pigsty 3.4](https://github.com/pgsty/pigsty/releases/tag/v3.4.0) – 'Batteries-included' Postgres distribution. **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|*).