Columnar VS Row Storage In Databases
Columnar storage is optimal for analytical queries, while row storage is optimal for transactional queries. This article explores the difference.
Data System Reviews
A blog about data systems and data engineering. We categorize, review, and compare data systems and data engineering tools.
Latest posts
PostgreSQL VS MySQL Performance Comparison
PostgreSQL is significantly faster than MySQL in my most recent performance benchmarks using Reserva, a custom database benchmarking tool.
PostgreSQL VS MariaDB Performance Comparison
PostgreSQL was much faster than MariaDB in my latest rounds of tests. I would use it, if that choice is availabile.
MariaDB VS MySQL Performance Comparison
MariaDB is significantly faster than MySQL, according to my custom benchmarking tool. I would prefer using MariaDB, if I had that choice.
Fastest Open-Source Databases
PostgreSQL and MariaDB are the fastest mainstream open-source databases. MySQL has some catching up to do.
SkySQL VS AWS Aurora Performance Comparison
SkySQL is 30% faster and 24% cheaper than AWS Aurora in my tests. I recommend checking it out for any MySQL compatible workloads.
Best Open-Source Vector Databases
A roundup of the most popular vector databases, their relative performance levels, and an explanation of where each one shines.
PostgreSQL 17 Performance Benchmark
PostgreSQL 17 claims many performance improvements. In this article, I benchmark it against PostgreSQL 16.
lil-bit And speedy-1 Testing Environment
A description of an Intel mini-pc testing environment I frequently use to run Reserva database benchmarks.
GCP AlloyDB VS AWS Aurora Performance Comparison
GCP AlloyDB is 12% to 13% faster than AWS Aurora at a similar price point. Aurora has some nice durability features, though.