Answer the question
In order to leave comments, you need to log in
How relevant is PgQ in 2020?
There is a project that will use Postgres 12 and it needs a queue, I heard about PgQ, but it is very poorly documented, has not been updated or supported for a long time, so the question arises - does it make sense to use PgQ, or are there more recent, supported, queue brokers on top of postgres (performance is not that important), or is it not worth using postgresql at all, but using a specialized database?
Thank you.
Answer the question
In order to leave comments, you need to log in
Well, since they called...
Here I completely agree.
And here it depends what you mean.
pgq is available for postgresql 12 - and there have been a number of commits for this in pgq this year. Similarly, scripts for python3 were adapted this year instead of the former python2. That is, it is generally supported if interpreted as efforts aimed at restoring performance.
If you need a transactional queue in postgresql, I don't know of anything better than pgq. Self-written implementations are made simple and give fireworks in operation under load. See the reports of my colleagues about that, a link to Alexei's report has already been given.
If you need a queue without being tied to transactions in the database, it makes sense to look at specialized brokers. I'm at a loss to suggest anything specific.
If I'm not mistaken in this video https://www.youtube.com/watch?v=HjLnY0aPQZo they talked about not using PgQ these days.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question