Database Performance
2 posts tagged #database-performance
Developer Tools SQLite vs PostgreSQL for App Backends: When to Use Each
I'd pick SQLite for single-server apps under ~10k daily active users and PostgreSQL the moment you need concurrent writes, multi-node deployments, or a team larger than one. The fault line isn't size — it's concurrency and operational complexity.
Technology PostgreSQL and THP on Linux Kernel 6.8: Diagnose and Fix
Transparent Huge Pages set to always can stall PostgreSQL backends during memory compaction. How to check THP and mTHP on Linux Kernel 6.8, fix them, and make the fix survive reboots.
Keep exploring
Close to this topic, not on this page.