The latest release of Oracle Cloud Infrastructure (OCI) Database with PostgreSQL brings a host of new features that enhance its capabilities, making it an even more compelling choice for enterprise customers looking for open source database solutions. From new version support to advanced security options and improved performance, these updates provide greater flexibility and control for managing PostgreSQL workloads on OCI. Let’s explore these new features in detail.
Version support
In response to customer demand, OCI Database with PostgreSQL will support both versions 13 and 15 later this month in addition to version 14. This expanded version support allows you to run your workloads on the PostgreSQL version that best suits your application requirements, whether you need stability with older versions or want to take advantage of the latest features and improvements in newer versions.
Extensions
One of PostgreSQL’s most attractive features is its extensibility. OCI Database with PostgreSQL is about to offer enhanced extension management, allowing you to easily create, manage, and save extensions in a configuration list for better control. The service adds support for popular extensions, such as pgvector, pg_stat_statements, postgres_fdw, and pglogical. These extensions enable you to take advantage of a wide range of capabilities, from AI and machine (ML) applications with vector databases to geospatial data processing and efficient data integration. You can now use these extensions in limited availability, and they will be generally available soon.
Vertical scaling
Workload demands can change, and with the new vertical scaling feature, OCI Database with PostgreSQL allows you to adjust the compute and memory configuration of their database systems when needed. With this flexibility, the database system is right-sized to meet your current workload needs, optimizing both performance and cost.
Flex shapes
For even greater control over hardware resources, the new flex shapes feature allows you to independently select the number of OCPUs and the amount of memory for your database systems in a granular manner, without being limited by fixed shapes. This feature is ideal for fine-tuning the performance of your database, whether your workload is compute-intensive, memory-intensive, or a mix of both.
Network security groups
Security is paramount, and OCI Database with PostgreSQL now includes support for network security groups (NSGs). NSGs act as virtual firewalls, allowing you to control traffic and access to your cloud resources within a virtual cloud network (VCN). By grouping resources under a common security posture, NSGs simplify the management of network security and enhance data protection.
Key Takeaways
The latest features in OCI Database with PostgreSQL offer you more options, optimized performance, and enhanced security, all while maintaining the ease-of-use and cost-efficiency that OCI is known for. With support for new PostgreSQL versions, a broad array of extensions, flexible scaling options, and robust security measures, this release enables businesses to migrate more of their workloads to OCI and utilize the full potential of PostgreSQL in a managed cloud environment. Whether you’re looking to modernize your database infrastructure or optimize existing applications, Oracle Cloud Infrastructure Database with PostgreSQL provides the open source database tools that you need to succeed.