Hacker News new | ask | show | jobs
by djbusby 1002 days ago
Active Queue table and then archive jobs to a JobDone table? I do that. Queue table is small but archive goes back many months
2 comments
paulddraper 1002 days ago
In modern PG you can use partitioned table for a similar effect.
link
MattIPv4 1002 days ago
We just have a single table, with a column indicating if the job has been taken by a worker or not. Probably could get a bit more performance out of it by splitting into two tables, but it works as it is for now.
link