# Blog > command prompt inc blog ## Recent Posts - [PgManage 1.4 – SQL Server, Fast Database Navigation, Spreadsheet‑like Data Grids & More](https://www.commandprompt.com/blog/pgmanage-14-sql-server-fast-database-navigation-spreadsheet-like-data-grids-more/): PgManage now supports Microsoft SQL Server and has numerous UI improvements and features intended make your daily database work more efficient. - [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. - [Upgrading PostgreSQL and Citus for Enhanced Database Functionality](https://www.commandprompt.com/blog/upgrading-postgresql-and-citus-for-enhanced-database-functionality/): Learn how PostgreSQL and Citus were upgraded from 11/8.3 to 15.5/12.1 with improved performance and scalability in this real-world case study. - [Lessons From The Road: More Intention, Less Autopilot](https://www.commandprompt.com/blog/lessons-from-the-road-more-intention-less-autopilot/): How much of our time is spent on autopilot?Most people can agree that our internal autopilot systems enable us to be efficient and effective. It allows us to d… - [Service Monitoring via Hazard Analysis White Paper](https://www.commandprompt.com/blog/service-monitoring-via-hazard-analysis-white-paper/): Apply hazard analysis and Critical Control Points (CCPs) to IT monitoring. Improve service reliability, reduce costs, and detect issues before they impact users. - [Critical Security Alert: Immediate Action Required for Self-Hosted SharePoint Servers (CVE-2025-53770)](https://www.commandprompt.com/blog/critical-security-alert-immediate-action-required-for-self-hosted-sharepoint-servers-cve-2025-53770/): A critical, newly disclosed, and actively exploited vulnerability, CVE-2025-53770, affects all self-hosted / on-premises Microsoft SharePoint Server versions. … - [Lessons from the Road: What actually matters](https://www.commandprompt.com/blog/lessons-from-the-road-what-actually-matters/): Amanda Nystrom explores the profound question of what truly matters in life, prompted by the final words of her sister‑in‑law. What legacy do you want when it’s time to say your last words? - [Part 6: Prevention and Monitoring Strategies](https://www.commandprompt.com/blog/part-6-prevention-and-monitoring-strategies/): Avoid PostgreSQL downtime from autovacuum issues. Learn how to prevent failures caused by temp tables and proactively monitor your cluster’s health. Includes diagnostic query and white paper. - [Lessons from the Road: Gratitude](https://www.commandprompt.com/blog/lessons-from-the-road-gratitude/): I was on the phone with one of my most active clients at Command Prompt when I had to interrupt the call because my dogs somehow opened the bus door and went r… - [Part 5: Temp Tables and XID Wraparound in Single-DB Clusters](https://www.commandprompt.com/blog/part-5-temp-tables-and-xid-wraparound-in-single-db-clusters/): Learn how lingering temp tables in PostgreSQL can trigger shutdowns from XID wraparound, and what steps to take to prevent downtime in your database environment. - [Lessons from the Road: Know your footprint](https://www.commandprompt.com/blog/lessons-from-the-road-know-your-footprint/): Discover how life on the road revealed hidden waste habits and how small, mindful changes can make a big impact on your environmental footprint. - [Part 4: Debugging Limitations in RDS and Cloud Environments](https://www.commandprompt.com/blog/part-4-debugging-limitations-in-rds-and-cloud-environments/): Part 4 of our PostgreSQL Autovacuum Failure Series explores how session-level temp tables in RDS can silently stall autovacuum—and how we resolved it. Learn wh… - [PgManage 1.3 Release: Powerful New Features and Enhanced Usability](https://www.commandprompt.com/blog/pgmanage-13-release-powerful-new-features-and-enhanced-usability/): Explore what's new in PgManage 1.3, including improved dashboards, JSON export, PostgreSQL 17 support, and performance upgrades. Read the full release notes. - [Part 3: Why Autovacuum Stops — PostgreSQL Internal Mechanics Explained](https://www.commandprompt.com/blog/part-3-why-autovacuum-stops-postgresql-internal-mechanics-explained/): Series Summary: This is Part 3 of a multi-part series on PostgreSQL autovacuum failures.In Part 2, we reproduced the autovacuum failure issue — now let’s under… - [Lessons from the Road: The weight of consumerism](https://www.commandprompt.com/blog/lessons-from-the-road-the-weight-of-consumerism/): How many things do you own? How many things are you responsible for?Every thing we have comes with a cost beyond the purchase price. From maintenance to cleani… - [Part 2: Reproducing and Diagnosing Autovacuum Failures](https://www.commandprompt.com/blog/part-2-reproducing-and-diagnosing-autovacuum-failures/): Series Summary: This is Part 2 of a multi-part series on PostgreSQL autovacuum failures.In Part 1, we introduced the scenario where autovacuum mysteriously hal… --- [View this page online](https://www.commandprompt.com/blog/)