Comment by romanhn

My interpretation of "Postgres for everything", which I totally agree with, is that it is a sane initial default for just about anything. It is a well-understood stack that most people have had some exposure to, and that can handle quite a wide variety of problems. New/specialized tech will have all sorts of sharp edges, it will absolutely introduce complexity, and bring about headaches you didn't expect. And frankly, in lots of cases it's premature optimization. With all that said, if the use case has proven itself out and Postgres is truly starting to struggle - by all means, good time to explore alternatives. There are no silver bullets in this business.