Hacker News new | ask | show | jobs
by j16sdiz 336 days ago
Can't change the number of partition dynamically.

Additional challenge if jobs comes in funny sizes

1 comments

Depending on exactly what you need, you can often fake this with a functional index on mod(queue_value_id, 5000). You then query for mod(queue_value_id,5000) between m and n. You can then dynamically adjust the gap between m and n based on how many partitions you want