Comment by djbusby
3 years 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
3 years 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
In modern PG you can use partitioned table for a similar effect.
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.