Postgres just got even faster Like most databases, Postgres work...
Hussein Nasser@hnasr
38 views
Sep 08, 2024
~1 min read
Advertisement
1
Postgres just got even faster
Like most databases, Postgres work with fixed size pages. Those pages are 8K in size, each page will have the rows, or index tuples and a fixed header. The pages are just bytes in files and they are read and cached in the buffer pool.
If a table has 100 pages, to do a full table scan, we would be making close to 100 system read calls, taking kernel read-ahead in to consideration.
Postgres 17 now combines I/Os to retrieve multiple pages at once. This leads to fewer system calls and lower read latency.
Watch my full coverage in this video
Postgres just got even faster
youtu.be/1KzcJXNSzgE
If you prefer audio, listen to the podcast
open.spotify.com/show/55pPBm0l7…
Like most databases, Postgres work with fixed size pages. Those pages are 8K in size, each page will have the rows, or index tuples and a fixed header. The pages are just bytes in files and they are read and cached in the buffer pool.
If a table has 100 pages, to do a full table scan, we would be making close to 100 system read calls, taking kernel read-ahead in to consideration.
Postgres 17 now combines I/Os to retrieve multiple pages at once. This leads to fewer system calls and lower read latency.
Watch my full coverage in this video
Postgres just got even faster
youtu.be/1KzcJXNSzgE
If you prefer audio, listen to the podcast
open.spotify.com/show/55pPBm0l7…
