--- title: "How about 1 trillion rows in Postgres?" publication: "Postgres Weekly" issue: 592 published_at: "2025-03-13" canonical_url: "https://postgresweekly.com/issues/592" --- Plus what Microsoft's Postgres team has been getting up to. | #​592 — March 13, 2025 [Web Version](https://postgresweekly.com/issues/592) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AnO-IBOoGpiy8827r34yQfnzbSE5ByFa_77iwPDOSrR_ZVju9YeShiZyIaF5Yg3DW92Cr74svvvHB1Bv0KQ9Ayll7w) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ba1jmrccnqs6j7qcmuxk.jpg)](https://www.cybertec-postgresql.com/en/postgresql-1-trillion-rows-in-citus/) [1 Trillion Rows in Citus?](https://www.cybertec-postgresql.com/en/postgresql-1-trillion-rows-in-citus/) — _“Postgres scales,”_ but just how far does that go? Hans-Jürgen decided to find out, running a little (or is it big?) experiment to see if a 1 trillion row table is even achievable. Hans-Jürgen Schönig ❌ [Ways to Cancel Queries in Postgres](https://pert5432.com/post/postgres-query-cancellation) — If you’ve got a query or two hogging Postgres’s resources, terminating them is an option, and there are several ways to go about it. Petr Kada [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/c6148858.png)](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AnO-IBOoGpiy8827r34yQfnzbSE5ByFa_77iwPDOSrR_ZVju9YeShiZyIaF5Yg3DW92Cr74svvvHB1Bv0KQ9Ayll7w) [▶ Don’t Let Postgres Maintenance Slip Through the Cracks](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AnO-IBOoGpiy8827r34yQfnzbSE5ByFa_77iwPDOSrR_ZVju9YeShiZyIaF5Yg3DW92Cr74svvvHB1Bv0KQ9Ayll7w) — Secure your spot to learn the proactive maintenance practices that uncover hidden database performance risks, like slow queries, checkpoint behavior, & connection issues, before they escalate. pganalyze sponsor **QUICK BITS:** - 🤔 Microsoft's Postgres team has [reflected on what they achieved in 2024.](https://techcommunity.microsoft.com/blog/adforpostgresql/microsoft-postgresql-oss-engine-team-reflecting-on-2024/4388700) If you've ever wondered who's in their team and what they do, this is a good introduction. - 🗣️ After a break of a few months, the _PostgreSQL Person of the Week_ interviews are back [with Doug Ortiz in the hot seat.](https://postgresql.life/post/doug_ortiz/) - 🎤 EDB's Jeremy Kellway went on the _Stack Overflow_ podcast to [explain how Postgres is a great fit for AI use cases.](https://stackoverflow.blog/2025/03/07/is-postgres-the-best-database-for-genai/) - ⛓️‍💥 The _Neon_ Postgres platform [has implemented an 'Outage Simulator'](https://neon.tech/blog/outage-simulator) to demo its 'instant restore' feature. - 🇨🇦 If you'd like to speak at _Postgres Extensions Day Montreal 2025_, [its call for speakers is open](https://sessionize.com/pgextday2025mtl) until April 1. [Postgres Gets a _Self-Join Elimination_ Optimization](https://github.com/postgres/postgres/commit/fc069a3a6319b5bf40d2f0f1efceae1c9b7a68a8) — Several years ago, [someone suggested a join optimization](https://www.postgresql.org/message-id/flat/64486b0b-0404-e39e-322d-0801154901f3%40postgrespro.ru) where redundant inner self-joins (often added by ORMs) can be removed under certain conditions. This so-called Self-Join Elimination (SJE) optimization has now been committed to Postgres and is explained in this GitHub commit. Postgres Repo 📄 [Waiting for Postgres 18: Allow Parallel `CREATE INDEX` for GIN Indexes](https://www.depesz.com/2025/03/11/waiting-for-postgresql-18-allow-parallel-create-index-for-gin-indexes/) Hubert depesz Lubaczewski 📄 [Waiting for Postgres 18: Allow `json{b}_strip_nulls` to Remove Null Array Elements](https://www.depesz.com/2025/03/13/waiting-for-postgresql-18-allow-jsonb_strip_nulls-to-remove-null-array-elements/) Hubert depesz Lubaczewski 📄 [When HASH Partitioning Works Better Than RANGE](https://stormatics.tech/blogs/when-hash-partitioning-works-better-than-range) Umair Shahid 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/lxbnd2wqyl7rdcsqp0sq.jpg)](https://www.softwareandbooz.com/introducing-pgnow/) [Introducing pgNow: A Point-in-Time Diagnostic Tool](https://www.softwareandbooz.com/introducing-pgnow/) — A free (but not open – it’s in preview behind an email wall) cross-platform desktop tool created by Redgate to highlight and analyze live data about queries, indexes, configuration settings, and other important elements of a Postgres cluster’s operation. Even if you don’t grab it, Ryan gives a thorough overview of what it offers here. Ryan Booz - [PGSync 4.0](https://github.com/toluaina/pgsync) – Middleware for syncing data from Postgres to Elasticsearch or OpenSearch. - 📊 [PEV2 v1.14](https://github.com/dalibo/pev2) – Vue component for visualization of Postgres execution plans. - [DoltgreSQL 0.18](https://github.com/dolthub/doltgresql) – Version controlled Postgres-a-like with Git-style functionality. - [pgenv 1.4](https://fluca1978.github.io/2025/03/10/pgenvConfigurationOverrides.html) – Postgres binary manager. **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|*).