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 than Amazon Aurora with PostgreSQL1

3X

Faster than a self-managed cluster2

99.99%

Availability SLA

Price/performance ratio

60% less expensive1 than Amazon Aurora and up to three times the performance2 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.

Learn more about OCI Database with PostgreSQL

1. Price comparison based on 2 VCPUs having comparable performance to 1 OCPU. AWS pricing data sourced from AWS US East Region price list as of October 23, 2023. Comparison based on available OCI shapes equivalent to AWS shapes, with a storage capacity of 500 GB and a VPU setting of 50.

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

PostgreSQL is more affordable on OCI

OCI Database with PostgreSQL is half the price of Amazon Aurora and Google AlloyDB.

Pricing comparison chart, description below

Region: US East

Hours: 720

Small Medium Large
4 vCPU, 32 GB RAM, 500 GB Storage Price/mo Cost comparison with OCI 32 vCPU, 256 GB RAM, 1TB Storage Price/mo Cost comparison with OCI 64 vCPU, 512 GB RAM, 3TB Storage Price/mo Cost comparison with OCI
OCI DB with PostgreSQL PostgreSQL.VM.Standard.Flex.E4.2.32GB $273.18 PostgreSQL.VM.Standard.E4.Flex.16.256GB $1,816.44 PostgreSQL.VM.Standard.Flex.E4.32.512GB $3,755.88
Amazon Aurora db.r5.xlarge $511.93 1.87 db.r5.8xlarge $3,791.73 2.1 db.r6gd.16xlarge $8,189.81 2.2
Google AlloyDB auto-config $605.56 2.2 auto-config $3,937.64 2.2 auto-config $8,174.24 2.2

Note: Average price comparison done for a small, medium, and large cluster with 4, 32, and 64 vCPU using public pricing in AWS US-East and in Google US-East 4 on June 10, 2024 based on 2 VCPUs having comparable performance to 1 OCPU.

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.

OCI Database with PostgreSQL release new features

Mike Sorola, Senior Product Manager, Data and AI Services
Karan Singh, Director Product Management, Data and AI
Julien Lehmann, Product Marketing Director, Oracle Modern Data Platform

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 post

Featured blogs

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?