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”.

Hands typing on a laptop computer screen 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.

a computer screen with a blue background 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.

postgres psql terminal linux server — illustration for article on Transparent Huge Pages + Postgres: Stop 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.

MongoDB vs PostgreSQL 2026: Which Database Actually Wins? 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.

SQLite vs PostgreSQL 2026: Which DB Wins for App Backends? 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.

Close-up of computer server rack components 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.

ClickHouse vs PostgreSQL for Analytics in 2026: Which DB Wins? 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.

a bunch of wires that are connected to a server 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.

postgresql database server terminal linux — illustration for article on PostgreSQL Performance Halved on Linux Kernel 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.