Postgres Daily
bobbyiliev's profile
Bobby Iliev@bobbyiliev•Sep 07, 2025
63.3K
Materialize's profile
Post cover image

Making Postgres 42,000x slower because I am unemployed

Avatar of hnHacker News•From byteofdev.com•Jul 27, 2025•14m read time

A developer systematically degrades PostgreSQL performance by 42,000x through configuration changes alone, exploring how various postgresql.conf parameters affect database speed. The experiment reduces buffer cache size, forces excessive autovacuum operations, maximizes WAL overhead, disables index usage through cost manipulation, and bottlenecks I/O to a single thread. Starting from 7,082 TPS with default settings, the final configuration achieves less than 0.1 TPS with only 11 successful transactions in 120 seconds across 100 connections.

Sort:

bobbyiliev's user avatar
Bobby Iliev
@bobbyiliev
Joined Sep 24. 2020
63.3K
Materialize's profile

Materialize

Verified

DevOps Engineer | Laravel enthusiast | Docker Captain

Would you recommend this post?

Copy link
WhatsApp
Facebook
X
New Squad
  • © 2026 Daily Dev Ltd.
  • Guidelines
  • Explore
  • Tags
  • Sources
  • Squads
  • Leaderboard