The point of view from over 30y carres. I love Postgre, I've known Redis recent. Each have great functions. Every products have unique functions at their early season, but getting fat by adding similarity functions with others. Implementing function is not difficult in there because it is a software, but sometimes it makes lose its the first strength. I've loved Postgre since its v3, but once it had been pushed by MySQL, because of LAMP boom. I wish Postgre does not be a fat system alike Oracle. And also want Redis to take the right direction.
I mean Postgre did not need to support pub/sub and so on.
Actually pub/sub works best when you can commit it in a transaction along with your data changes. When they are separate systems, you get a race condition where you could commit the change but crash before the event gets published.
