# Blog > command prompt inc blog ## Recent Posts - [pgColumnar 1.0-alpha4 released](https://www.commandprompt.com/blog/pgcolumnar-10-alpha4-released/): pgColumnar is a columnar storage table access method for PostgreSQL, written as a clean-room, MIT-licensed implementation. It reads and writes its own native format, PGCN v1, and supports chunk-group skipping from zone maps, bloom filters and star-schema join runtime filters, vectorized aggregation, projections, Z-order and Hilbert clustering, retention, online compaction and reclustering, parallel bulk ingest and export, Apache Arrow and Parquet import and export, Apache Iceberg, and object storage. - [Part 3 Beyond Throughput: Efficiency Metrics for Cost-Aware PostgreSQL Tuning](https://www.commandprompt.com/blog/postgresql-efficiency-cost-optimization/): Optimize PostgreSQL for cost, not just speed. Explore how shared_buffers tuning can trade memory, disk I/O, and CPU to reduce infrastructure spend. - [PostgreSQL 19: Sept 08 - Sept 16, 2026](https://www.commandprompt.com/blog/postgresql-19-sept-08-sept-16-2026/): PostgreSQL release watch, September 8 to 16, 2026. Six reverts on the version 19 branch named 74 commits, among them online data checksums and FOR PORTION OF. - [Two features just left PostgreSQL 19.](https://www.commandprompt.com/blog/two-features-just-left-postgresql-19/): On September 7, SQL/PGQ property graphs were reverted. That removed 47 commits: the feature and every fix built on it since. On August 27, ALTER TABLE … MERGE/SPLIT PARTITION was reverted, removing 14 more. The reason is in the commit message: “multiple design issues which are too late to address in this release cycle.” - [PostgreSQL 14 End of Life: What Are Your Options?](https://www.commandprompt.com/blog/postgresql-14-end-of-life-what-are-your-options/): PostgreSQL 14 reaches community end of life on November 12th, 2026. This post covers what EOL actually means and what your options are. - [When huge_pages Help: Using PSI to Find Bottlenecks Before You Decide](https://www.commandprompt.com/blog/when-to-use-huge-pages-postgresql/): 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](https://www.commandprompt.com/blog/pgcolumnar-10alpha2-released/): Release date: 2026-08-18Previous release: 1.0-alpha (2026-08-04)GithubChangelogpgColumnar is a columnar table access method for PostgreSQL. This is the second … - [Parquet and Iceberg: An Overview](https://www.commandprompt.com/blog/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:… - [Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL](https://www.commandprompt.com/blog/shared-buffers-large-memory-postgresql-part-1/): 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. - [The Architect](https://www.commandprompt.com/blog/the-architect/): Examine your own work honestly. Which job are you doing? If everything you contributed last quarter could be described as construction, start climbing. Learn t… - [Romancing the Claude](https://www.commandprompt.com/blog/romancing-the-claude/): He was very tall in a way that seemed apologetic, as if he had been issued the height by mistake and was still trying to give it back. He had a laugh he did no… - [Your company is not AI ready](https://www.commandprompt.com/blog/your-company-is-not-ai-ready/): The engineers (myself included) stood on the rooftops and shouted, "People! My dear sheep of the earth, please let me save you from yourselves! Do not buy what… - [Direct AI effectiveness: plx example](https://www.commandprompt.com/blog/direct-ai-effectiveness-plx-example/): AI as used by an experienced person with domain knowledge is like having another 5 experienced people doing exactly what you need them to do with minimal inter… - [When a 18TB backup just stopped](https://www.commandprompt.com/blog/when-a-18tb-backup-just-stopped/): 18TB backup just stopped. We fixed it through depth of knowledge. - [Is Trust Gone? Supply Chain Attacks](https://www.commandprompt.com/blog/is-trust-gone-supply-chain-attacks/): Is Trust Gone? Has the supply chain attacks eroded the trust we have in public repositories - [What If Your Team’s Biggest Burnout Driver Lives in Your Database?](https://www.commandprompt.com/blog/what-if-your-teams-biggest-burnout-driver-lives-in-your-database/): Recurring PostgreSQL and infrastructure issues—not the on-call rotation—are often the real cause of burnout. Learn how proactive database care reduces emergencies and protects your team. - [Why You Should Review Your Authentication Strategy](https://www.commandprompt.com/blog/why-you-should-review-your-authentication-strategy/): NIST updated digital identity standards in July 2025. Has your organization assessed authentication and identity proofing against SP 800-63-4 requirements? - [PgManage 1.4 – SQL Server Support, Faster Interface Navigation, Spreadsheet‑like Data Grids & More!](https://www.commandprompt.com/blog/pgmanage-14-fast-intuitive-with-sql-server-support/): Discover PgManage 1.4’s new SQL Server support, faster navigation with pinned databases and Quick Search, spreadsheet‑style data grids, and revamped context menus for smoother UX. - [PostgreSQL Version 13 Reaches End of Life: Migration and Extended Support Strategies](https://www.commandprompt.com/blog/postgresql-version-13-reaches-end-of-life-migration-and-extended-support-strategies/): PostgreSQL 13 reached EOL on Nov 13, 2025. No more security fixes or patches. Learn how to upgrade safely or maintain protection with PgLTS extended support. - [Cost Optimization for PostgreSQL: Practical Tips for Technical Teams](https://www.commandprompt.com/blog/cost-optimization-for-postgresql-practical-tips-for-technical-teams/): In a previous post, we explored the importance of right-sizing PostgreSQL environments and avoiding the trap of overprovisioning for peak demand. While archite… --- [View this page online](https://www.commandprompt.com/blog/)