Postgres FM cover image

Partitioning

Postgres FM

CHAPTER

Why I Can't Get Bigger Bytes

Data locality is a huge reason especially for data like time series data or time decay data which has new rows. Fresh data tend to have usage pattern like to be more frequently accessed and we would probably like to have fresh records in our share buffers and a personal system cache  and all the records only few of them.

00:00
Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner