2 ms·

The use case is not representative of a real-life scenario, so the value of the presented results are minimal. A takeaway could be that you can dedicate a post

by m000 1y ago

The use case is not representative of a real-life scenario, so the value of the presented results are minimal. A takeaway could be that you can dedicate a postgres instance for caching and have acceptable results. But who does that? Even for a relatively simple intranet app, your #1 cost when deploying in Google Cloud would probably be running Postgres. Redis OTOH is dirt cheap.

lelanthran 1y ago
> The use case is not representative of a real-life scenario, so the value of the presented results are minimal. Maybe I'm reading the article wrong, but it is representative of any application that uses a PosgreSQL server for data, correct? In what way is that not a real-life scenario? I've deployed Single monolith + PostgreSQL to about 8 different clients in the last 2.5 years. It's my largest source of income.
- m000 1y ago
  When you run a relational database, you typically do it for the joins, aggregations, subqueries, etc. So a real-life scenario would include some application actually putting some stress on postgres. If your don't mind overprovisioning your postgres, yes I guess the presented benchmarks are kind of representative. But they also don't add anything that you didn't know without reading the article.
  - lelanthran 1y ago
    > If your don't mind overprovisioning your postgres Why would I mind it? I'm not using overpriced hosted PostgreSQL, after all.
  - sherburt3 1y ago
    My stance has always been stick to 1 database for as long as humanly possible because having 2 databases is 1000x harder.
- Implicated 1y ago
  > I've deployed Single monolith + PostgreSQL to about 8 different clients in the last 2.5 years. It's my largest source of income. And... do you do that with the default configuration?
  - lelanthran 1y ago
    > And... do you do that with the default configuration? Yes. Internal apps/LoB apps for a large company might have, at most 5k users. PostgreSQL seems to manage it fine, none of my metrics are showing high latencies even when all employees log on in the morning during the same 30m period.
    - Implicated 1y ago
      I'm definitely getting the wrong kind of clients. Kudos to you sir. Sincerely, I'm not hating, I'm actually jealous of the environment being that mellow.

by m000 1y ago

lelanthran 1y ago

> The use case is not representative of a real-life scenario, so the value of the presented results are minimal. Maybe I'm reading the article wrong, but it is representative of any application that uses a PosgreSQL server for data, correct? In what way is that not a real-life scenario? I've deployed Single monolith + PostgreSQL to about 8 different clients in the last 2.5 years. It's my largest source of income.

m000 1y ago
When you run a relational database, you typically do it for the joins, aggregations, subqueries, etc. So a real-life scenario would include some application actually putting some stress on postgres. If your don't mind overprovisioning your postgres, yes I guess the presented benchmarks are kind of representative. But they also don't add anything that you didn't know without reading the article.
- lelanthran 1y ago
  > If your don't mind overprovisioning your postgres Why would I mind it? I'm not using overpriced hosted PostgreSQL, after all.
- sherburt3 1y ago
  My stance has always been stick to 1 database for as long as humanly possible because having 2 databases is 1000x harder.
Implicated 1y ago
> I've deployed Single monolith + PostgreSQL to about 8 different clients in the last 2.5 years. It's my largest source of income. And... do you do that with the default configuration?
- lelanthran 1y ago
  > And... do you do that with the default configuration? Yes. Internal apps/LoB apps for a large company might have, at most 5k users. PostgreSQL seems to manage it fine, none of my metrics are showing high latencies even when all employees log on in the morning during the same 30m period.
  - Implicated 1y ago
    I'm definitely getting the wrong kind of clients. Kudos to you sir. Sincerely, I'm not hating, I'm actually jealous of the environment being that mellow.