In the database posts & discussions here I sometimes find that the opinions are strong but the numbers are missing. Obviously applications have wide variation in traffic and query complexity so apples to apples comparisons are hard. Still, I would greatly benefit from hearing some real world experiences with numbers.
Rough approximation database questions for current or prior applications:
1. How many customers do you have?
2. What's expected daily traffic? Peak traffic?
3. What database engine or engines do you use?
4. How many rows or how much storage does your db have?
5. What else about your application is relevant for database load?
6. Microservice, Service, or monolith. Happy with it?
1. It's often information that cannot be casually shared for legal reasons (MNPI)
2. A single customer might generate many queries. There have been times where a single one of my employer's customers generates more traffic than most companies will ever reach at peak.
The right question is - discuss a problem you'd like to solve using PostgreSQL and find people who have solved similar problems.
People did get the spirit of the question and have provided helpful responses, including context about their query structure/complexity.