ArmorDB engineering
Practical PostgreSQL, without the noise.
Clear guides for running, securing, and scaling PostgreSQL in production—from quick fixes to deeper architecture decisions.
99
Field notes, comparisons, and operational guides.
Latest writing
Recently published
A focused selection from the full archive, ordered by publication date.
PostgreSQL 18 VACUUM and ANALYZE Inheritance Change: What to Check
PostgreSQL 18 changes VACUUM and ANALYZE behavior for inherited parent tables. Learn how to audit maintenance scripts before a managed database upgrade.
PostgreSQL Extension Policy for Managed Databases
Compare PostgreSQL extension choices for managed databases, including contrib modules, trusted extensions, provider support, custom code, and external services.
Fix PostgreSQL: cannot execute INSERT in a read-only transaction
Learn why PostgreSQL reports a read-only transaction, how to confirm whether you are on a replica or read-only session, and the safest fix for managed databases.
PostgreSQL Memory Tuning in Managed Databases: A Practical Deep Dive
A practical guide to PostgreSQL memory tuning for managed databases, covering work_mem, shared buffers, temp files, connection pools, and safe diagnosis.
PostgreSQL 18 Upgrade Checklist for Managed Databases
A practical PostgreSQL 18 upgrade checklist covering compatibility changes, checksums, MD5 deprecation, pg_upgrade statistics, COPY behavior, and managed rollout planning.
PostgreSQL Online Schema Change Options Compared
Compare PostgreSQL online schema change patterns for production apps: concurrent indexes, staged constraints, nullable columns, backfills, and maintenance windows.
PostgreSQL 17 JSON_TABLE: What App Teams Can Use It For
PostgreSQL 17 added SQL/JSON JSON_TABLE support. Learn where it helps managed PostgreSQL applications, where JSONB still needs careful modeling, and what to test before adopting it.
PostgreSQL Queue Options Compared: SKIP LOCKED, LISTEN/NOTIFY, and External Queues
A practical comparison of PostgreSQL-backed queue patterns, LISTEN/NOTIFY signaling, advisory locks, and when to use an external queue instead.
How to Fix PostgreSQL Could Not Determine Data Type of Parameter Errors
A practical guide to fixing PostgreSQL parameter type inference errors in prepared statements, ORMs, and query builders.
PostgreSQL 14 End of Life: What Managed PostgreSQL Teams Should Do Now
PostgreSQL 14 reaches its final scheduled release in November 2026. Here is how to plan a safe upgrade before support ends.
Managed PostgreSQL Instance Sizing: CPU, Memory, Storage, and Connections
A practical managed PostgreSQL instance sizing guide for choosing CPU, memory, storage, I/O, and connection capacity without overbuying too early.
How to Fix PostgreSQL Certificate Verify Failed Errors
A practical guide to fixing PostgreSQL TLS certificate verification failures without weakening production database security.
Explore the archive
Browse by format
Deep dives
Long-form technical articles with real operational depth, benchmarks, and practical decision-making for PostgreSQL teams.
Quick fixes
Compact how-to articles that solve a single error, syntax problem, or connection issue quickly and precisely.
Comparisons
Structured comparisons, feature breakdowns, and decision guides closely aligned with managed PostgreSQL use cases.
News & trends
Current database news, release notes, and trend-driven updates with an eye on how they affect managed PostgreSQL teams.
Ready to put the guides into practice?
Start with managed PostgreSQL, PgBouncer, and a free plan that does not require a credit card.