--- title: "It's time to learn" publication: "Postgres Weekly" issue: 596 published_at: "2025-04-10" canonical_url: "https://postgresweekly.com/issues/596" --- Plus are you ready to let AI agents work with your database? | #​596 — April 10, 2025 [Web Version](https://postgresweekly.com/issues/596) 🥚 We're taking next week off due to the Easter break and will be back on Thursday, April 24. See you then! __ _Peter Cooper, your editor_ Together with [![Blacksmith\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_820,h_100/e_make_transparent/co_white,e_outline:7/uq9yvkqtinkixhiq19mf.png)](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=primary&utm_campaign=apr10&utm_term=postgres) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/quqznyttxi5khg6tyhgf.jpg)](https://boringsql.com/posts/know-the-time-in-postgresql/) 🕒 [Time to Better Know the Time in Postgres](https://boringsql.com/posts/know-the-time-in-postgresql/) — If you’ve ever been guilty of just crossing your fingers and hoping for the best when working with times in Postgres, this is for you. Packed with examples and advice, Radim looks at how different time data types work, how to work with time zones, intervals, time ranges, and more. Radim Marek [A Roadmap to Scaling Postgres](https://kmoppel.github.io/2025-04-10-postgres-scaling-roadmap/) — An experienced Postgres specialist presented an ordered list of steps to think through when scaling up a Postgres deployment from first getting your data model right, through to indexing, hardware, tuning, and sharding. Kaarel Moppel [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/f3459ef3.png)](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=primary&utm_campaign=apr10&utm_term=postgres) [2x-40x Faster Docker Builds with Blacksmith](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=primary&utm_campaign=apr10&utm_term=postgres) — With a one-line code change, Blacksmith can make your Docker builds incremental by mounting your Docker layer cache into your GitHub Actions runner. Blacksmith is used by 350+ companies like Ashby, Clerk, and Mintlify. Blacksmith sponsor 📈 [Making Postgres Better with OrioleDB](https://misachi.github.io/) — OrioleDB is an alternative storage engine for Postgres that extends the table access method framework to optimize performance on modern hardware. But by how much? Brian runs some tests. Brian Misachi **IN BRIEF:** - 🌐 In [_Geopolitical Postgres_](https://momjian.us/main/blogs/pgblog/2025.html#April_9_2025), Bruce Momjian reflects on how Postgres' openness allows it to be used in places, and industries, which might otherwise face restrictions. Openness for one means openness for all, along with all its pros and cons. - [Postgres consultant Frédéric Delacourt](https://postgresql.life/post/frederic_delacourt/) is the latest _PostgreSQL Person of the Week_ interviewee. - Electric has put their [Electric Cloud into public beta](https://electric-sql.com/blog/2025/04/07/electric-cloud-public-beta-release) – it's a managed version of their open source Postgres sync engine [which recently reached version 1.0.](https://electric-sql.com/blog/2025/03/17/electricsql-1.0-released) [Creating Histograms with Postgres](https://www.crunchydata.com/blog/histograms-with-postgres) — A [histogram](https://www.atlassian.com/data/charts/histogram-complete-guide) visualizes data distribution by grouping values into bins and displaying the frequency of each bin. Postgres has a `width_bucket` to help you do this, and Elizabeth shows off some fantastic queries here. Elizabeth Christensen 📄 [Waiting for Postgres 18: Docker Containers 34% Smaller](https://ardentperf.com/2025/04/07/waiting-for-postgres-18-docker-containers-34-smaller/) – _“The minimal (CloudNativePG) image for Postgres 18 is 262MB – that’s 34% smaller than the minimal CNPG image for Postgres 17 of 413MB.”_ Jeremy Schneider 📄 [A Case Where SQL Joins Struggle But MongoDB Documents Shine](https://dev.to/franckpachot/a-case-where-sql-joins-struggle-but-mongodb-documents-shine-11kj) – Franck works for MongoDB but is also a Postgres fan so it’s interesting to see him making a detailed comparison. There are some good comments too. Franck Pachot 📄 [Importing Wikipedia into Postgres with pgai](https://www.cybertec-postgresql.com/en/pgai-importing-wikipedia-into-postgresql/) – If you want to experiment with pgai’s vector embedding features, Wikipedia provides a huge dataset to get started with. Hans-Jürgen Schönig 📄 [TimescaleDB to the Rescue: Speeding Up Statistics](https://sarvendev.com/posts/timescale-db-to-the-rescue/) – TimescaleDB’s power at rapidly handling analytical time series workloads wowed this engineer who's more familiar with the MySQL ecosystem Kamil Ruczyński 🛠 Code and Tools [pg_auto_failover 2.2: Automated Failover Extension](https://github.com/hapostgres/pg_auto_failover) — An extension and service that monitors and manages automated failover for a Postgres cluster. Now supporting Postgres 17. Microsoft 🤖 [Postgres Pro: An MCP Server to Let AI Agents Tune and Improve Your Database Usage](https://github.com/crystaldba/postgres-mcp) — I suspect it’ll need to be renamed (so as not to confused with [the company of the same name](https://postgrespro.com/)?), but this is an interesting first step at providing a bridge between modern AI models and agents and Postgres by way of an [MCP](https://modelcontextprotocol.io/introduction) server that lets AI agents interrogate your Postgres database to tune indexes, make changes, run SQL, etc. Crystal Corp. - [FerretDB 2.1](https://github.com/FerretDB/FerretDB/releases/tag/v2.1.0) – A database that acts like MongoDB but uses Postgres for storage. - [BemiDB 0.48](https://github.com/BemiHQ/BemiDB) – Single binary Postgres read replica optimized for analytics. - [pgroll 0.11](https://github.com/xataio/pgroll/releases/tag/v0.11.0) – Zero-downtime, reversible schema migrations for Postgres. - [pg-boss 10.2](https://github.com/timgit/pg-boss) – Postgres-based job queuing system for Node.js. - [pg_dumpbinary v2.19](https://www.postgresql.org/about/news/pg_dumpbinary-v219-released-3054/) – Dumps a database to a binary format. - [Martin 0.16](https://github.com/maplibre/martin/releases/tag/v0.16.0) – Fast Rust-powered PostGIS map tile server. - [Prisma 6.6](https://www.prisma.io/blog/prisma-orm-6-6-0-esm-support-d1-migrations-and-prisma-mcp-server) – Popular ORM for Node.js and TypeScript. **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|*).