--- title: "A counterintuitive result of giving Postgres more memory" publication: "Postgres Weekly" issue: 623 published_at: "2025-11-06" canonical_url: "https://postgresweekly.com/issues/623" --- Plus PostGraphile v5 begins to appear, and some trip reports from PGConf EU. | #​623 — November 6, 2025 [Web Version](https://postgresweekly.com/issues/623) Together with [![Microsoft logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://aka.ms/learn_postgres-AI) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gyp9wmug1js5rwoeb5xc.jpg)](https://vondra.me/posts/dont-give-postgres-too-much-memory/) [Don't Give Postgres Too Much Memory](https://vondra.me/posts/dont-give-postgres-too-much-memory/) — The more memory, the better, right? Not when it comes to Postgres’ `maintenance_work_mem` and `work_mem` settings, as Tomas demonstrates here. CPU cache size and OS memory management play key roles in the results. Tomas Vondra [Introducing pg_lake: Integrate Your Data Lakehouse with Postgres](https://www.snowflake.com/en/engineering-blog/pg-lake-postgres-lakehouse-integration/) — A set of extensions that add comprehensive [Iceberg](https://iceberg.apache.org/) support and data lake access (including Parquest, CSV and JSON support) to Postgres, with DuckDB transparently integrated into the query engine for fast execution without leaving Postgres. [GitHub repo.](https://github.com/Snowflake-Labs/pg_lake) Craig Kerstiens (Snowflake) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/73a672c8.jpg)](https://aka.ms/learn_postgres-AI) [Build AI Apps with Postgres on Azure](https://aka.ms/learn_postgres-AI) — Explore practical steps and tools to bring advanced AI capabilities into your apps. Learn how to integrate Azure AI and Machine Learning with Postgres on Azure to build intelligent, AI-powered applications. [Start learning](https://aka.ms/learn_postgres-AI). Microsoft sponsor **IN BRIEF:** - 🗓️ The [PostgreSQL Event Calendar](https://ics.postgresql.life/) is a site keeping track of Postgres-oriented events and also hosts an ICS / iCalendar file you can add to your own calendar app. Events currently run through to 🇦🇹 [PGDay Austria](https://pgday.at/) taking place in September 2026. - [postgres-contrib.org](https://postgres-contrib.org/) is a blog rounding up contributions made to the Postgres project on a mostly weekly basis. - 🇨🇿 If you'd like to speak at [Prague PostgreSQL Dev Day](https://p2d2.cz/en/) 2026, [its CFP](https://cfp.p2d2.cz/2026/cfp) closes next week. It takes place on January 27-28 in Prague, Czechia. - It's not available yet, but [PlanetScale's announcement of a forthcoming $5/mo Postgres plan](https://planetscale.com/blog/5-dollar-planetscale) caused some excitement on social media this week. 🇪🇺 [A PGConf EU 2025 Trip Summary](https://techcommunity.microsoft.com/blog/adforpostgresql/postgres-trip-summary-from-pgconf-eu-2025-with-lots-of-photos/4465813) — [Europe’s main Postgres conference](https://2025.pgconf.eu/) took place in Latvia two weeks ago and Claire (of the [Talking Postgres podcast](https://talkingpostgres.com/)) shares a detailed trip report covering her role as speaker, Microsoft representative, and more. Lots of photos too. Claire Giordano (Microsoft) 💡 Cybertec's Cornelia Biacsics has [put together a similar report of her own.](https://www.cybertec-postgresql.com/en/head-of-marketing-experiences/) 📄 ["You Don't Need Kafka, Just Use Postgres" Considered Harmful](https://www.morling.dev/blog/you-dont-need-kafka-just-use-postgres-considered-harmful/) – A response to an article we featured last week. Gunnar Morling 📄 [How to Listen to Database Changes Through the WAL](https://peterullrich.com/listen-to-database-changes-through-the-postgres-wal) Peter Ullrich 📄 [Transaction Pooling in Postgres with Pgcat](https://www.enterprisedb.com/blog/transaction-pooling-postgres-pgcat) Phil Eaton 📄 [A SQL Query's Roadtrip Through Postgres](https://internals-for-interns.com/posts/sql-query-roadtrip-in-postgres/) Jesús Espino 📄 [What Are 'Dirty Pages' in Postgres?](https://stormatics.tech/blogs/what-are-dirty-pages-in-postgresql) Umair Shahid **RELEASES AND CODE:** [pg_timetable 6.1 Released: Advanced Job Scheduling Extension](https://github.com/cybertec-postgresql/pg_timetable) — A mature, advanced standalone job scheduler extension that lives entirely in your database and lets you schedule Postgres commands and queries, system programs and built-in operations, as well as chain tasks together. CYBERTEC PostgreSQL International GmbH 📰 Classifieds How note​.com, Japan's top C2C creator platform, replaced its GitHub Actions + SSH proxy flow with [Just-in-Time (JIT) access control](https://www.bytebase.com/blog/note-case-study/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251106) for more secure Aurora Postgres access. --- 🧠 [The 100% open-source PostgreSQL you trust:](https://www.pgedge.com/products/what-is-pgedge-enterprise-postgres) now enterprise-grade and globally distributed-ready. [PostGraphile v5 Release Candidate](https://postgraphile.org/news/2025-10-28-v5-release-candidate) — [PostGraphile](https://postgraphile.org/) provides a way to create an automatic GraphQL API backed by a Postgres database (akin to how [PostgREST](https://docs.postgrest.org/en/v14/) puts a RESTful API in front of a database). v5 has been five years in the making and is.. _almost_ here. Benjie and Jem - [PGSync 6.0](https://pgsync.com/) – Postgres to Elasticsearch/OpenSearch syncing. As of v6.0 it has MySQL/MariaDB support too. - [Stateless Postgres Query Router (SPQR) 2.8](https://github.com/pg-sharding/spqr/releases/tag/2.8.0) – An approach to horizontal sharding, originally built at Yandex Cloud. - [PostgREST 14.1](https://github.com/PostgREST/postgrest) – A REST API for any Postgres database. - [Squawk 2.30](https://github.com/sbdchd/squawk) – Linter for Postgres migrations and SQL. **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|*).