AlloyDB has announced the general availability of PostgreSQL 18 and the introduction of Extended Support for earlier major versions. These updates aim to provide a balance between leveraging the latest database features and maintaining a secure, operational environment for existing workloads.
Ensuring Stability with Extended Support
Transitioning production workloads to a new major version can be a complex task. To facilitate this process, AlloyDB now offers Extended Support, allowing users to upgrade at their own pace without sacrificing security.
This support bridges the gap between community end-of-life (EOL) dates and individual upgrade timelines, ensuring business continuity for critical applications.
Key Timelines for Extended Support
- PostgreSQL 14: February 1, 2027 - February 1, 2030
- PostgreSQL 15: February 1, 2028 - February 1, 2031
- PostgreSQL 16: February 1, 2029 - February 1, 2032
- PostgreSQL 17: February 1, 2030 - February 1, 2033
- PostgreSQL 18: Extended Support timeline to be announced
What's Included in Extended Support
During the Extended Support period, Google Cloud will provide:
- Critical security patches: Protection against high and critical severity vulnerabilities
- Proactive bug fixes: Resolution of issues within AlloyDB-maintained code
- SLA coverage: Availability protection for eligible clusters
- New cluster creation: Provisioning of new clusters on Extended Support versions
Transition Management
Extended Support will incur an additional fee, but users can opt out at any time by upgrading to a major version in regular support. Pricing details will be announced later this year.
Enhancements with PostgreSQL 18
PostgreSQL 18 introduces features aimed at improving application performance and simplifying development:
- B-tree skip scans: Faster queries by bypassing non-matching index entries
- Parallel GIN index usage: Enhanced full-text and JSON search performance
- Virtual generated columns: On-the-fly computed columns without extra disk usage
- Native UUIDv7 support: Improved sortability and indexing efficiency for distributed applications
Real-World Application: UKG's Upgrade
UKG, a provider of HR and payroll solutions, successfully upgraded its AlloyDB clusters to PostgreSQL 17, enhancing its data foundation, People Fabric. The in-place major version upgrades allowed UKG to modernize its system with minimal risk and downtime.
Rajiv Jain, Sr Director of Engineering at UKG, noted that AlloyDB’s upgrade path enabled them to meet their release targets while leveraging new PostgreSQL features effectively.
Optimizing Performance with AlloyDB
AlloyDB enhances PostgreSQL 18's capabilities through a specialized architecture that separates compute from storage. This approach offers several benefits:
- Database-aware offloading: Delegates logging and maintenance tasks to a dedicated service
- Horizontal scaling: Quick addition of read-only replicas without data duplication
- Improved price-performance: Up to 2x better performance compared to self-managed PostgreSQL
- Elastic storage: Automatically adjusts based on data needs
- Predictable throughput: Full performance without storage size limitations
Getting Started
- Create a PostgreSQL 18 instance: Access the AlloyDB console
- Plan your upgrade: Consult the major version upgrade documentation
- Check support dates: Review the Extended Support documentation and version support policy
