News for hackers. Stuff that matters.
Re:RQ – Simple Job Queues for Python by pselbert on Thursday January 02, 2020 @07:41PM (#21941715)
It seems like PG has been pigeonholed as only suitable for “small-medium” size queues, but without numbers to define what “small-medium” means. A few million jobs an hour is entirely reasonable for PG based on anectdata (and I’ve load tested up to 54 million jobs an hour).

PG is an amazing tool that can handle more than most people think (or at least more than I thought).

Re:RQ – Simple Job Queues for Python by heavenlyblue on Friday January 03, 2020 @03:18AM (#21944171)
What about VACUUM? Did they add something to PostgreSQL to lower space consumption?
Re:RQ – Simple Job Queues for Python by pselbert on Friday January 03, 2020 @07:10AM (#21945227)
There has been some progress on that front. For index size there is a new rebuild command in PG12 which works concurrently. There is also pluggable storage now, which enables much more efficient row deletion. I can’t find a link to the new storage format, but here is the announcement for 12 https://www.postgresql.org/about/news/1943/