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
postgresql

PostgreSQL 19 RC 1 Lands as GA Slips to November 19

PostgreSQL 19 RC 1 shipped October 15, but general availability moved to November 19 with a second release candidate. What was reverted, what stayed, and what to test before you upgrade.

Avatar photo David Sterling 4 weeks ago
AI Features and extensions pgvector

Postgres Vector Indexes 2026: HNSW, DiskANN, or No Graph?

HNSW, StreamingDiskANN, and a new partition-plus-compression design: how to pick a Postgres vector index, fix filtered search, and keep it in RAM.

Avatar photo David Sterling 1 month ago
Architecture and operations

PostgreSQL 19 RC 1: An Ops Plan to Rehearse pg_upgrade Now

Release candidate 1 is out and GA lands November 19. A five-week ops plan to rehearse pg_upgrade, replication cutover and rollback before production sees it.

Avatar photo David Sterling 1 month ago
Learning resources

How to Bulk Load Data into PostgreSQL with COPY

COPY vs \copy, staging tables, ON_ERROR handling, load-speed tuning, and verification: a step-by-step guide to loading millions of rows into Postgres.

Avatar photo David Sterling 1 month ago
Performance and tuning

PgBouncer vs RDS Proxy: Picking a Postgres Pooler in 2026

Postgres runs out of connections long before it runs out of CPU. The classic shape: an application fleet scales from 12 pods to 60 for a morning peak, each pod holding a 10-connection pool, and an instance comfortable at 120 backends is suddenly carrying 600. No query got worse; everything got slower. Every backend is […]

Avatar photo David Sterling 1 month ago
postgresql

Postgres News: JDBC CVE Patch, Citus Query Routers

PostgreSQL JDBC 42.7.14 patches two CVEs that touch every JVM service on Postgres, plus Citus query routers in StackGres 1.19, pgNimbus 1.0, and the October community calendar.

Avatar photo David Sterling 1 month ago
AI Features and extensions pgvector

pg_plan_filter 1.0: Block Runaway Postgres Queries by Cost

pg_plan_filter 1.0.0 refuses Postgres statements whose estimated plan cost is too high. How to install it, choose limits, and cap runaway batch work.

Avatar photo David Sterling 1 month ago
Architecture and operations

Postgres Transparent Data Encryption: pg_vault_tde 1.7.2

pg_vault_tde 1.7.2 shipped a new on-disk format and a WAL resource-manager ID change that rules out a rolling upgrade. An operations runbook for Postgres transparent data encryption: config, upgrade steps, key rotation, backups and monitoring.

Avatar photo David Sterling 1 month ago
Learning resources

BM25 Full-Text Search in Postgres: pgx-bm25 Tutorial

pgx-bm25 1.0 puts Okapi BM25 ranking into a native Postgres index access method. Build it, index a table, and run ranked, boolean, proximity and snippet queries step by step.

Avatar photo David Sterling 1 month ago
Performance and tuning

pg_ivm 1.16: Stop Paying the REFRESH MATERIALIZED VIEW Tax

If your Postgres dashboard runs REFRESH MATERIALIZED VIEW on a schedule, you know the ritual: for a few seconds, readers queue behind a lock while the database recomputes a result it mostly already had. The fix is not a faster refresh. It is not refreshing at all. pg_ivm — the Incremental View Maintenance extension — […]

Avatar photo David Sterling 1 month ago

Posts pagination

1 2 3 4 5 … 11
  • About
  • Blog
  • Privacy Policy
  • What We Do
  • Resources
>
Copyright 2026. All rights reserved.

As an Amazon Associate, we earn from qualifying purchases.