Yeah it doesn't make sense to pick something that's not a power of 2 unless you ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

klysm on Feb 18, 2024 | parent | context | favorite | on: My notes on Gitlab's Postgres schema design (2022)

Yeah it doesn't make sense to pick something that's not a power of 2 unless you are packing it.

postalrat on Feb 18, 2024 | [–]

I guess that depends on how the index works.

gfody on Feb 18, 2024 | [–]

we usually work with some page size anyways, 64 5-byte ints fit nicely into 5 512-bit registers, and ~1T is a pretty flexible cardinality limit after ~2B

Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact