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.

OCI Database with PostgreSQL Introduction (5:09)

Why OCI Database with PostgreSQL?

60%

Less costly with PostgreSQL1

3X

Faster than a self-managed cluster2

99.99%

Availability SLA


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.



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.

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.
November 14, 2023

Introducing OCI Database with PostgreSQL: Completing Our Cloud Database Suite for Every Need

Julien Lehmann, Product Marketing Director, Oracle Modern Data Platform
George Csaba, Principal Product Manager

With a history of over 35 years, PostgreSQL has developed a strong following in the open source community, being used for a wide variety of applications. As OCI continues its growth, our customers are asking us to support PostgreSQL. We are happy to announce the General Availability of Oracle Cloud Infrastructure (OCI) Database with PostgreSQL version 14.9. This addition complements our existing lineup of open-source offerings on OCI, joining other services including OCI Cache with Redis, OCI Search with OpenSearch, and MySQL HeatWave.

Get started with Database with PostgreSQL

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?