Softwr
Postgres logo

Postgres

The world's most advanced open source database

Overview

What Postgres does

PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development. It has earned a strong reputation for reliability, feature robustness, and performance.

What people use it for

  • Running a general purpose relational database for applications
  • Self-hosting an open source SQL database with no licence fee
  • Workloads needing extensions, JSON and full text search in one engine

The honest half

Where it falls short

Concrete and checkable, so you can decide whether any of them matter to you. This is the half of a review a vendor will not write about Postgres.

  • Each major version is supported for only 5 years after its initial release, after which it is end-of-life
  • Major version upgrades break on-disk compatibility and require a full dump and reload or the pg_upgrade tool
  • New major versions ship about once a year, so staying supported means a disruptive upgrade cycle
  • Minor releases contain only frequently-encountered bug fixes, low-risk fixes, security issues and data corruption fixes, so feature gaps are not addressed within a major version
  • There is no vendor SLA; commercial support must be bought separately from third party professional services listed by the project

Pricing

What Postgres costs

Taken from the vendor's own pricing page. Prices move, so check before you buy.

Community Edition

Free

  • Full database features
  • No limitations
  • Community support
  • All extensions available
  • Complete source code

Capabilities

Features

  • ACID compliance

    ACID compliance capability

  • Complex queries

    Complex queries capability

  • Foreign keys

    Foreign keys capability

  • Triggers

    Triggers capability

  • Views

    Views capability

  • Stored procedures

    Stored procedures capability

  • JSON/JSONB support

    JSON/JSONB support capability

  • Full-text search

    Full-text search capability

  • Python

    Integration with Python

  • Java

    Integration with Java

  • Node.js

    Integration with Node.js

  • Ruby

    Integration with Ruby

Behind it

Who makes Postgres

Company
PostgreSQL Global Development Group
Based in
Open Source Project

Keep looking

Where to go from Postgres

Other Technology software

  • Manage your team's work, projects, & tasks online

  • The issue tracking tool you'll enjoy using

  • The collaborative interface design tool

  • A platform built for a new way of working

Softwr does not host reviews and shows no star rating for Postgres, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.

More on Postgres

Best Technology software alternatives

Comprehensive IT monitoring, open and flexible

Manage your team's work, projects, & tasks online

The digital analytics platform to understand your users

A multi-language engine for data engineering, data science, and machine learning

The CRM built for the next generation of companies

Roadmapping software for product builders

Open-source software for reliable, scalable, distributed computing

Secure access for everyone

Compare Postgres with alternatives