--- title: "Benchmarking Postgres 17 vs 18" publication: "Postgres Weekly" issue: 620 published_at: "2025-10-16" canonical_url: "https://postgresweekly.com/issues/620" --- Plus trip reports from PGConf NYC 2025. | #​620 — October 16, 2025 [Web Version](https://postgresweekly.com/issues/620) Together with [![Bytebase\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_275/e_make_transparent/co_white,e_outline:15/e5dl5r6iycqdzkcttmcu.png)](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251016) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/e692qah5p8cek2vviye8.jpg)](https://planetscale.com/blog/benchmarking-postgres-17-vs-18) [Benchmarking Postgres 17 vs 18](https://planetscale.com/blog/benchmarking-postgres-17-vs-18) — The author conducted a series of detailed performance benchmarks between Postgres 17 and 18, in some 96 combinations, and reassuringly finds that Postgres 18 gives us a nice performance bump, local disks rule, and tweaking your settings is still worthwhile. Ben Dicken (PlanetScale) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/c7bfcce2.png)](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251016) [How note․com Implements Just-in-Time (JIT) Database Access Control](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251016) — note.​com, the leading C2C creator platform in Japan, replaced an in-house GitHub Actions + SSH proxy flow for ad-hoc Aurora Postgres access with Bytebase’s just-in-time (JIT) access control. Bytebase sponsor [A Postgres Trip Report from PGConf NYC 2025](https://techcommunity.microsoft.com/blog/adforpostgresql/postgres-trip-report-from-pgconf-nyc-2025-with-lots-of-photos/4460148) — PGConf NYC 2025 took place two weeks ago and was a big success. Claire, well known for her [_Talking Postgres_ podcast](https://talkingpostgres.com/), spills the tea on what happened at the event _and_ shares lots of great photos too. Claire Giordano (Microsoft) 🌆 The EDB Team also [recapped the main threads of PGConf NYC.](https://www.enterprisedb.com/blog/pgconf-nyc-2025-recap-clearer-view-postgres) **IN BRIEF:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/kgq3heua484bbrb3amtp.jpg)](https://devecosystem-2025.jetbrains.com/tools-and-trends) - JetBrains has released the [results of its latest State of Developer Ecosystem Report](https://devecosystem-2025.jetbrains.com/) _(above)_ and Postgres has pushed past MySQL for the first time ever to become the most popular database system in the JetBrains ecosystem. - Often credited with pioneering the Postgres cloud platform/service concept, Heroku has [teased the 'next generation' of _Heroku Postgres_](https://www.heroku.com/blog/introducing-the-next-generation-of-heroku-postgres/), taking it to an even higher scale. - 🇨🇿 [Prague PostgreSQL Developer Day 2026](https://p2d2.cz/en/) takes place next January 27-28 in Czechia. If you'd like to speak, [its Call for Proposals is open](https://cfp.p2d2.cz/2026/cfp) until November 14. - Microsoft's Azure team has [shared a September 2025 roundup](https://techcommunity.microsoft.com/blog/adforpostgresql/september-2025-recap-azure-database-for-postgresql/4459848) of what's new with _Azure Database for PostgreSQL._ - [A cute example of solving a logic puzzle](https://www.reddit.com/r/puzzle/comments/1o5g3my/logic/nj9ap2e/) with Postgres and SQL. [Exploring Postgres 18's New UUIDv7 Support](https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support) — Unlike with UUIDv4, UUIDv7 values are monotonic and time-sortable, which presents some advantages. Fridriksson and Miller (Aiven) 📄 [From Text to Token: How Tokenization Pipelines Work](https://www.paradedb.com/blog/when-tokenization-becomes-token) James Blackwood-Sewell 📄 [Understanding and Setting Postgres JDBC Fetch Size](https://shaneborden.com/2025/10/14/understanding-and-setting-postgresql-jdbc-fetch-size/) Shane Borden **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/rrsyyhvvev1npg7ro4z5.jpg)](https://tanelpoder.com/posts/generate-qr-code-with-pure-sql-in-postgres/) [pqr.sql: Generate QR Codes with Pure SQL in Postgres](https://tanelpoder.com/posts/generate-qr-code-with-pure-sql-in-postgres/) — A cute idea which probably has some non-obvious use case. Though it does take [several hundred lines of SQL](https://github.com/tanelpoder/tpt-postgres/blob/main/demos/pqr.sql) to pull off. Tanel Põder [PGSync 5.0: Postgres to ElasticSearch/OpenSearch Syncing](https://pgsync.com/) — Middleware that captures changes from your database and writes structured documents to your search cluster. Originally for Postgres only, v5.0 adds MySQL/MariaDB support too. [GitHub repo.](https://github.com/toluaina/pgsync) Tolu Aina [Sanitizing SQL with SQL](https://ardentperf.com/2025/10/15/sanitized-sql/) — A proof-of-concept PL/pgSQL function that can take raw SQL and return a sanitized version minus any personally identifiable information. Jeremy Schneider [pg_qualstats: Extension for Collecting Statistics About Predicates](https://github.com/powa-team/pg_qualstats) — Analyze the most often used predicates in queries against your database, perhaps as a way to create the most effective indexes possible. Part of the [POWA (Postgres Workload Analyzer) project.](https://powa.readthedocs.io/en/latest/) Powa Team - [BemiDB 1.7](https://github.com/BemiHQ/BemiDB) – Open-source Snowflake and Fivetran alternative bundled together. - [ParadeDB 0.19](https://github.com/paradedb/paradedb) – Transactional Elasticsearch alternative built on Postgres. - [PgDog 0.1.10](https://github.com/pgdogdev/pgdog) – Horizontal scaling for Postgres with automatic sharding. **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|*).