O'Reilly logo
  • Goldie Fernandes thinks this is interesting:

Why does this lead to so many blocks being hit by the query? The answer is relatively simple. If the data we need is not packed together tightly but spread out over the table evenly, more blocks are needed to extract the same amount of information, which in turn leads to worse performance.


Cover of Mastering PostgreSQL 10


Excellent explanation!