markcallaghan.bsky.social

Watched it and it was excellent.
I will start using 0x.tools soon

I am watching your 2024 p99 conf video right now. Tools look great. When using xtop is there an option to present an aggregated result across many samples?

It has yet to show up on the "on demand" section of the web site

Q: Is RocksDB a good choice if you just want to do point queries for a read-only and IO-bound workload?
A: It depends

smalldatum.blogspot.com/2025/10/how-...

Is there an exception for those of us still traumatized by that Bucky Dent home run? While I haven't been a Red Sox fan, long ago when I watched baseball I could not stand the Yankees.

Bucky Dent does not get to hit home runs in big games.

This was fun to explain.

I was confused at first when looking at flamegraphs where 20% of the samples were from page fault handling while running db_bench with read-heavy and IO-bound workloads.

lnkd.in/g9ZHmuGT

Is it time for TPC-BLOB? DBMS performance and efficiency for workloads with objects larger than the fixed-page size is becoming much more important.

smalldatum.blogspot.com/2025/10/is-i...

Postgres 18.0 looks great vs sysbench on a 32-core server
* Postgres has a few small regressions and many larger improvements from versions 12 to 18.
* There might be several small regressions (<= 3%) from 17.6 to 18.0

smalldatum.blogspot.com/2025/10/post...

Measuring scaleup for Postgres 18.0 with sysbench This post has results to measure scaleup for Postgres 18.0 on a 48-core server. tl;dr Postgres continues to be boring (in a good way) Result...

Measuring scaleup for Postgres 18.0 using sysbench on a many-core server.
Results are mostly excellent and Postgres continues to be boring in a good way.

smalldatum.blogspot.com/2025/10/meas...

Measuring scaleup for MariaDB with sysbench This post has results to measure scaleup for MariaDB 11.8.3 on a 48-core server. tl;dr Scaleup is better for range queries than for point qu...

Measuring scaleup for MariaDB using sysbench on a many-core server.

smalldatum.blogspot.com/2025/10/meas...

Postgres 18.0 looks great vs sysbench on a large server (24 cores)
* Postgres has a few small regressions and many larger improvements from versions 12 to 18.
* There might be many small regressions (<= 2%) from 17.6 to 18.0

smalldatum.blogspot.com/2025/09/post...

Postgres 18.0 looks great vs sysbench on a small server
* Postgres has a few small regressions and many larger improvements from versions 12 to 18.
* There might be a small regression (<= 2%) in short range queries from 17.6 to 18.0

smalldatum.blogspot.com/2025/09/post...

Postgres 18rc1 looks good vs sysbench

smalldatum.blogspot.com/2025/09/post...

And results from a large server with high concurrency (40 connections). The possible regression mostly reproduces here but I am still uncertain that this is a regression.

smalldatum.blogspot.com/2025/09/post...

For Postgres 18 beta3, sysbench and a small server there might be small regressions (~2%) for the microbenchmarks that do range queries without aggregation. Otherwise, the results look great.

smalldatum.blogspot.com/2025/09/post...

And then there is the lawsuit.

MySql 5.6 thru 9.4 vs the Insert Benchmark on a small server.
* good news - there are no large regressions after 8.0
* bad news - there are large regressions from 5.6 to 5.7 and 5.7 to 8.0

smalldatum.blogspot.com/2025/08/mysq...

Oracle had fun PR during the lawsuit. They put up a billboard on 101 with text like:
Helped wanted:
* Oracle - developers
* Informix - lawyers to sue developers

Long ago I was sued after changing employers from Informix to Oracle. It was quickly settled -- we re-signed employment contracts with Informix and went to work at Oracle.

DocumentDB joins the Linux Foundation - Microsoft Open Source Blog Learn how we’re carving out a path where document databases are open, interoperable, and standardized—built with flexibility and reliability.

In other news, DocumentDB was donated to the Linux Foundation is backed by Microsoft and Amazon. Maybe MongoDB should focus on that competitive threat instead of FerretDB, for example, consider adding a cost-based optimizer to MongoDB:
opensource.microsoft.com/blog/2025/08...

In 2021, we founded FerretDB with a bold vision: to return the document database market to its open source roots by creating the leading open source alternative to MongoDB, built on Postgres. For… | ... In 2021, we founded FerretDB with a bold vision: to return the document database market to its open source roots by creating the leading open source alternative to MongoDB, built on Postgres. For yea...

Today I learned that MongoDB has sued FerretDB. I don't know the merits of the case. Regardless, I am not a fan of the lawsuit.
* www.linkedin.com/feed/update/...
* www.linkedin.com/feed/update/...

Sysbench for MySQL 5.6 thru 9.4 on a small server This has performance results for InnoDB from MySQL 5.6.51, 5.7.44, 8.0.43, 8.4.6 and 9.4.0 on a small server with sysbench microbenchmarks. ...

MySQL 5.6 thru 9.4 vs sysbench on a small server
* The bad news - performance regressions aren't getting fixed
* The good news - regressions after MySQL 8.0 are small

smalldatum.blogspot.com/2025/08/sysb...

I didn’t think it was possible for any provider to be worse than ESPN+

Need a version of this for MongoDb

Is OCC in MongoDB raising errors per statement or during commit?

I repeated the 1-client & cached workload for Postgres 18 beta2 and the Insert Benchmark, but changed to run the write-heavy benchmark steps for ~10X more time:
* one regression is gone, see results for l.i2
* one regression remains, see results for qr100

smalldatum.blogspot.com/2025/08/post...

Postgres 18 beta2 vs sysbench on a large server
* results look great
* for a few microbenchmarks there might be regressions of ~2%

smalldatum.blogspot.com/2025/07/post...

Postgres 18 beta2 vs the Insert Benchmark on a large server. There might be small regression, or there might be noise in my results. I have more work in progress to explain it.

smalldatum.blogspot.com/2025/07/post...

Enjoyed this last year. Looking forward to updates. Getting this out is a remarkable achievement. Thank you.

Might be a regression from 14.0 to 18 beta1
* QPS decreases by ~6% and ~18% on the write-heavy steps (l.i1, l.i2)