4 ms·
Active Queue table and then archive jobs to a JobDone table? I do that. Queue table is small but archive goes back many months
by djbusby 3y 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
- MattIPv4 3y agoWe 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.
- paulddraper 3y agoIn modern PG you can use partitioned table for a similar effect.