Hacker News new | past | comments | ask | show | jobs | submit login

Yeah, there’s index size, and also disk size. Postgres packs table rows on disk tightly, but not in RAM.

So I guess an 8kb page on disk could be more than 8kb in ram?

Seems to only affect working memory for table row data. Still significant (especially in Postgres where rows are randomly ordered which is horrible for locality for range queries) but not a home run insight imo.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: