I'm surprised there is no mention of hash based indexes (i.e. CREATE INDEX ... U... | Hacker News

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

osigurdson on July 6, 2024 | parent | context | favorite | on: PostgreSQL and UUID as Primary Key

I'm surprised there is no mention of hash based indexes (i.e. CREATE INDEX ... USING hash...) since lookups would conceivably always use equality.

openthc on July 6, 2024 [–]

With UUIDv7/v8 (and ULID) there are some timestamps in the front half. I've seen spots where the query was in the style of `uuid_col >= 'SOME_UUID_0000' AND ulid_col <= 'SOME_UUID_FFFF'` When one is using them ast the timing for record create/insert these things happen.

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