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
Performance and tuning

pg_fastload 1.0: Postgres Bulk Load on All Your Cores

A 1 GiB CSV load is not I/O bound, and it never was. Run COPY lineitem FROM ‘/tmp/lineitem.csv’ on a 16-core machine and one backend pins a core at 100% while fifteen cores idle, because read, parse, tuple formation and insert all execute serially inside that single backend. The expensive stage is parsing: a quote-aware […]

Avatar photo David Sterling 31 seconds agoNovember 17, 2026
postgresql

Postgres 19 RC 2 Lands as Postgres 14 Goes End of Life

PostgreSQL 19 RC 2 shipped alongside the November minors, and 14.25 is the last Postgres 14 release ever. Here are the post-update steps teams skip.

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

Postgres 18.7 Forces Extensions to Move With the Server

PostgreSQL 18.7’s CVE-2026-6460 fix changes the interface between the server and compiled extensions. How to inventory, patch and reindex without breaking the database.

Avatar photo David Sterling 4 days agoNovember 13, 2026
Architecture and operations

Postgres Replication Slots: Cap WAL Retention Before Disk Full

Replication slots retain WAL unconditionally. Size max_slot_wal_keep_size from peak WAL rate, alert on wal_status, and cap retention before the primary fills.

Avatar photo David Sterling 5 days ago
Learning resources

Anonymize Postgres Test Copies Without Breaking Foreign Keys

A step-by-step walkthrough for building an anonymized Postgres test copy: extract a tenant slice, restore it, pseudonymize values deterministically with hmac, and verify foreign keys before anyone connects.

Avatar photo David Sterling 6 days agoNovember 11, 2026
Performance and tuning

PgBouncer vs App-Side Pools: Benchmark Postgres Connections

Benchmark PgBouncer against application-side pools at the same client count, size pools from server cores, and know what transaction pooling breaks.

Avatar photo David Sterling 1 week ago
postgresql

PostgreSQL 14 Hits End of Life on November 12

PostgreSQL 14.24 ships on November 12, 2026 as the branch’s final release. What end of life means, which versions to land on, and the pre-flight checks that catch most failed pg_upgrade runs.

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

pg_clickhouse 0.11: Query ClickHouse From Postgres, No ETL

EnterpriseDB announced on November 5 that it has acquired Altinity, the main independent provider of enterprise support and managed services for ClickHouse, with integrated enterprise ClickHouse capabilities promised for Q4 2026. You can read the vendor claims yourself in the EDB press release. For a Postgres DBA the M&A is background noise. The useful signal […]

Avatar photo David Sterling 2 weeks ago
Learning resources

Audit Your postgresql.conf: Find Every Non-Default Setting

A five-step audit of a handover Postgres cluster: dump every non-default setting from pg_settings, split reload-safe from restart-required, diff two clusters, then converge with ALTER SYSTEM instead of hand-editing the file.

Avatar photo David Sterling 2 weeks ago
Performance and tuning

Random UUID Primary Keys: Diagnosing the Insert Slowdown

Every few months a team pings me with the same story: insert throughput on one table quietly collapsed. Same hardware, same queries, the only thing that changed is row count. Nine times out of ten the table has a uuid primary key defaulting to gen_random_uuid(), and the index has turned into a pile of half-filled […]

Avatar photo David Sterling 2 weeks agoNovember 3, 2026

Posts pagination

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

As an Amazon Associate, we earn from qualifying purchases.