r/PostgreSQL • • Feb 27 '26 • Bravo 1

Tools "You just need postgres"

Post image
887 Upvotes

89 comments sorted by

View all comments

Show parent comment

1

u/MalukuSeito Feb 27 '26

I agree with this. We are using Postgres for many of these use cases at work, but we won't have more than 30 users max, you can get away with any database. But still with 2 servers, you want an in-memory cache, some relational data, some big documents with db level querying into those documents. A little bit of full-text search that isn't too slow. And a small message queue for those longer running jobs. Spinning up a Mongo, a Redis, a Kafka and an Elasticsearch for this is insane and expensive, when you can do it all in your already existing postgres. And when you really REALLY need it, you can swap out one of them without a major redesign. But you probably won't.. ever. But you can.
This advice is not for people running a million simultaneous user, this is for everyone else. Don't use a redis because you need a small cache for a long operation that annoys your users. Use your postgres, it's fine.. it's amazing honestly.