#postgresql
7 posts tagged with #postgresql
Every article below is hand-written, technically reviewed, and focused on postgresql. Posts cover real-world architecture decisions, code-level implementation patterns, and trade-offs you'll only discover after shipping production systems.
Cloud and DevOps Transparent Huge Pages + Postgres: Stop P99 Latency Cliffs [2026]
THP isn’t “free performance” for Postgres. Here are the exact Linux settings to avoid p99 latency cliffs, plus a validation loop and Kubernetes guardrails.
Developer Tools MongoDB vs PostgreSQL 2026: Which Database Actually Wins?
I'd pick MongoDB for rapidly evolving document-heavy workloads and PostgreSQL for anything that touches relational integrity, analytics, or complex queries. Here's the exact fault line I hit running both in production.
Developer Tools SQLite vs PostgreSQL 2026: Which DB Wins for App Backends?
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.
Developer Tools PostgreSQL vs MySQL 2026: Updated Data Changes the Answer
PostgreSQL 18 and MySQL 9.7.1 shipped in 2026 with AI-native features, but DB-Engines data shows only one database is still gaining momentum — here's what matters for your next project.
Cloud and DevOps ClickHouse vs PostgreSQL for Analytics in 2026: Which DB Wins?
ClickHouse dominates analytical workloads with blazing columnar speed; PostgreSQL wins when you need OLTP reliability, rich SQL, and a mature ecosystem. Your choice depends almost entirely on your query patterns.
Technology pgBackRest vs Barman vs WAL-G Compared [2026]
pgBackRest nearly died in April 2026 when its sole sponsor pulled out. Here's what happened, who rescued it, and how it compares to Barman and WAL-G for production PostgreSQL backups.
Technology PostgreSQL Performance Halved on Linux Kernel 6.8: The THP Bug Every DBA Needs to Know [2026 Guide]
Linux Kernel 6.8's changed Transparent Huge Pages behavior silently cuts PostgreSQL throughput by up to 50%. Here's how to diagnose it, fix it, and make it stick across reboots.