--- title: "A future of AI agents monitoring your Postgres?" publication: "Postgres Weekly" issue: 593 published_at: "2025-03-20" canonical_url: "https://postgresweekly.com/issues/593" --- Plus more thoughts on making Postgres scale horizontally. | #​593 — March 20, 2025 [Web Version](https://postgresweekly.com/issues/593) Together with [![Fusion Auth\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_512,h_127/e_make_transparent/co_white,e_outline:15/es9kzxpnghhbbctheomi.png)](https://fnf.dev/4hE0cQ8) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vs3ewh0adrzndfkmksby.jpg)](https://pgdog.dev/blog/you-can-make-postgres-scale) [You _Can_ Make Postgres Scale](https://pgdog.dev/blog/you-can-make-postgres-scale) — _Newsflash: Postgres scales!_ After last week’s experiments with [a 1 trillion row table using Citus](https://www.cybertec-postgresql.com/en/postgresql-1-trillion-rows-in-citus/), _we_ know Postgres scales, but once you go beyond a certain point, bringing multiple machines into play becomes a potentially complex necessity and the [PgDog](https://pgdog.dev/) horizontal scaling/sharding approach offers just one solution. Lev Kokotov (PgDog) 💡 Staying on the topic of horizontally scaling Postgres, Craig Kerstiens provides more info on where _Citus_ provides value in [Citus: The Misunderstood Postgres Extension.](https://www.crunchydata.com/blog/citus-the-misunderstood-postgres-extension) [Think About `MERGE` in Terms of a `RIGHT JOIN`](https://blog.jooq.org/think-about-sql-merge-in-terms-of-a-right-join/) — `RIGHT JOIN` isn’t encountered too often in SQL as you can just write a more universally understood `LEFT JOIN` alternative instead. However, right join semantics play an important role with the `MERGE` statement. Lukas Eder [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/b921f358.png)](https://fnf.dev/4hE0cQ8) [Sure, You Can Roll Your Own Auth - If You Hate Free Time](https://fnf.dev/4hE0cQ8) — Don’t sacrifice your control. FusionAuth is downloadable, and can be developed and tested locally. A single-tenant architecture provides better scale and security than a purely multi-tenant SaaS model, even if you deploy via the cloud. [Try it for free!](https://fnf.dev/4hE0cQ8) FusionAuth sponsor [Troubleshooting Duplicate Primary Key Rows](https://www.crunchydata.com/blog/postgres-troubleshooting-fixing-duplicate-primary-key-rows) — If a table has unwanted ‘duplicate rows’ (which can happen due to a variety of quirks causing corrupt unique indexes) Greg has a multi-step technique for getting things back under control. Greg Sabino Mullane **QUICK BITS:** - Robert Haas has put out [a fresh call for applications](https://www.postgresql.org/message-id/CA+TgmoZfS_rYU_OjOFFxhbqNS5FyoX5dv1MU7-qE_SoxRzfWLw@mail.gmail.com) to his one-on-one Postgres contributor mentoring program. - 🇨🇭 [Registration for Swiss PGDay 2025](https://www.postgresql.org/about/news/swiss-pgday-2025-open-for-registration-3039/) is open. It takes place near Zurich this June and [the call for papers](https://www.pgday.ch/2025/#cfs) is open until April 7. - 🇬🇧 Alternatively, if you're in the UK, [PgDay UK 2025 has its call for papers open too](https://pgday.uk/events/pgdayuk2025/news/pgday-uk-2025-call-for-papers-and-call-for-sponsors-open-10/) until May 12. The event itself takes place on September 9 in London. - ParadeDB's [`pg_search`](https://www.paradedb.com/blog/introducing_search) is [now available on the Neon platform](https://neon.tech/blog/pgsearch-on-neon) bringing faster BM25-powered full text search to Postgres. - 🤖 [Tembo teases `dba`](https://tembo.io/blog/introducing-dba), a forthcoming 'autonomous AI agent' for monitoring and managing Postgres deployments. However, check out _Code & Tools_ below for another take on this idea.. [Can Artificial Intelligence Create Better Tables Than You?](https://stokerpostgresql.blogspot.com/2025/03/can-artificial-intelligence-created.html) — As someone guilty of leaning on LLMs for a little SQL grunt work lately, this was an interesting read. As ever, you need to stay on your toes and check anything produced before rolling it into production! Dave Stokes ▶🎤 [Why Python Developers Just Use Postgres](https://talkingpostgres.com/episodes/why-python-developers-just-use-postgres-with-dawn-wages) — Dawn Wages of the Python Software Foundation joins Claire Giordano to talk about why Postgres is particularly popular in the Python and Django communities. Talking Postgres Podcast podcast 📄 [`COPY` and `\COPY`](https://stokerpostgresql.blogspot.com/2025/03/postgresqls-copy-and-copy.html) – Two sides of the same coin. `COPY` is run by the server, whereas `\copy` is a psql command that wraps `COPY`. Dave Stokes 📄 [How to Use `regexp_matches` and `regexp_match`](https://www.caktusgroup.com/blog/2025/03/19/how-use-regexp_matches-and-regexp_match-postgresql/) Tobias McNulty 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/pmla9yfnbjooejd6j7j3.jpg)](https://github.com/xataio/agent) [Xata Agent: An 'AI Expert' in Postgres](https://github.com/xataio/agent) — An open source agent that monitors your database, finds root causes of issues, and suggests fixes and improvements. It’s early days in this space but it’s interesting to see different takes on the idea. Xata [pgFormatter 5.6: A Tool to Format SQL Code](https://sqlformat.darold.net/) — You can test it out online, or you can grab [the source from GitHub](https://github.com/darold/pgFormatter) (it’s written in Perl) and run it for yourself. [What’s new in v5.6.](https://www.postgresql.org/about/news/pgformatter-v56-has-been-released-3038/) HexaCluster [pg_ivm 1.10: Incremental View Maintenance (IVM) Extension](https://github.com/sraoss/pg_ivm/releases/tag/v1.10) — A more efficient way to update materialized views incrementally, applying only changes instead of fully recomputing the view like `REFRESH MATERIALIZED VIEW` does. IVM Development Group [pgzx 0.3: Create Postgres Extensions using Zig](https://github.com/xataio/pgzx) — If you’re familiar with [pgrx](https://github.com/pgcentralfoundation/pgrx) as a way to build Postgres extensions with _Rust_, this is a similar idea in the world of [Zig](https://ziglang.org/), another modern systems language that’s a little more C-like than Rust. Xata - [IvorySQL 4.4](https://github.com/IvorySQL/IvorySQL/releases/tag/IvorySQL_4.4) – Postgres 17.4 extended with Oracle compatibility features. **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|*).