You see, postgres like most databases work with fixed size pages. Pretty much everything is in this format, indexes, table data, etc. Those pages are 8K in size, each page will have the rows, or…

HNasr's resource offers insights, tutorials, and resources for developers and technology enthusiasts. Readers can learn about programming languages, web development, and software engineering best practices. With articles, tutorials, and code snippets, HNasr provides  guidance and expertise for exploring new technologies and advancing technical skills.

Hussein Nasser

PostgreSQL 17 introduces a game-changing feature that allows for combining I/Os, improving performance and optimizing disk bandwidth and memory usage.

Combining I/Os in PostgreSQL 17