About PostgreSQL

PostgreSQL is an open-source relational database management system (RDBMS), which helps businesses store, manage, and scale data workloads, from single machines to data warehouses with multiple concurrent users. Features include materialized views, stored procedures, indexing, multi-factor authentication, full-text search, and event triggers.

The ACID-compliant system lets developers define data types such as numeric, date/time, array, or geometry, build custom functions, and maintain data integrity using exclusion constraints, explicit locks, and primary or foreign keys. Database administrators can utilize SQL to perform multiple data operations such as INSERT, UPDATE, DELETE, and more. Using foreign data wrappers, IT professionals can access external databases or streams for querying.

PostgreSQL maintains a write-ahead log (WAL), which helps developers record file changes and restore databases during system crashes. Administrators can grant role-based objects and column to table level permissions. Developers can also improve query performance on tables by using acceleration partition pruning, automatically invalidate cached execution plans, write background checkpoints, and restrict bandwidth usage for backup processes.

Pricing starting from:

N/A

  • Free Version
  • Free Trial
  • Subscription

Top 5 alternatives to PostgreSQL

Devices

Business size

S M L

Markets

United States

Supported Languages

English

Pricing starting from:

N/A

  • Free Version
  • Free Trial
  • Subscription

Top 5 alternatives to PostgreSQL

Images

PostgreSQL Software - PostgreSQL create database profile
PostgreSQL Software - PostgreSQL backup database
PostgreSQL Software - PostgreSQL SQL operations
View 3 more
PostgreSQL Software - PostgreSQL create database profile
PostgreSQL Software - PostgreSQL backup database
PostgreSQL Software - PostgreSQL SQL operations

Features

Total features of PostgreSQL: 25

  • Access Controls/Permissions
  • Backup and Recovery
  • Configuration Management
  • Data Dictionary Management
  • Data Import/Export
  • Data Migration
  • Data Recovery
  • Data Replication
  • Data Storage Management
  • Data Synchronisation
  • Data Transformation
  • Database Conversion
  • Disaster Recovery
  • Event Logs
  • Full Text Search
  • Monitoring
  • Multiple Programming Languages Supported
  • NOSQL
  • OLAP
  • Performance Analysis
  • Queries
  • Relational
  • Role-Based Permissions
  • Search/Filter
  • Secure Data Storage

Alternatives

MySQL

4.6
#1 Alternative to PostgreSQL
MySQL is a relational database management system (RDBMS) designed to help businesses record, update, and manage data...

Microsoft SQL Server

4.6
#2 Alternative to PostgreSQL
SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured...

MariaDB

4.7
#3 Alternative to PostgreSQL
MariaDB is the database for all, supporting any workload, in any cloud, at any scale. Try MariaDB now.

Oracle Database

4.5
#4 Alternative to PostgreSQL
Oracle Database is a data warehouse software designed to help businesses of all sizes manage data and automate...

Reviews

Overall rating

4.6 /5
(331)
Value for Money
4.7/5
Features
4.6/5
Ease of Use
4.3/5
Customer Support
4.1/5

Already have PostgreSQL?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Write a Review!
Showing 5 reviews of 331
Rafał M.
Overall rating
  • Industry: Management Consulting
  • Company size: Self Employed
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

Postgresql (psql) is a great way to start with "serious" RDBMS

Reviewed on 17/05/2022

Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle...

Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle (including hardware and support). Fast, flexible and with great support of programming languages, with API compatibility helped us to run a full scale retail chain (16 offline stores) with real time stock management in our online store.

Pros

+ scalability
+ SQL compilant
+ security
+ open source (free but not without costs)
+ offers more field types than mysql
+ API compatibility
+ low TCO - cheaper than Oracle (but with similar performance)
+ great programming language support (Python, PHP, C++ etc)

Cons

- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues
- not present at most of hosting services (but you can always run a virtual machine on AWS EC2)
- less tools for data manipulation/analysis compared to MySQL

Verified Reviewer
Overall rating
  • Industry: Logistics & Supply Chain
  • Company size: 201-500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Best open-source RDBMS out there

Reviewed on 06/06/2022

Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database...

Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database for any of the apps we deploy, we use PostgreSQL. It never fails us.

Pros

I like how easy it is to set up and deploy a PostgreSQL database. It has a rich ecosystem of tools and a great open-source community behind it.

Cons

I don't have anything I dislike about PostgreSQL.

Alternatives Considered

MySQL and MariaDB

Reasons for Choosing PostgreSQL

For some tools we deployed, we naturally needed to scale up and handle more complex workloads. So we changed our backend database.

Switched From

SQLite

Reasons for Switching to PostgreSQL

Out of many open-source tools we deploy, PostgreSQL is the most widely supported DB backend among others. So we decided to use PostgreSQL whenever applicable.
Albernes G.
Overall rating
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support

easy to use and understand

Reviewed on 15/03/2018

It can operate on platform specifications, including Linux, Windows, Unix.
Large storage capacity

G...

It can operate on platform specifications, including Linux, Windows, Unix.
Large storage capacity

Good scalability since it is able to adjust to the number of CPU and the amount of available memory optimally, supporting a greater number of simultaneous requests to the database correctly.
It supports the types of data, clauses, functions and commands of standard type SQL92 / SQL99 and extended own of PostgreSQL ..

Pros

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

Cons

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

Vin C.
Overall rating
  • Industry: Information Technology & Services
  • Company size: 2-10 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Fully tried and tested.

Reviewed on 04/04/2022

Really well supported by the open source community.

Really well supported by the open source community.

Pros

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Cons

Cloud pricing tend to be more expensive vs mysql option.

Alternatives Considered

Microsoft SQL Server, MySQL and SQLite

Reasons for Switching to PostgreSQL

Ease of scaling the system, we can easily without too much cost overhead spin up read replicas to increase performance to our clients.
Jonathan alexander C.
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 1,001-5,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

A robust database engine for your web projects and platforms

Reviewed on 25/05/2022

I have used this database to carry out web projects in the health sector and it has been of great...

I have used this database to carry out web projects in the health sector and it has been of great help to manage processes and data in a very efficient way and with the best performance that I have seen.

Pros

What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage

Cons

That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error

Showing 5 reviews of 331 Read all reviews

PostgreSQL FAQs

Below are some frequently asked questions for PostgreSQL.

PostgreSQL offers the following pricing plans:

  • Starting from:
  • Pricing model: Free Version
  • Free Trial: Available

PostgreSQL is available for free.

PostgreSQL has the following typical customers:

Self Employed, 2-10, 11-50, 51-200, 201-500, 501-1,000, 1,001-5,000

PostgreSQL supports the following languages:

English

PostgreSQL supports the following devices:

We do not have any information about what integrations PostgreSQL has

PostgreSQL offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep)

Related categories

See all software categories found for PostgreSQL.