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

(another Causes engineer here) HASH partitioning could make sense if our queries were primarily filtering on e.g. user_id, but that isn't the case here. Instead we are often querying against one or both of two columns: user_id and action_id. Partitioning by timestamp allows us to ignore partitions older than the user and/or action's creation dates.


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

Search: