--- title: "Making Postgres much slower (and faster!)" publication: "Postgres Weekly" issue: 610 published_at: "2025-07-31" canonical_url: "https://postgresweekly.com/issues/610" --- Plus Postgres sits at #1 in the Stack Overflow survey results. | #​610 β€” July 31, 2025 [Web Version](https://postgresweekly.com/issues/610) 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/webinars/introducing-query-advisor?source=postgresweeklyexclusive07312025) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/khrspmmtn99ujhlnerps.jpg)](https://byteofdev.com/posts/making-postgres-slow/) [Making Postgres 42,000x Slower (Because I Am Unemployed)](https://byteofdev.com/posts/making-postgres-slow/) β€” We run a lot of items on getting the most out of Postgres and making things run as quickly and smoothly as possible, but could you learn something by going the other way in an attempt to make Postgres as slow as possible? A seemingly pointless exercise, but a good way to learn about what some of Postgres’s configuration options actually do. Jacob Jackson πŸ’‘ If you'd prefer something more directly usable, Jacob has also written [a quick(ish) introduction to tuning Postgres.](https://byteofdev.com/posts/tuning-postgres-intro/) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/255232f8.png)](https://pganalyze.com/webinars/introducing-query-advisor?source=postgresweeklyexclusive07312025) [Speed Up Postgres Queries With pganalyze Query Advisor](https://pganalyze.com/webinars/introducing-query-advisor?source=postgresweeklyexclusive07312025) β€” See how our new Query Advisor feature detected plan issues and sped up a Postgres query by over 1000x. Watch the webinar on demand to learn how to spot inefficient queries, get rewrite recommendations, & track improvements. pganalyze sponsor **IN BRIEF:** - πŸ“Š The [Stack Overflow 2025 survey results](https://survey.stackoverflow.co/2025) are out and it's good news for Postgres sitting at [the number one spot](https://survey.stackoverflow.co/2025/technology#1-databases) for most used database, though MySQL takes the lead for learners. - The EDB blog shares [the tales of Bruce Momjian's latest movements](https://www.enterprisedb.com/blog/what-bruce-momjians-travels-reveal-about-future-postgres) speaking about Postgres all around the world. - [Polina Bungina](https://postgresql.life/post/polina_bungina/) is this week's _PostgreSQL Person of the Week_interviewee. - πŸ€– _Postgres AI_ is working on [an open source 'Self-Driving Postgres' project.](https://postgres.ai/blog/20250725-selft-driving-postgres) [Sharding Postgres at Network Speed](https://pgdog.dev/blog/sharding-postgres-at-network-speed) β€” The lead developer of the [PgDog](https://pgdog.dev/) transaction pooler / Postgres sharding tool shares the technical details of PgDog’s new, high speed logical replication based re-sharding feature. Lev Kokotov πŸ“„ [Why Postgres Needs Better Connection Security Defaults](https://neon.com/blog/postgres-needs-better-connection-security-defaults) – Understanding the difference between `sslmode=require` and `sslmode=verify-full` is essential. George MacKerron (Neon) πŸ“„ [How CERN Powers Ground-Breaking Physics with TimescaleDB](https://www.tigerdata.com/blog/how-cern-powers-ground-breaking-physics-with-timescaledb) – A case study, but with some interesting technical tidbits from the heart of Europe’s science industry. TigerData πŸ“„ [Migration and Upgrades: Achieving Near Zero-Downtime in Postgres](https://severalnines.com/blog/migration-and-upgrades-achieving-near-zero-downtime-in-postgresql/) Sebastian Insausti πŸ“„ [Postgres CDC to Iceberg: Lessons from Real-World Data Pipelines](https://risingwave.com/blog/postgres-cdc-iceberg-production-lessons/) Yingjun Wu (RisingWave) πŸ“° Classifieds 🐘 [Atlas](https://atlasgo.io/blog/2025/07/03/tame-complex-postgres-schemas?utm_source=postgres_weekly&utm_medium=email&utm_campaign=atlas_postgres_20250717) manages Postgres like Terraform manages infra. Define schema as code and safely plan and apply migrations. [Find out more](https://atlasgo.io/blog/2025/07/03/tame-complex-postgres-schemas?utm_source=postgres_weekly&utm_medium=email&utm_campaign=atlas_postgres_20250717). --- πŸ’Œ Did you know we have a whole family of newsletters? Check out [JavaScript Weekly](https://javascriptweekly.com/), [Go Weekly](https://golangweekly.com/) and [Ruby Weekly](https://rubyweekly.com/) for a broader look at what we do. **RELEASES:** [pg_meminfo: Postgres Memory Usage Stats for Linux](https://github.com/bonesmoses/pg_meminfo) β€” A Linux-only extension to inspect detailed per-backend memory usage using simple SQL queries. It surfaces metrics like `pss` for each backend process, making it easier to diagnose memory issues or investigate leaks. Shaun also suggests the code could be useful as a learning exercise for others looking to build similar extensions. Shaun Thomas [pgsql-http 1.7: An HTTP Client for Postgres](https://github.com/pramsey/pgsql-http) β€” _β€œWouldn’t it be nice to be able to write a trigger that called a web service? Either to get back a result, or to poke that service into refreshing itself against the new state of the database?”_ Paul Ramsey - [Mathesar 0.4](https://github.com/mathesar-foundation/mathesar) – A spreadsheet-like interface for Postgres tables. - [DbGate 6.6](https://github.com/dbgate/dbgate) – Database manager app for both SQL and NoSQL databases. - [Supavisor 2.6](https://github.com/supabase/supavisor) – Supabase's multi-tenant Postgres connection pooler. - [RisingWave 2.5](https://github.com/risingwavelabs/risingwave) – Postgres-compatible streaming database. - [Bob 0.39](https://github.com/stephenafamo/bob/releases/tag/v0.39.0) – SQL query builder and ORM/Factory generator for Go. - [Piccolo 1.28](https://github.com/piccolo-orm/piccolo/releases/tag/1.28.0) – User-friendly Python ORM and query builder. - [Prisma 6.13](https://github.com/prisma/prisma/releases/tag/6.13.0) – Next-gen Node.js + TypeScript ORM. - [pgAdmin 4 v9.6](https://www.postgresql.org/about/news/pgadmin-4-v96-released-3108/) – Popular Postgres admin tool. **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|*).