--- title: "Is it time for trailing commas in SQL?" publication: "Postgres Weekly" issue: 588 published_at: "2025-02-13" canonical_url: "https://postgresweekly.com/issues/588" --- Plus writing JSONB queries with AI, a big Citus update, and (not) boiling the ocean. | #​588 — February 13, 2025 [Web Version](https://postgresweekly.com/issues/588) Together with [![Heroku\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_135,q_auto/e_make_transparent/co_white,e_outline:18/copm/276290de.png)](https://fnf.dev/4aXdvK7) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/rg252ht4gr5tdyuipsea.jpg)](https://www.shayon.dev/post/2025/40/scaling-with-postgresql-without-boiling-the-ocean/) [Scaling Postgres without Boiling the Ocean](https://www.shayon.dev/post/2025/40/scaling-with-postgresql-without-boiling-the-ocean/) — Postgres scales pretty far out of the box with the default settings, but once a server starts getting some serious load ‘weird issues’ can start to rear their head. Shayon addresses some common issues of this type and the solutions for them. Shayon Mukherjee [How About Trailing Commas in SQL?](https://peter.eisentraut.org/blog/2025/02/11/how-about-trailing-commas-in-sql) — Could this be the simplest yet most requested SQL feature? It's implemented in some dialects, but could it be implemented in Postgres's dialect? And should it? It’s far trickier than it sounds. Peter Eisentraut [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/72e8f19b.png)](https://fnf.dev/4aXdvK7) [Find Your Flow with Heroku Postgres](https://fnf.dev/4aXdvK7) — The world’s most advanced open source database is easier to use than ever. With Heroku’s PostgreSQL database service, you can get the most out of your data and leave the admin to us. So go ahead and focus on your data-driven apps – we got you. Heroku Postgres sponsor **QUICK BITS:** - 🤖 Is it possible to [learn anything about Postgres by using a local, free LLM](https://www.postgresonline.com/journal/index.php?/archives/418-Learning-PostgreSQL-from-AI-and-JSON-exploration.html) (Phi 4 in this case) and have it help with building JSONB queries? Surprisingly, yes. - [Postgres 17 is now available on DigitalOcean's](https://www.digitalocean.com/blog/postgresql-17) managed Postgres service. - The Timescale team [rounds up eight essential Postgres extensions,](https://medium.com/timescale/top-8-postgresql-extensions-f72d5de57f1f) along with a primer on how to install and use extensions generally. Surprisingly, TimescaleDB _isn't_ in the eight! :-) - 🎤 [Robert Haas went on the _Talking Postgres_ podcast](https://talkingpostgres.com/episodes/why-mentor-postgres-developers-with-robert-haas) to talk about the importance of mentoring developers who want to work on the Postgres project. [Dealing With `"found xmin ... from before relfrozenxid"`](https://www.cybertec-postgresql.com/en/postgresql-found-xmin-from-before-relfrozenxid/) — A look into a commonly reported error with easily misunderstood wording. It occurs during (and breaks) the vacuuming process when an unfrozen tuple’s `xmin` predates the table’s `relfrozenxid`, signaling data corruption. Luckily, there are solutions. Laurenz Albe 📄 [Working with the Postgres Protocol From Rust](https://levkk.bearblog.dev/working-with-the-postgres-protocol/) – From the creator of the [PgDog](https://github.com/levkk/pgdog) sharding proxy. Lev Kokotov ▶️ [The Early History of Spatial Databases and PostGIS](https://blog.cleverelephant.ca/2025/02/postgis-day.html) Paul Ramsey 🛠 Code and Tools [Citus 13: Now with Postgres 17 Support](https://www.citusdata.com/blog/2025/02/06/distribute-postgresql-17-with-citus-13/) — Citus is a long standing open source extension that makes it easier to horizontally scale Postgres. Bought by Microsoft some years ago, it continues to get releases, including this new one with Postgres 17 support, including for distributed queries using `JSON_TABLE()` and improved support for distributed partitioned tables. Naisila Puka (Citus Data) [Locksmith: Detect SQL Migration Issues Quickly](https://github.com/orf/locksmith) — A new Rust-powered tool to detect table locks, table rewrites, and modified tables, columns and indexes during a schema migration. Tom Forbes [pgroll 0.9.0 Released with New Schema Migration Features](https://pgroll.com/blog/pgroll-09-update) — [pgroll](https://github.com/xataio/pgroll) is a tool for performing reversible schema migrations on Postgres without taking the database down. v0.9 supports adding table-level constraints into the table creation process, as well as generated columns. Andrew Farries [Pig v0.1.4: Now with 400 Postgres Extensions](https://github.com/pgsty/pig/releases/tag/v0.1.4) — [Pig](https://www.postgresql.org/about/news/announce-pig-the-postgres-extension-wizard-2988/) (short for _Postgres Install Genius_) is one of the newer attempts to manage Postgres extensions in a package-based fashion. The latest version adds support for Microsoft’s DocumentDB, pg_tracing, pg_cooldown, VectorChord-bm25, and more. Pigsty 📰 Classifieds Making the move from Oracle to Postgres? Read this in-depth guide to [replacing Oracle hints with pg_hint_plan equivalents](https://pganalyze.com/blog/migrating-from-oracle-hints-to-pg-hint-plan-on-postgresql?utm_source=PostgresWeeklyClassified02132025) & when not to use hints. --- 📑 Start tracking vital resource and activity metrics from your PostgreSQL databases with [Datadog's handy cheatsheet](https://www.datadoghq.com/resources/datadog-postgresql-cheatsheet/?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=dg-dbm-ww-postgres-cheatsheet-pg). - [PeerDB 0.25](https://github.com/PeerDB-io/peerdb) – Stream data from Postgres to data warehouses, queues and storage engines. - [pgxmock 4.5](https://github.com/pashagolub/pgxmock) – Mock driver to test Postgres interactions in Go. - [Bytebase 3.4.0](https://www.bytebase.com/changelog/bytebase-3-4-0/) – A collaborative database devops platform. - [RisingWave 2.2](https://github.com/risingwavelabs/risingwave/releases/tag/v2.2.0) – Postgres-compatible streaming database. - [postgres-meta 0.86](https://github.com/supabase/postgres-meta) – A RESTful API for managing Postgres. - [DoltgreSQL 0.17](https://github.com/dolthub/doltgresql/releases/tag/v0.17.0) – Version-controlled Postgres-a-like. **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|*).