4 ms·

> Usually Postgres costs a lot more than Redis if you're paying for a platform. You need to back up your unbelievable assertion with facts. Memory cache is typ

> Usually Postgres costs a lot more than Redis if you're paying for a platform. You need to back up your unbelievable assertion with facts. Memory cache is typically far more expensive than a simple database, specially as provisioning the same memory capacity as RAM is orders of magnitude more expensive than storing the equivalent data in a database.

frollogaston 1y ago
I didn't say it's cheaper for the same cache size. But yeah a base tier Redis that will carry a small project tends to be a lot cheaper than the base tier Postgres.
- motorest 1y ago
  > I didn't say it's cheaper for the same cache size. So be specific. What exactly did you wanted to say? > But yeah a base tier Redis that will carry a small project tends to be a lot cheaper than the base tier Postgres. This is patently false. I mean,some cloud providers offer nosql databases with sub-20ms performance as part of their free tier. Just go ahead and provide any evidence, any at all,that support the idea that Redis is cheaper than Postgres. Any concrete data will do.
  - frollogaston 1y ago
    Look at the Heroku pricing. If you don't like Heroku then look at AWS pricing. Specifically for Postgres, not a NoSQL DB (which Redis can be too)
MangoToupe 1y ago
Why would you cache the entire database though? Seems like an apples to oranges comparison.
- motorest 1y ago
  > Why would you cache the entire database though? I have no ideas where did you got that from.
  - MangoToupe 1y ago
    > specially as provisioning the same memory capacity as RAM is orders of magnitude more expensive than storing the equivalent data in a database. I'm not sure how else to interpret this
    - motorest 1y ago
      Why are you confusing memory capacity as a requirement to store the whole database in memory? I mean, think. What do you think is the biggest performance bottleneck with caches, and how does this relate to memory capacity?

frollogaston 1y ago

I didn't say it's cheaper for the same cache size. But yeah a base tier Redis that will carry a small project tends to be a lot cheaper than the base tier Postgres.

motorest 1y ago
> I didn't say it's cheaper for the same cache size. So be specific. What exactly did you wanted to say? > But yeah a base tier Redis that will carry a small project tends to be a lot cheaper than the base tier Postgres. This is patently false. I mean,some cloud providers offer nosql databases with sub-20ms performance as part of their free tier. Just go ahead and provide any evidence, any at all,that support the idea that Redis is cheaper than Postgres. Any concrete data will do.
- frollogaston 1y ago
  Look at the Heroku pricing. If you don't like Heroku then look at AWS pricing. Specifically for Postgres, not a NoSQL DB (which Redis can be too)

MangoToupe 1y ago

Why would you cache the entire database though? Seems like an apples to oranges comparison.

motorest 1y ago
> Why would you cache the entire database though? I have no ideas where did you got that from.
- MangoToupe 1y ago
  > specially as provisioning the same memory capacity as RAM is orders of magnitude more expensive than storing the equivalent data in a database. I'm not sure how else to interpret this
  - motorest 1y ago
    Why are you confusing memory capacity as a requirement to store the whole database in memory? I mean, think. What do you think is the biggest performance bottleneck with caches, and how does this relate to memory capacity?