Benchmarking Redis vs PostgreSQL for caching: An experimental comparison
By
redbell
Baker's choice. Dense with flavour, light on filler.
Summary
A technical experiment comparing Redis and PostgreSQL (using unlogged tables) for caching use cases in API servers. The author runs both databases on a Kubernetes cluster with 2 CPU limits, building a simple HTTP server to test performance differences between Redis and Postgres as a cache layer.
Key quotes
· 3 pulledI thought I'd take a look at one use case - using Postgres instead of Redis for caching.
I'd start from Redis as this is something I frequently encounter at work, switch it out to Postgres using unlogged tables and see if there's a difference.
The idea is to run Postgres or Redis on one node, limiting it to 2CPUs via k8s limits
You might also wanna read
Benchmarking Postgres Write Scalability for Durable Workflow Execution
This article benchmarks the scalability of a single Postgres server for durable workflow execution systems. It focuses on measuring Postgres
dbos.dev·1mo ago
Benchmark Results: Entry-Level MacBook Performance on Database Workloads
The article benchmarks the performance of Apple's latest entry-level MacBook (MacBook Neo) on database workloads using ClickBench and TPC-DS
duckdb.org·2mo ago
How Dapper's String Parameter Handling Can Defeat SQL Server Index Performance
This technical article explains a specific performance issue in SQL Server when using Dapper ORM with C# strings. The author discovered that
consultwithgriff.com·2mo ago
Performance Analysis: fsync Latency on SSDs With and Without Power Loss Protection
This technical article examines the performance impact of fsync operations on SSDs with and without power loss protection. The author docume
smalldatum.blogspot.com·4mo ago
Performance Implications of UUID Version 4 as Primary Keys in PostgreSQL
The article discusses performance issues with using UUID Version 4 as primary keys in PostgreSQL databases, explaining that random UUIDs cau
andyatkinson.com·5mo ago
SQLite's Performance Advantages: How Embedded Design Enables 100,000 TPS Over Billion Rows
This article challenges common misconceptions about SQLite's limitations, arguing that its embedded nature and single-writer architecture ar
andersmurphy.com·6mo ago