--- title: "A new list of AI related Postgres resources" publication: "Postgres Weekly" issue: 545 published_at: "2024-03-06" canonical_url: "https://postgresweekly.com/issues/545" --- Plus 1000+ extensions in one place, database disaster recovery procedures, and the Postgres pigsty. | #​545 — March 6, 2024 [Web Version](https://postgresweekly.com/issues/545) 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://pganalyze.com/blog/index-advisor-v3?utm_source=PostgresWeeklyPrimary03062024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/tjhmevzmzmmo1ay0epcc.jpg)](https://tembo.io/blog/tembo-rag-stack) [Building a Q&A Bot Natively with Postgres Extensions](https://tembo.io/blog/tembo-rag-stack) — [pgvector](https://github.com/pgvector/pgvector) and embedding models have made it easier to create advanced natural language search systems in the past year or two. Here, Tembo shows off how their stack and extensions make it an even easier, direct process. [pg_vectorize](https://github.com/tembo-io/pg_vectorize) is a particular highlight as it’s an extension that automates a lot of the process of transforming text into embeddings using common LLMs. Adam Hendel (Tembo) [Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase](https://blog.peerdb.io/comparing-postgres-managed-services-aws-azure-gcp-and-supabase) — A reasonably simple, straightforward comparison that doesn’t aim to be exhaustive but instead provide pointers for developers in the market for a managed service. Sai Srirampur (PeerDB) [![\](https://copm.s3.amazonaws.com/cfb147f9.png)](https://pganalyze.com/blog/index-advisor-v3?utm_source=PostgresWeeklyPrimary03062024) [pganalyze Index Advisor 3.0: Workload-Aware Index Suggestions](https://pganalyze.com/blog/index-advisor-v3?utm_source=PostgresWeeklyPrimary03062024) — Launched last week, the new advisor finds missing indexes for each table, detects indexes that would block HOT Updates, lets you drill-down to see all considered indexes, and more. Powered by the constraint programming model [introduced at PGCon 2023](https://www.pgcon.org/events/pgcon_2023/schedule/session/422-automating-index-selection-using-constraint-programming/). pganalyze sponsor _IN BRIEF:_ - 🤖 Francesco Tisiot has started a [curated list of AI-related Postgres projects and resources](https://github.com/ftisiot/postgresql-ai-projects) and invites you submit your own additions. - 📅 [The schedule for PGConf.dev 2024](https://www.pgevents.ca/events/pgconfdev2024/schedule/), taking place this May in Vancouver, Canada, has been released. - 📑 If you're in the mood for a little history and need some weekend reading, [The Design of Postgres](https://dsf.berkeley.edu/papers/ERL-M85-95.pdf) is a neat paper from _1986_ about the early days of Postgres and how its design was envisioned. - Microsoft's Claire Giordano talks about [Microsoft's _POSETTE_ Postgres event](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-in-a-name-hello-posette-an-event-for-postgres-2024/ba-p/4073516), how its new name was chosen, and what the event stands for. - 🗣 It's great to see the return of _PostgreSQL Person of the Week_ with [an interview with AWS's Divya Sharma](https://postgresql.life/post/divya_sharma/) about her work, Postgres annoyances, and what she likes most in Postgres 16. ▶[Database Disasters and How to Find Them](https://www.youtube.com/watch?v=tvD0dO-OO-0) — You’re part of an engineering team and you get pinged because something’s gone down.. what happens next? Christophe Pettus [1000+ Postgres Extensions in One Place](https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47) — If you’re on the hunt for Postgres extensions, [PGXN](https://pgxn.org/) is a good place to start, but I also love this scrappier GitHub Gist based approach. Joel Jakobsson ▶[Discussing Postgres Replication at Speed with PeerDB's Sai Srirampur](https://hanselminutes.com/934/postgres-replication-at-speed-with-peerdbs-sai-srirampur) Scott Hanselman podcast [Tips for Tuning Postgres `LIKE`/`ILIKE` Queries via pg_trgm on Azure](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/tips-for-tuning-postgres-like-amp-ilike-queries-via-pg-trgm-on/ba-p/4069179) — Tips to improve query performance when using pattern search with LIKE or ILIKE. Sarat Balijepalli 📰 Classifieds 📢 Need low latency and high availability? Learn the technical advantages of a [fully standard multi-master distributed PostgreSQL architecture](https://www.pgedge.com/landing-pages/multi-master-whitepaper). --- 📧 [Forward Email](https://forwardemail.net/en) is an email forwarding service able to boast being entirely open source. They use quantum-safe, individually encrypted SQLite mailboxes too. 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/na4w67mwpvztxewwsvqf.jpg)](https://github.com/dalibo/pg_activity) [pg_activity 3.5: `htop`-Like Activity Monitoring Tool](https://github.com/dalibo/pg_activity) — Much as you might use top or htop to monitor processes and CPU usage, `pg_activity` gives you a similar look behind the scenes of Postgres with views over running queries, up to date performance stats, and more. Dalibo [Pigsty: A 'Batteries-Included' Postgres Distribution](https://pigsty.io/) — The name of this project always makes me grin: PIGSTY is actually an acronym, standing for _Postgres In Great STYle!_ It’s a Postgres _distribution_ that includes lots of components and tools out of the box in areas like availability, deployment, and observability. The latest release pushes everything up to Postgres 16.2 standards and introduces new ParadeDB and DuckDB FDW extensions. Ruohang Feng [pg_jsonschema 0.3: JSON Schema Validation Extension](https://github.com/supabase/pg_jsonschema) — Postgres’s support for JSON / JSONB columns is second to none, but what if you want to _validate the structure_ of JSON data? _JSON Schema_ provides a way to define JSON-based formats and this extension lets you verify JSON documents using such schemas. v0.3 completes the extension’s Postgres 16 support. Supabase [pg_ivm 1.8: Incremental View Maintenance Extension](https://github.com/sraoss/pg_ivm) — IVM can update materialized views incrementally, which is more efficient than a full recomputation as `REFRESH MATERIALIZED VIEW` does. SRA OSS LLC - [RisingWave 1.7](https://github.com/risingwavelabs/risingwave) – Postgres-compatible streaming database. - [pgvector 0.6.1](https://github.com/pgvector/pgvector) – Vector similarity search for 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|*).