William Oliveira
William Oliveira
There are some js libs that overlay subtitles on the HTML5 player or maybe rely on 3rd party webplayers, but I don't think its the intention of this package
Current query LockRows on query plan `LockRows (cost=0.52..194.36 rows=1 width=10) (actual time=0.026..0.026 rows=0 loops=8857)` Proposed query LockRows on query plan `LockRows (cost=0.00..3553.65 rows=166 width=42) (actual time=0.068..6.381 rows=158 loops=1)` Wouldn't this...
Couldn't we do something like this just to lock job_queues? (removed `for update skip locked` from the sub query and put it in the select session to only run for...
Oh I see, did not think about that I also tried with a simple inner join (would only work for named queues) and I get the same results as the...
A hint of how bad this problem gets: yesterday on production we got 100% CPU on a 192 ACU AWS Aurora Serverless DB with just ~10k jobs
> @williamoliveira I'd be interested to hear how you get on with a regular (rather than Aurora) database. I was able to freeze my 12 cores personal computer with 30...
> Enforcement: create a `unique (queue_name)` index on jobs table to forbid two jobs from same queue existing. > > Situations: > > ### Queue doesn't exist > Insert into...
> Would you need a new table for it? wouldn't a new column on `jobs` table do the trick? As I see the improvement lies in pushing the complexity of...
I am using default value for asyncHooks, which documentations says its true and I am seeing wrong transaction traces