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

Pgpool-II Security Release Headlines October Postgres News

Pgpool-II patched seven CVEs across five branches on October 1. Plus: Aurora queries Iceberg directly, Supabase buys Turso, pgEdge launches Starfleet, and Dasha 1.8 ships index recommendations.

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

DuckDB in Postgres: Query S3, Iceberg Without an ETL Pipeline

AWS embedded DuckDB in Aurora PostgreSQL for direct Iceberg and Parquet queries. Here is the SQL that works, plus pg_duckdb 1.1.1 for self-hosted Postgres.

Avatar photo David Sterling 2 months ago
Architecture and operations

Pgpool-II 4.7.3 Fixes 7 Watchdog CVEs: Patch Your HA Cluster

Seven CVEs, six of them in watchdog: the Pgpool-II subsystem that owns quorum, the delegate IP, and backend promotion. How to patch a live watchdog cluster one node at a time and harden the watchdog plane while you are in there.

Avatar photo David Sterling 2 months ago
Learning resources

Dasha 1.8 Tutorial: Postgres Index Advice and Schema Lint

Install Dasha 1.8 against your Postgres fleet with a read-only role, then use index recommendations, schema lint and the pg_stat_io I/O page safely.

Avatar photo David Sterling 2 months ago
Performance and tuning

PgBouncer 1.26: Patch Three CVEs, Then Kill p99 Timeouts

PgBouncer 1.26.0 fixes three pre-auth DoS CVEs and adds per-database query_wait_timeout plus pool_idle_timeout. Here is how to tune both for tail latency.

Avatar photo David Sterling 2 months ago
postgresql

PostgreSQL 19 Beta 4 Pulls Features: What Houston DBAs Need

PostgreSQL 19 Beta 4 landed on September 24, 2026 — right on the date the project’s own schedule named. The headline is not a feature that arrived. It is four that left. Per the release announcement, this beta reverted SQL/PGQ property graph query support, online enabling and disabling of data checksums, temporal updates and deletes […]

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

Postgres Hybrid Search for RAG: pgvector + tsvector + RRF

Every RAG prototype works on twenty documents. Then the real corpus shows up with its real shape: maintenance procedures that cite API 610, drilling reports that name a PZ-7 mud pump, permits and work orders full of tag numbers. Ask a pure vector index for “PZ-7 liner torque” and it cheerfully returns five documents about […]

Avatar photo David Sterling 2 months ago
Architecture and operations

Postgres Failover and archive_mode: Why Backups Break

Most failover drills end the same way: the standby takes over, applications reconnect, and everyone goes home. The part that quietly broke is backup continuity. A community question summarized this week by Stefan Fercot on his pgBackRest blog describes exactly this: a standby was promoted with archive_mode=off, and the team wanted to avoid restarting the […]

Avatar photo David Sterling 2 months ago
Learning resources

pgsql-test Tutorial: Real Postgres Tests for RLS and Triggers

Step-by-step setup for pgsql-test: seed an ephemeral Postgres database, test row-level security in both directions, and assert on triggers and constraint violations inside your existing test runner.

Avatar photo David Sterling 2 months ago
Performance and tuning

pg_stat_statements Blind Spots: Why Slow Queries Vanish

pg_stat_statements evicts least-executed statements, splits or merges queryids by parse tree, hides nested work, and has no application_name column. A DBA triage guide for Postgres 17, 18, and 19.

Avatar photo David Sterling 2 months ago

Posts pagination

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

As an Amazon Associate, we earn from qualifying purchases.