zlacker

[parent] [thread] 2 comments
1. jagged+(OP)[view] [source] 2024-03-09 20:56:01
Yep, but practically speaking, you need those records anyway even if you're using another queue to actually distribute the jobs. At least every system I've ever built of a reasonable size has a job audit table anyway. Plus it's an "Enterprise Feature™" so you can differentiate on it if you like that kind of feature-based pricing
replies(1): >>hosh+sj
2. hosh+sj[view] [source] 2024-03-10 00:49:49
>>jagged+(OP)
Postgres's LISTEN/NOTIFY doesn't keep those kinds of records. The whole point of using SKIP LOCK is so that you can make updates to rows to keep those kinds of messages with concurrent consumers.
replies(1): >>jagged+iE
◧◩
3. jagged+iE[view] [source] [discussion] 2024-03-10 06:32:02
>>hosh+sj
Yes. I'm saying you'll manually need to insert some kind of job audit log into a different table. Cheers
[go to top]