WORKLOAD AUTOMATION COMMUNITY
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
  • About
  • Contact
  • What's new

PostgreSQL Performance Analysis: HWA 10.2.4 vs 10.2.3 Comprehensive Comparison

6/3/2025

0 Comments

 
Picture
​This analysis presents the first comprehensive performance comparison of HWA (Workload Automation) running on PostgreSQL database, comparing versions 10.2.3 and 10.2.4 to demonstrate the evolution and optimization achieved in the latest release.
Executive Summary
- HWA 10.2.4 with PostgreSQL shows significant improvements in scheduling performance
- Enhanced workload handling capability with 43% increase in job volume (400K vs 280K jobs)
- Improved response times during peak loads while maintaining consistent throughput
- Stable critical operations performance across both versions

Test Environment Configuration
Both tests maintained consistent infrastructure for reliable comparison:

Common Configuration:
- Infrastructure: VMware 6 + RHEL Server 9.4
- Workload Distribution: Large PVT daily production plan
- Peak Load Pattern: 10K jobs scheduled in 10-minute bursts
- Extended Load: 600 jobs/min sustained workload
- Workstations: 17 workstations, 3,200+ job streams

Version-Specific Details:
- 10.2.4: Build 20240413, PostgreSQL 16.4, WebSphere Liberty 25.0.0.3, 400K+ jobs
- 10.2.3: Build 20241120, PostgreSQL 16.4, WebSphere Liberty 24.0.0.9, 280K+ jobs

Performance Metrics Comparison

🚀 Peak Load Performance Analysis
Picture
⚡ Extended Load Performance (18:00-23:00)
Picture
🔧 Critical Operations Performance
Picture
Performance Analysis Deep Dive

Major Improvements in 10.2.4
🎯 Enhanced Job Processing Efficiency: Despite handling 43% more jobs (400K vs 280K), HWA 10.2.4 demonstrates:
  • 31% faster schedule delays during peak loads (18s vs 26s)
  • 44% improvement in mirroring delays during peak loads (20s vs 36s)
  • Consistent throughput of 953 jobs/min maintained despite increased workload

⚡ Optimized Response Times: The significant reduction in both scheduling and mirroring delays indicates substantial optimization in the core workload automation engine.

🔧 Stable Critical Operations: Both MAKEPLAN and CHECKSYNC operations maintain identical performance (28s and 65s respectively), demonstrating stable foundational operations.

Resource Utilization Trade-offs

📈 Expected Resource Increase: The higher resource utilization in 10.2.4 is proportional and exceptionally well-optimized:
  • 43% more jobs processed with only 11% CPU increase (MDM), 6% CPU increase (PostgreSQL), 9% disk increase (MDM), and 8% disk increase (PostgreSQL)
  • Resource efficiency ratio dramatically improved: significantly more work with minimal resource increases across all metrics
  • All resource utilization increases are very reasonable given the substantially larger workload

💡 Efficiency Gains: When normalized for workload size, 10.2.4 shows exceptional resource efficiency:
  • Jobs per CPU unit: 10.2.4 processes significantly more jobs per percentage of CPU used
  • Jobs per disk I/O unit: Improved I/O efficiency with more jobs processed per disk utilization percentage
  • Response time improvement: Faster processing despite substantially larger workload

PostgreSQL-Specific Insights

Database Performance Characteristics
​

🗃️ PostgreSQL 16.4 Platform Stability: Both versions running on the same PostgreSQL 16.4 platform demonstrate:
  • Pure HWA optimization effects without database platform variables
  • Consistent database performance baseline across both tests
  • Application-level improvements clearly isolated and measurable
  • PostgreSQL 16.4 capabilities fully utilized in both versions

Version Compatibility
📦 PostgreSQL Version Consistency:
  • 10.2.3: PostgreSQL 16.4
  • 10.2.4: PostgreSQL 16.4 (same version)
  • Consistent database platform isolating HWA application improvements
  • Pure application optimization effects clearly demonstrated

Recommendations

For Production Deployment
✅ Strongly Recommended: HWA 10.2.4 with PostgreSQL for:
  • High-volume production environments requiring 400K+ daily jobs
  • Performance-critical workloads needing fast scheduling responses
  • PostgreSQL-based infrastructures seeking optimal integration

Capacity Planning
📊 Resource Planning Guidelines:
  • CPU: Plan for ~41% MDM CPU and ~26% PostgreSQL CPU for 400K+ job workloads
  • Disk I/O: Ensure sufficient I/O capacity for ~64% MDM and ~70% PostgreSQL disk utilization
  • Throughput: Expect consistent 953 jobs/min peak throughput capability

Migration Strategy
🔄 Upgrade Path:
  • Pure HWA application upgrade from 10.2.3 to 10.2.4 with consistent PostgreSQL 16.4
  • Database platform stability ensuring performance comparisons reflect only application improvements
  • Clear optimization benefits from HWA application enhancements

Conclusion

HWA 10.2.4 with PostgreSQL delivers exceptional performance improvements while handling significantly larger workloads. The 31% improvement in schedule delays and 44% improvement in mirroring delays during peak loads, combined with the ability to process 43% more jobs, makes it the clear choice for enterprise PostgreSQL deployments.

The significant performance improvements can be attributed directly to HWA 10.2.4 application optimizations, with both versions running on the same PostgreSQL 16.4 platform. This provides a clear demonstration of the application-level enhancements without database platform variables.
​
PostgreSQL 16.4 serves as an excellent stable database backend for both HWA versions, with the performance gains in 10.2.4 clearly demonstrating the superior application optimizations and enhanced scaling characteristics for enterprise workload automation.

​Analysis based on comprehensive testing with 280K-400K job workloads on consistent PostgreSQL 16.4 platform
Picture

​Alessandro Tomasi
Senior Technical Lead
Alessandro is a Software Engineer. He has an academic background in Computer Engineering,
in particular in technology customer support and automation testing

Picture

Marco Gangemi
Software Engineer
Marco comes from an academic background in Physics. He joined HCL in 2018.
​Since then, he has specialized in DevSecOps activities. He’s recently started on Performance tests.

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    June 2025
    May 2025
    March 2025
    February 2025
    January 2025
    December 2024
    November 2024
    October 2024
    September 2024
    August 2024
    July 2024
    June 2024
    May 2024
    April 2024
    March 2024
    February 2024
    January 2024
    October 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Analytics
    Azure
    Business Applications
    Cloud
    Data Storage
    DevOps
    Monitoring & Reporting

    RSS Feed

www.hcltechsw.com
About HCL Software 
HCL Software is a division of HCL Technologies (HCL) that operates its primary software business. It develops, markets, sells, and supports over 20 product families in the areas of DevSecOps, Automation, Digital Solutions, Data Management, Marketing and Commerce, and Mainframes. HCL Software has offices and labs around the world to serve thousands of customers. Its mission is to drive ultimate customer success with their IT investments through relentless innovation of its products. For more information, To know more  please visit www.hcltechsw.com.  Copyright © 2024 HCL Technologies Limited
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
  • About
  • Contact
  • What's new