--- title: "Using Postgres as a graph database with Apache AGE" publication: "Postgres Weekly" issue: 631 published_at: "2026-01-14" canonical_url: "https://postgresweekly.com/issues/631" --- Plus we've updated our Postgres event calendar a bit. | #​631 — January 14, 2026 [Web Version](https://postgresweekly.com/issues/631) Together with [![pgEdge\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_294/e_make_transparent/co_white,e_outline:17/fnv5xiqc6lewnu21fbch.png)](https://www.pgedge.com) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/f4ghzsfvl60ofh3glscl.jpg)](https://boringsql.com/posts/good-bad-arrays) [The Hidden Cost of Postgres Arrays](https://boringsql.com/posts/good-bad-arrays/) — If you’ve ever used array data types in your tables but not thought deeply about the tradeoffs versus other approaches, Radim shares some insights that could save you from some subtle issues in production. Radim Marek [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/84d99b3f.png)](https://www.pgedge.com) [Enterprise Grade Postgres for Agentic AI, High Availability and More](https://www.pgedge.com) — pgEdge delivers open-source, 100% Postgres infrastructure for Agentic AI and other enterprise applications that demand high availability, reliability, and/or data sovereignty. Our mission is to make it easy to build, deploy, and manage enterprise-grade applications at scale on the open source Postgres database. pgEdge sponsor [Integer Overflow in Sequence-Generated Primary Keys](https://www.cybertec-postgresql.com/en/integer-overflow-in-sequence-generated-primary-keys/) — If you use `bigint` for a sequence, you could generate a million a second for almost 300,000 years without problems, but if you’re using `serial`/`integer`, you’d overflow in hours at such a rate! Most tables _don’t_ contain billions of rows, but Laurenz has a neat query to look for the problem and some steps you can take to resolve it. Laurenz Albe **IN BRIEF:** - 🇨🇦 [PGConf.dev](https://2026.pgconf.dev/) is taking place this May 19-22 in Vancouver, Canada, and its [call for proposals](https://2026.pgconf.dev/cfp) closes this Friday (January 16). - The _PostgreSQL Code of Conduct Committee_ was looking for new members last year, [now they've announced three](https://www.postgresql.org/about/news/welcoming-three-new-members-to-the-postgresql-community-code-of-conduct-committee-3209/): Semab Tariq (Stormatics), Karen Riggs (formerly EDB), and Gary Evans (PGDownUnder). - 🏴󠁧󠁢󠁳󠁣󠁴󠁿 If you can make it to Scotland this February 12, [PostgreSQL Edinburgh is holding its second meetup.](https://vyruss.org/blog/second-postgresql-edinburgh-meetup.html) [Using Postgres as a Graph Database: Who Grabbed a Beer Together?](https://www.klioba.com/postgresql-as-a-graph-database) — A practical look at the opportunities [Apache AGE](https://age.apache.org/) opens up by bringing graph database concepts and querying natively to Postgres. Taras Kloba 📄 [Don't Give Postgres Too Much Memory (Even On Busy Systems)](https://vondra.me/posts/dont-give-postgres-too-much-memory-even-on-busy-systems/) Tomas Vondra 📄 [Why AI Workloads Are Fueling a Move Back to Postgres](https://thenewstack.io/why-ai-workloads-are-fueling-a-move-back-to-postgres/) Rob Pankow (The New Stack) 📺 [Top 5 Postgres Query Tuning Tips](https://www.youtube.com/watch?v=WzFc7k_3CMU) Janis Griffin **RELEASES AND CODE:** [Barman 3.17.0: Backup and Recovery Manager for Postgres](https://pgbarman.org/) — An admin tool for disaster recovery of Postgres servers enabling remote backups and restoration of multiple servers. [v3.17.0](https://github.com/EnterpriseDB/barman/releases/tag/release%2F3.17.0) now supports operations on inactive/disabled servers and deprecates custom compression for WAL files. EnterpriseDB UK Limited [pg_textsearch 0.4: Modern Ranked Text Search Extension](https://github.com/timescale/pg_textsearch) — A Postgres extension that brings powerful [BM25](https://en.wikipedia.org/wiki/Okapi_BM25) ranking to full text search. [v0.4](https://github.com/timescale/pg_textsearch/releases/tag/v0.4.0) introduces index compression, boasting ~40% smaller indexes _“thanks to delta encoding and bitpacking.”_ Tiger Data - 📊 [pg_statviz 0.9](https://vyruss.org/blog/pg_statviz-0.9-released.html) – Minimalist extension and utility pair for time series analysis and visualization of Postgres' internal statistics. - [pg_partman 5.4](https://github.com/pgpartman/pg_partman/releases/tag/v5.4.0) – Partition management extension that extends Postgres' built-in operations to make managing partitions easier. - [QuestDB 9.3](https://github.com/questdb/questdb/releases/tag/9.3.0) – A big update for the Java-powered time-series database with Postgres wire protocol compatibility. [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/mhipj2i4num2esyfwpxx.jpg)](https://github.com/Maxteabag/sqlit) - [sqlit 1.2.6](https://github.com/Maxteabag/sqlit) _(above)_ – User friendly Python-powered TUI tool for working with numerous SQL databases. - [BemiDB 1.8](https://github.com/BemiHQ/BemiDB) – Open-source Snowflake and Fivetran alternative bundled together. Run complex queries using its Postgres-compatible analytical query engine. - [River 0.30](https://github.com/riverqueue/river) – Fast & reliable Postgres-powered background jobs system for Go. - [PGSync 7.0.5](https://github.com/toluaina/pgsync) – Postgres to Elasticsearch/OpenSearch syncing. - [PostgREST 14.3](https://docs.postgrest.org/en/v14/) – A REST API for any Postgres database. - [neosql.nvim](https://github.com/h4kbas/neosql.nvim) – Neovim plugin for working with Postgres. 🗓 **Upcoming Postgres Events in 2026** - 🇨🇿 [Prague Pg Dev Day 2026 (January 27-28 in Prague)](https://p2d2.cz/en/) - 🇹🇭 [FOSSASIA PGDay 2026 (March 10 in Bangkok)](https://www.postgresql.org/about/event/fossasia-pgday-2026-2563/) — An annual event running alongside the FOSSASIA Summit. - 🇮🇳 [PGConf India 2026 (March 11-13 in Bengaluru)](https://www.pgconf.in/conferences/pgconfin2026) — A multi-day event run by the India PostgreSQL User Group. - 🇫🇷 [pgDay Paris 2026 (March 26)](https://2026.pgday.paris/) - 🇺🇸 [Postgres Conference 2026 (April 21-23 in San Jose)](https://postgresconf.org/conferences/postgresconf_2026) — [CFP is open](https://postgresconf.org/conferences/postgresconf_2026/program/proposals/new) till January 30. - 🇩🇪 [PostgreSQL Conference Germany 2026 (April 21-22 in Essen)](https://2026.pgconf.de/) - 🇧🇪 [PGConf.BE 2026 (May 5 in Belgium)](https://pgconf.be/) - 🇨🇦 [PostgreSQL Development Conference 2026 – a.k.a. pgconf.dev (May 19 in Vancouver)](https://www.postgresql.org/about/event/postgresql-development-conference-2026-pgconfdev-2543/) — [Its CFP](https://2026.pgconf.dev/cfp) is open for just a few more days. - 🇺🇸 [PG DATA 2026 (June 4-5 in Chicago)](https://2026.pg-data.org/) — The first event of a new conference series with an emphasis on education, developer community building, and outreach to academia. - 🇺🇸 [PGDay Boston 2026 (June 9 in Boston)](https://2026.pgdayboston.org/) – [The CFP](https://2026.pgdayboston.org/call-for-papers/) is open till March 20. - 🌐 [POSETTE 2026 (June 16, Virtual/Online)](https://posetteconf.com/2026/) — Microsoft's free, virtual event organized by the Postgres team at Microsoft. [The call for proposals](https://posetteconf.com/2026/cfp/) is open until February 1. _Note: This list is not exhaustive, and we will continue to mention and promote other events over time._ **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|*).