Database with PostgreSQL

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.

Migrate an On-premises PostgreSQL database to OCI PostgreSQL (8:03)

Why OCI Database with PostgreSQL?

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.

Database with PostgreSQL customers successes

How OCI Database with PostgreSQL works

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.

How OCI Database with PostgreSQL works diagram, description below

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.

  1. 1. Users Section:
    • Contains two icons: One of a person labeled "User" and another that looks like interconnected blocks labeled "API service".
    • Beneath it, a caption reads: "End users initiate requests for data through the application interface."
  2. 2. Application Section:
    • Contains three icons: A box filled with smaller boxes labeled "Container", a simple box with features that make it resemble a computer screen labeled "Virtual machine", and a gear icon labeled "Application".
    • Caption below mentions: "The application processes incoming requests and facilitates the flow of data between users and the back end."
  3. 3. Back end Section:
    • Showcases a database icon with the label "OCI Database with PostgreSQL".
    • Below it, there's a dotted box titled "Ideal for" with four icons inside: One that represents "OLTP", another for "Spatial", another for "OLAP" and a fourth for "Vector".
  4. 4. Three Key Points on the right side of the image:
    • Fully managed: Text says, "Spend less time managing PostgreSQL and infrastructure and more time developing and running modern applications."
    • Instantaneous failover: Describes an architecture with near instant failover capability decoupled from compute.
    • Fully compatible with PostgreSQL: Emphasizes 100% compatibility allowing easy migration and immediate service usage.

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.

Explore the OCI Database with PostgreSQL cloud architecture

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.

Read the blog

Explore the OCI Database with PostgreSQL cloud architecture

OCI’s unique disaggregated storage architecture with Database Optimized Storage

  • Optimized workloads: Compute nodes focus on database tasks such as query processing and optimization. The storage nodes also have low-level optimizations that greatly improve transaction rate while reducing latency.
  • Enhanced reliability: Independent failure of compute or storage nodes ensures data safety. Even if a compute machine fails, data remains secure in the storage cluster.
  • Quick recovery: In a multi-node database system, if the primary node becomes unreachable, another node would be promoted as the primary node and connect to the existing storage without data loss.
  • Scalability: Decoupling compute and storage paves the way for independent scaling, accommodating varied demands and growth.
February 4, 2025

Powering of OCI Database for PostgreSQL with New Extensions

Rashmi Badan, Product Manager, Oracle
Julien Lehmann, Product Marketing Director, Oracle Modern Data Platform

In today’s rapidly evolving data landscape, the demand for versatile, scalable, and high performance database solutions is more significant than ever. Celebrated as one of the most advanced open source databases, PostgreSQL powers countless modern applications, from analytics platforms to AI-driven solutions. We’re thrilled to announce the launch of a new suite of extensions that redefine what’s possible with PostgreSQL on Oracle Cloud Infrastructure (OCI) and the new extension manager to deploy them securely.

Featured blogs

Get started with Database with PostgreSQL

Learn with a hands-on lab

The 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.

Learn with step-by-step how-tos

Follow these step-by-step tutorials to make the most of Oracle Cloud Infrastructure services.

Try 20+ Always Free cloud services, with a 30-day trial for even more

Oracle 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.

  • What’s included with Oracle Cloud Free Tier?

    • 2 Autonomous Databases, 20 GB each
    • AMD and Arm Compute VMs
    • 200 GB total block storage
    • 10 GB object storage
    • 10 TB outbound data transfer per month
    • 10+ more Always Free services
    • US$300 in free credits for 30 days for even more

Contact sales

Interested in learning more about Oracle Cloud Infrastructure? Let one of our experts help.

  • They can answer questions like:

    • What workloads run best on OCI?
    • How do I get the most out of my overall Oracle investments?
    • How does OCI compare to other cloud computing providers?
    • How can OCI support your IaaS and PaaS goals?