5 ms·
Not when a queue is involved. IME trying to replicate something like beanstalkd (https://beanstalkd.github.io/ https://beanstalkd.github.io/) in postgres is ask
by orthecreedence 4y ago
Not when a queue is involved. IME trying to replicate something like beanstalkd (https://beanstalkd.github.io/ https://beanstalkd.github.io/) in postgres is asking for trouble for anything but trivial workloads.
If you're measuring throughput in jobs/s, use a real work queue.
- fabian2k 4y agoI think you are dramatically underestimating the speed of Postgres here if you think it breaks > 1 job/s. That's nowhere close to the point where you'd run into trouble with Postgres.
- orthecreedence 4y agoHave you used postgres for a work queue before? I have, and it did not scale even for smaller workloads. It's possible there are new primitives that make it more efficient, but back in 2014/2015 it didn't work.
- cdelsolar 4y agopostgres is extremely efficient. how small was this workload? how big was the pg instance?