There is a ton of articles online on how to make your database faster, but how many articles are there about how to make your database slower?
Making Postgres 42,000x slower because I am unemployed is a fun read about how to almost grind Postgres to a halt by only tweaking the
postgresql.conf. No specially crafted slow queries - only config.As the result, the author managed to make his Postgres installation 42 000x times slower compared to the initial benchmarks. tl;dr: tinkering around with the number of IO operations (cache size, vacuum periods, WAL checkpoints) and making the IO single-threaded do the trick here.
#databases #postgresql
