tembo-io / pg_later

Execute SQL now and get the results later.
PostgreSQL License
354 stars 10 forks source link

[feature] - concurrent query excecutors #7

Closed ChuckHend closed 1 year ago

ChuckHend commented 1 year ago

The single background worker process currently polls on an interval. This is unlikely to scale when the number of queries in the queue grows. Build a feature to configure the number of concurrent worker processes, or implement some sort of concurrency in the background worker. Note, the background worker itself might be tricky to implement as a Rust async function, but we aren't using the SPI so maybe there is a work around.