bgworker currently runs single instance. allow for configuring the number of concurrent bgw that can execute jobs.
We will need to handle the pgmq visibility timeout more careful when there are concurrent workers reading jobs. When background worker picks up a task, it will set the VT to 100 seconds: https://github.com/tembo-io/pg_later/blob/fdc52012137b5403ff149909999ba0ae815595bd/src/bgw.rs#L57
Any task lasting longer than 100 seconds will be subject to duplicate processing.
bgworker currently runs single instance. allow for configuring the number of concurrent bgw that can execute jobs.
We will need to handle the pgmq visibility timeout more careful when there are concurrent workers reading jobs. When background worker picks up a task, it will set the VT to 100 seconds: https://github.com/tembo-io/pg_later/blob/fdc52012137b5403ff149909999ba0ae815595bd/src/bgw.rs#L57
Any task lasting longer than 100 seconds will be subject to duplicate processing.