News for hackers. Stuff that matters.
Re:Redis is fast – I'll cache in Postgres by m000 on Friday September 26, 2025 @03:52AM (#45383922)
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.

Re:Redis is fast – I'll cache in Postgres by lelanthran on Friday September 26, 2025 @05:04AM (#45384392)
> 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.

Re:Redis is fast – I'll cache in Postgres by m000 on Friday September 26, 2025 @06:59AM (#45385077)
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.

Re:Redis is fast – I'll cache in Postgres by lelanthran on Friday September 26, 2025 @08:46AM (#45385880)
> If your don't mind overprovisioning your postgres

Why would I mind it? I'm not using overpriced hosted PostgreSQL, after all.

Re:Redis is fast – I'll cache in Postgres by sherburt3 on Friday September 26, 2025 @10:51AM (#45387196)
My stance has always been stick to 1 database for as long as humanly possible because having 2 databases is 1000x harder.
Re:Redis is fast – I'll cache in Postgres by Implicated on Friday September 26, 2025 @08:33AM (#45385760)
> 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?

Re:Redis is fast – I'll cache in Postgres by lelanthran on Friday September 26, 2025 @08:45AM (#45385869)
> 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.

Re:Redis is fast – I'll cache in Postgres by Implicated on Friday September 26, 2025 @08:50AM (#45385916)
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.