# Blog > command prompt inc blog ## Recent Posts - [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.” - [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… - [PostgreSQL 18: Revolutionary Performance Boost Now Available](https://www.commandprompt.com/blog/postgresql-18-revolutionary-performance-boost-now-available/): PostgreSQL 18 delivers revolutionary 3x I/O performance improvements, seamless upgrades with preserved statistics, OAuth 2.0 support, and virtual generated columns. Feature guide and upgrade recommendations. - [Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations on AWS](https://www.commandprompt.com/blog/why-growing-teams-are-moving-from-aurora-to-rds-or-ec2-cost-and-control-considerations-on-aws/): Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations for PostgreSQL on AWS - [PgManage 1.3.1: Enterprise Edition Released](https://www.commandprompt.com/blog/pgmanage-131-enterprise-edition-released/): PgManage 1.3.1 is now available with fixes across PostgreSQL, Oracle, MariaDB, and SQLite3, plus updated dependencies and UI refinements. Learn what’s new and explore PgManage Enterprise Edition with remote access, multi-user support, and OAuth2 integration. - [Lessons from the CISA and USCG Joint Advisory: What “No Breach” Still Reveals](https://www.commandprompt.com/blog/lessons-from-the-cisa-and-uscg-joint-advisory-what-no-breach-still-reveals/): CISA & USCG’s AA25-212A advisory highlights systemic security gaps. No breach doesn’t mean no risk—resilience requires proactive hardening. --- [View this page online](https://www.commandprompt.com/blog/)