postgresql handles queues well. the tricks are skip lock, hiding the db behind protocols/micro services and judicious use of unlogged tables.

here is a 2015 talk on critical messaging using pg.

https://github.com/jmscott/talk/blob/master/ams-pgopen-20150...