The JusDB Database Engineering Blog

Use pg_stat_io in PostgreSQL 16 to 18 to see whether client backends or the checkpointer do the writes, and to measure ring buffer, vacuum, extend, and WAL I/O.

Size the MongoDB WiredTiger cache for VMs and containers, read the eviction thresholds in serverStatus, and decide when to resize the cache and when to fix queries and indexes.