Oracle’s innovative managed PostgreSQL service, OCI Database with PostgreSQL, combines cutting-edge open source technology with the robustness and speed of Oracle Cloud Infrastructure (OCI). Oracle harnesses the strengths of both to offer higher performance with OCI Database Optimized Storage.
Oracle is the only cloud provider that runs entirely on its own cloud (infrastructure, database, and applications cloud).
60%
Less costly
3X
Faster than a self-managed cluster1
99.99%
Availability SLA
Price/performance ratio
60% less expensive and up to three times the performance of a standard PostgreSQL deployment thanks to its unique Database Optimized Storage.
Versatile and extensible
Features a unique combination of RDBMS and non-relational operations as well as extensions that can turn it into a geospatial database, a time series database, or even a vector database for generative AI.
Fully managed
Streamlines database scaling and maintenance, offering easy setup and automated management in a simplified, efficient service.
1. Performance comparison between same configurations for OCI Database with PostgreSQL and unmanaged standard PostgreSQL on OCI. Architecture is based in mixed workload on a primary using 6 Nodes with 16 OCPU, 256GB RAM and VM.Standard.E4.Flex shape and PostgreSQL version: 14.9.
Version 15 is now available with OCI Database with PostgreSQL.
OCI Database with PostgreSQL is a top-tier managed service that frees up your team from routine tasks, such as patching and backups. Its standout feature is OCI Database Optimized Storage, which boosts system resilience and performance. Additionally, this architecture allows for independent scalability of compute and storage. OCI Database with PostgreSQL also provides enhanced data security with end-to-end encryption.
The image is an infographic showing a workflow from users to application to backend. Users interact with an API service, which connects to an application running on containers or virtual machines. The application then interfaces with the backend, specifically the OCI Database with PostgreSQL, which is suited for OLTP, Spatial, OLAP or Vector workloads. Key benefits highlighted include a fully managed service, instantaneous failover for high availability, and full compatibility with PostgreSQL for easy migration and immediate use.
The image provides an organized and visual representation of how users interact with an application and how the data flows to the back-end OCI Database with PostgreSQL.
Watch Chief Technical Architect Pradeep Vincent walk through the OCI Database with PostgreSQL cloud architecture and how it brings high performance, zero RPO, and efficiency to enterprise workloads.
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.
Read the complete postThe best way to learn is to try it yourself. Use our tutorials and hands-on labs with Oracle Cloud Free Tier, in your own Oracle Cloud tenancy, or, for selected solutions, in an Oracle-provided free lab environment.
Create a generative AI/hybrid search web application using Terraform, and search through unstructured content such as images or audio files.
Start the lab about Hybrid Search with PostgreSQLFollow these step-by-step tutorials to make the most of Oracle Cloud Infrastructure services.
Learn how to deploy three nodes of an OCI managed PostgreSQL database system in an OCI cloud tenancy and connect privately through a compute instance using Terraform script.
See the tutorial about Deploy OCI Managed Database with PostgreSQL Service Using TerraformDiscover how to migrate the database by migrating data via pg_dump from one major version of on-premises PostgreSQL and reloading it in another OCI database.
See the tutorial about Migrate Data from an On-Premises PostgreSQL Database to OCI Database with PostgreSQLSee why pgAdmin4 is a useful tool for carrying out routine database management tasks with PostgreSQL.
See the tutorial about Connect pgAdmin 4 to OCI Database with PostgreSQL Using a Private EndpointCreate, schedule, and restore from an OCI Database with PostgreSQL backup.
See the tutorial about Back Up and Restore an OCI Database with PostgreSQLConnect OCI Database with PostgreSQL to Oracle Analytics Cloud.
See the tutorial about Connect to Oracle Cloud Infrastructure Database with PostgreSQL Using Oracle Analytics CloudExplore how to connect to OCI Database with PostgreSQL using a database administration tool such as DBeaver.
See the tutorial about Connect to Oracle Cloud Infrastructure Database with PostgreSQL Using DBeaverLearn how the OCI Email Delivery service is employed to streamline email sending and enhance automation and reliability in email dispatch processes.
See the tutorial about Integrate OCI Email Delivery Service with OCI Functions, OCI Object Storage, OCI Vault, and OCI Database with PostgreSQLOracle offers a Free Tier with no time limits on more than 20 services such as Autonomous Database, Arm Compute, and Storage, as well as US$300 in free credits to try additional cloud services. Get the details and sign up for your free account today.
Interested in learning more about Oracle Cloud Infrastructure? Let one of our experts help.