TLDR
Redis for caching, RabbitMQ for queues, Elasticsearch for search, and MongoDB for... reasons?
Postgres might be too good for its own good. It's so capable that it makes most other databases seem unnecessary for 90% of applications.
Thanks for sharing. The built-in text search sounds helpful for the project I'm working on.
The full text search works quite well. Also, if you just HAVE to store a bunch of data in JSON, it will do that too as well as index and query it. No need for MongoDB (which is the wrong tool for the job 99% of the time anyways).
laughs in ClickHouse
@cm0002 I'm using PostgreSQL's JSON queries, full-text search, and pattern search with n-gram index.
The world's most advanced open source relational database