Redis is fast – I'll cache in Postgres

Post by simonw » Fri, Sep 26, 2025, 2:47 PM UTC

lomase wrote: post #229

simonw wrote: post #227

Earlier quoted context omitted.

Probably about 10 cents, if you're even paying for tokens. Plenty of these tools have generous free tiers or allowances included in your subscription. I run a pricing calculator here - for 50,000 input tokens, 5,000 output tokens (which I estimate would be about right for a PostgreSQL optimization loop) GPT-5 would cost 11.25 cents: https://www.llm-prices.com/#it=50000&ot=5000&ic=1.25&oc=10 I use Codex CLI with my $2…

If optimizing a Postgress SQL server cost 11.25 cents and everybody can do it because AI how much are you going to bill your customer? .20 cents? If that is true in some months there will be no dba jobs. Funny that at the same time SQL is one of the most requested languages in job postings.

Post by [deleted] » Fri, Sep 26, 2025, 2:50 PM UTC

motorest wrote: post #93

re-thc wrote: post #87

Earlier quoted context omitted.

> All of this at a fraction of the cost of HA redis This depends on your scale. Dynamodb is pay per request and the scaling isn’t as smooth. At certain scales Redis is cheaper. Then if you don’t have high demand maybe it’s ok without HA for Redis and it can still be cheaper.

> At certain scales Redis is cheaper. Can you specify in which scenario you think Redis is cheaper than caching things in, say, dynamodb.

Post by sherburt3 » Fri, Sep 26, 2025, 2:51 PM UTC

m000 wrote: post #175

lelanthran wrote: post #149

Earlier quoted context omitted.

> 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.

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.

Post by dpkirchner » Fri, Sep 26, 2025, 2:55 PM UTC

dgfitz wrote: post #210

yomismoaqui wrote: post #169

Earlier quoted context omitted.

If you are going to ask ChatGPT some specific tidbit it's better to force it to search on the web. Remember, an LLM is a JPG of all the text of the internet.

Wait, what? Isn't that the whole point, to ask it specific tidbits of information? Are we to ask it large, generic pontifications and claim success when we get large, generic pontifications back? The narrative around these things changes weekly.

Post by GuinansEyebrows » Fri, Sep 26, 2025, 3:00 PM UTC

ezekiel68 wrote: post #51

> Both postgres and redis are used with the out of the box settings Ugh. I know this gives the illusion of fairness, but it's not how any self-respecting software engineer should approach benchmarks. You have hardware. Perhaps you have virtualized hardware. You tune to the hardware. There simply isn't another way, if you want to be taken seriously. Some will say that in a container-orchestrated environment, tuning go…