Skip to content
Postgres SQL HTX

Postgres SQL HTX

Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.

  • About
  • Blog
  • Privacy Policy
  • What We Do
  • Resources
Architecture and operations

PostgreSQL Production Monitoring: 7 Metrics That Matter

Monitoring is the backbone of every production PostgreSQL deployment. Whether you run Patroni-managed high availability on your own hardware or Amazon Aurora in the cloud, you cannot fix what you cannot see. Yet most monitoring setups I audit collect hundreds of metrics and alert on almost none of them — or worse, they page a […]

Avatar photo David Sterling 3 months ago
Learning resources

How to Migrate PostgreSQL to Amazon RDS

If your Houston startup or enterprise is still running PostgreSQL on a self-managed server, Amazon RDS is one of the fastest ways to cut operational overhead. AWS handles backups, patching, failover, and storage scaling, and its managed engine keeps you on supported versions — AWS publishes guidance on when new open source engine versions land […]

Avatar photo David Sterling 3 months agoAugust 19, 2026
Performance and tuning

Read PostgreSQL EXPLAIN Plans: Find Slow Queries Fast

Somewhere in Houston, a query that used to run in 40 milliseconds now takes 40 seconds — and the dashboard the whole team depends on is timing out. Before you buy bigger hardware, tune shared_buffers, or rewrite anything, you need to see what the planner actually decided to do. That is what EXPLAIN is for: […]

Avatar photo David Sterling 3 months agoAugust 18, 2026
postgresql

Postgres Power Moves: Databricks, HorizonDB, Azure vs. RDS

If you blinked this week, you missed a lot. In the span of a few days, the PostgreSQL ecosystem saw a major acquisition, fresh third-party benchmark results, another quarter of Microsoft’s HorizonDB preview, and — yes — someone turned PostgreSQL into a city you can walk around in. Here is the release and community news […]

Avatar photo David Sterling 3 months ago
AI Features and extensions pgvector

Why Your pgvector Benchmarks Are Lying to You

Vector search is the engine room of most RAG applications in 2026, and pgvector has become the default choice for Houston teams who refuse to bolt a separate vector database onto their stack. But there is a dirty secret in the AI tooling world: most pgvector benchmarks — the ones you read and the ones […]

Avatar photo David Sterling 3 months ago
Architecture and operations

PostgreSQL Backups on RDS & Aurora: Verify or Lose Data

Backups are the operation every team postpones until the day it needs one. On Amazon RDS and Aurora, the cloud takes snapshots for you — but “the cloud does it” is not a recovery plan. Snapshots fail. Restores time out. Permissions get forgotten. If you have not actually restored a backup this quarter, you do […]

Avatar photo David Sterling 3 months ago
Learning resources

JSONB Indexing in PostgreSQL: A Step-by-Step Guide

JSONB is one of PostgreSQL’s most popular features — it lets you store flexible, schema-less documents in a relational database. But the moment your JSONB table grows past a few thousand rows, unindexed queries start to crawl. The good news: PostgreSQL gives you several indexing strategies that keep JSONB fast without giving up flexibility. In […]

Avatar photo David Sterling 3 months ago
Performance and tuning

PostgreSQL Slow Query Triage: Read EXPLAIN Plans

Every Houston team hits the same wall eventually: a query that used to return in milliseconds now takes 30 seconds, and production is waiting. Before you buy more RAM, spin up another replica, or shard your database, spend five minutes reading the query plan. In my years triaging slow queries, the fix is visible in […]

Avatar photo David Sterling 3 months agoAugust 11, 2026
postgresql

Postgres Summit US 2026 Schedule Live, pgAdmin 9.17 & More

It’s a packed Monday in the Postgres world. The Postgres Summit US 2026 talk schedule is officially live, four ecosystem projects shipped updates in the past week — including a pgAdmin 4 security release that patches seven CVEs and pgBackRest 2.59 with PostgreSQL 19 support — and the AI-agent era got its own managed Postgres […]

Avatar photo David Sterling 3 months ago
AI Features and extensions pgvector

Why Your pgvector Benchmark Is Lying to You

Vector search has moved from exotic to table stakes. pgvector is bundled into Amazon RDS and Aurora, Google Cloud SQL, Azure Database for PostgreSQL, and countless self-managed clusters — and the benchmark posts keep coming: 10,000 queries per second! 50x faster than brute force! The New Stack recently published a sharp critique of the genre […]

Avatar photo David Sterling 3 months ago

Posts pagination

1 … 5 6 7 8 9 … 11
  • About
  • Blog
  • Privacy Policy
  • What We Do
  • Resources
>
Copyright 2026. All rights reserved.

As an Amazon Associate, we earn from qualifying purchases.