PostgreSQL
9 posts tagged #postgresql
9 posts on PostgreSQL, spread across AI Coding Tools & Workflow (3), Production AI Engineering (1) — most read: “Postgres Full Text Search vs Elasticsearch: Do You Need ES?” and “How to Back Up PostgreSQL With pgBackRest: S3 and PITR”.
Cloud and DevOps Postgres Full Text Search vs Elasticsearch: Do You Need ES?
If you’re asking “do we really need Elasticsearch?”, the right answer is a reproducible benchmark plus an ops scorecard. Here’s the framework I use.
Cloud and DevOps How to Back Up PostgreSQL With pgBackRest: S3 and PITR
A restore-first pgBackRest setup for PostgreSQL: S3 repo config, retention math (weekly full + daily incrementals), PITR restore drills, and failure-injection tests.
Cloud and DevOps Transparent Huge Pages + Postgres: Stop P99 Latency Cliffs
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: Which Database 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 where the fault line falls.
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.
Developer Tools PostgreSQL vs MySQL: Which to Pick for New Projects
PostgreSQL 18 (September 2025) and MySQL 9.7 (2026) both added 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 Postgres for Analytics: When to Use Each
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: Postgres Backups Compared
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 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.