Bulletin board, which is better to use PostrgeSQL or MongoDB?

Question

PostgreSQL

A classifieds site, for example, where people post ads to sell cabinets, nightstands from different brands and countries. Traffic is 1 million per month, which database is better suited for such a project?

Answer 1

What is better warm or soft?
PostrgeSQL is a relational database with SQL technology
MongoDB - NoSQL document-oriented storage.
You need to use PostrgeSQL as the main database, and under heavy loads, make the server work easier, keep fat collected bundles of joins as documents in MongoDB. But it is a question of architecture and approaches that can lead to holy war.
Traffic 1kkk per month, it's not a big deal. That is, about 35k snouts a day, a fairly solid attendance but not very fat. Ordinary tsms can keep it even without a cache, maybe I'm wrong, but with me DLE kept 10k a day without a cache and similar things.
In your case, a good server and cache will save you. Now, if you have 1 million a day, then there will be problems.

Answer 2

postgres
when you have 1k rps add memkesh
monga for small pet projects