Anytime. Anywhere. Since 1997.
2026-09-17
pgColumnar 1.0-alpha4 release notes
Release date: 2026-09-17 Previous release: 1.0-alpha3 (2026-09-02)
pgColumnar is a columnar table access method for PostgreSQL. This is the fourth alpha. Its theme is layout and skipping. A table can now be laid out on the Hilbert curve, which keeps neighbouring keys closer together than Z-order does. A star-schema join now skips fact-table groups and rejects non-matching rows, and it does …
PostgreSQL’s long-standing recommendation to allocate 25% of system memory to shared_buffers dates back to version 8.3 (released in 2008) when typical system memory was measured in a handful of GB. Modern servers can provision hundreds of GB, and it is not unheard of to come across databases that approach 0.5 TB of RAM or more. The relationship between memory size, workload characteristics and buffer_pool performance is no longer obvious.
We …
Version 19: 71 commits on REL_19_STABLE. Version 20: 46 commits on master. Reverted out of 19: 74 commits, in 6 reverts. Six features tracked, 2 still shipping. Window closed at d8408e8d682.
71 commits landed on the 19 branch in nine days. The six reverts in the same window name 74 commits between them.
Six reverts, newest first.
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.
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 …
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 …
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 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 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.
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.