Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

Two features just left PostgreSQL 19.

Both reverts landed after Robert Haas asked the pgsql-hackers list on August 25 whether any of six heavily patched features should come out before 19 ships. One of the two was on his list. One was not.

When huge_pages Help: Using PSI to Find Bottlenecks Before You Decide

When huge_pages Help: Using PSI to Find Bottlenecks Before You Decide

Benchmarking huge_pages on a 128 GB PostgreSQL 18 system shows throughput gains are modest — but page table overhead at 4KB pages can consume up to 20% of total RAM. Use PSI to find where your system is actually stalling before making the call. Part 2 of 3.

PgColumnar 1.0Alpha2 released

Release date: 2026-08-18

Previous release: 1.0-alpha (2026-08-04)

pgColumnar is a columnar table access method for PostgreSQL. This is the second alpha. It adds read-only Apache Iceberg support, reads and writes over S3-compatible object storage, a maintenance daemon, and a broad round of statistics, planner, performance, and security work. The on-disk native format (PGCN v1) is unchanged; existing tables are read and written as before.

This release requires one …

Parquet and Iceberg: An Overview

A pile of containers is not a shipment. A shipment is containers plus a manifest.

Apache Iceberg is the manifest. It is not a file format, it is a table format: a metadata layer that records exactly which Parquet files make up a table at every point in time. That one idea buys you things we used to think required a warehouse. Transactions on object storage, so writers never corrupt …

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Tuning shared_buffers isn't just about peak throughput — it's about how much CPU and disk I/O a system consumes per unit of work. The 25% default can require up to 5x more disk I/O than very low or very high allocation. Part 1 of 3.

What If Your Team’s Biggest Burnout Driver Lives in Your Database?

What If Your Team’s Biggest Burnout Driver Lives in Your Database?

Engineering leaders work hard to protect their teams from burnout — improving processes, hiring strong talent, and adjusting on-call rotations. But if your team still looks exhausted, the real issue may not be the rotation at all. It’s often the underlying database and infrastructure quietly triggering the same incidents over and over.

Why You Should Review Your Authentication Strategy

Why You Should Review Your Authentication Strategy

Released in July 2025, NIST SP 800-63 Revision 4 introduced new requirements for authentication strength, identity proofing, and federation security. Many organizations still haven't assessed their systems against these updated standards. Learn what changed, why it matters for compliance, and how to evaluate your current identity controls against the new framework.

PgManage 1.4 – SQL Server Support, Faster Interface Navigation, Spreadsheet‑like Data Grids & More!

PgManage now supports Microsoft SQL Server and includes numerous UI improvements and features intended to make your daily database work more efficient. See the blog post for a feature overview and insights into our decision‑making process.

PostgreSQL Version 13 Reaches End of Life: Migration and Extended Support Strategies

PostgreSQL Version 13 Reaches End of Life: Migration and Extended Support Strategies

PostgreSQL 13 has officially reached end of life as of November 13, 2025, leaving organizations without security patches or community support. Learn your options for upgrading to a supported version—or extending security coverage with PgLTS.

PostgreSQL 18: Revolutionary Performance Boost Now Available

PostgreSQL 18: Revolutionary Performance Boost Now Available

The PostgreSQL Global Development Group has released PostgreSQL 18, delivering the most significant performance improvements in recent years. This latest version transforms database I/O operations and streamlines the upgrade experience for organizations worldwide.