zlacker
[parent]
[thread]
2 comments
1. djbusb+(OP)
[view]
[source]
2023-09-25 01:19:44
Active Queue table and then archive jobs to a JobDone table? I do that. Queue table is small but archive goes back many months
replies(2):
>>MattIP+13
>>pauldd+a3
◧
2. MattIP+13
[view]
[source]
2023-09-25 01:47:53
>>djbusb+(OP)
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.
◧
3. pauldd+a3
[view]
[source]
2023-09-25 01:49:50
>>djbusb+(OP)
In modern PG you can use partitioned table for a similar effect.
[go to top]