5mins of Postgres E30: Postgres performance puzzle, Linux readahead, tuning effective_io_concurrency
Today, we're going to talk about an interesting Postgres performance puzzle by Jeremy Schneider, Linux readahead and how to tune effective_io_concurrency. The default Linux readahead setting assumes sequential scans ahead, but you might want to change it, together with effective_io_concurrency, which tunes how much Postgres is telling the Linux Kernel to look ahead.
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
PostgreSQL Performance Puzzle - by Jeremy Schneider
https://ardentperf.com/2022/07/16/pos...
Jeremy Schneider on Twitter
/ jer_s
5mins of Postgres E10: max_wal_size, Postgres full page writes and UUID vs BIGINT primary keys
https://pganalyze.com/blog/5mins-post...
Researching the Performance Puzzle - follow-up blog post by Jeremy Schneider
https://ardentperf.com/2022/07/31/res...
General Purpose SSD (gp2) volumes - AWS
https://docs.aws.amazon.com/AWSEC2/la...
Bitmap Heap Scan
https://pganalyze.com/docs/explain/sc...
Asynchronous Behavior - effective_io_concurrency on postgresql.org
https://www.postgresql.org/docs/14/ru...
Benchmarking effective_io_concurrency
https://www.postgresql.org/message-id...