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.


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

Not sure about PostgreSQL? Compare with a popular alternative

PostgreSQL

4,6 (410)
VS.
Highly reviewed

Starting Price

No pricing found
No pricing found

Pricing Options

Free version
Free trial
Free version
Free trial

Features

22
132

Integrations

No integrations found
No integrations found

Ease of Use

4,3 (410)
3,9 (497)

Value for Money

4,6 (410)
4,0 (497)

Customer Service

4,1 (410)
4,1 (497)
Green rating bars show the winning product based on the average rating and number of reviews.

Alternatives

ArcGIS

4,6
#1 Alternative to PostgreSQL
ArcGIS by Esri is an integrated suite of geographic information system (GIS) software, providing a compliant platform...

Microsoft Access

4,4
#2 Alternative to PostgreSQL
Microsoft Access is a database management system that provides intuitive application development tools to create...

Amazon Aurora

4,6
#3 Alternative to PostgreSQL
Built for the cloud, Aurora is a relational database management system that helps businesses manage, migrate and run...

DBeaver

4,5
#4 Alternative to PostgreSQL
DBeaver is a database management software that helps organizations store and retrieves business data in a structured...

Reviews

Overall rating

4,6 /5
(410)
Value for Money
4,6/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.

Showing 5 reviews of 410
Nairoby
Nairoby
Overall rating
  • Used Daily for 2+ years
  • Review Source

Overall rating

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

It's free!

Reviewed on 2018/07/31

In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it...

In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it

Pros

- Free code database manager, which is not used for licensing.
- Easy to install and configure in any operating system.
- Ideal for relational databases.
- It has a large community in which you can share doubts.
- It is stable and reliable, scalable and secure with the correct user management.
- Can work with small and large databases.
- Handles the SQL language.
- Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards.
- Easily works as a cluster, can be configured as active-passive or active-active which improves performance
- It allows to perform maintenance, recovery of databases.
- I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems.
- Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.

Cons

- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is.
- For some, not having support online or with an official help center can be a big disadvantage.
- It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

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 2022/06/06

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.
Pedro
Pedro
Overall rating
  • Industry: Computer Software
  • Company size: 2–10 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 6.0 /10

database alternative to mysql

Reviewed on 2019/09/26

it's a really good database manager, easy to use and the community version is free to use in a...

it's a really good database manager, easy to use and the community version is free to use in a commercial environment

Pros

in general is a good database manager like MySQL you have many functions and one, in particular, the notifications, you can send a notify and it's like a broadcast message, useful for interaction with the backend

Cons

the way how to backup and restore is sometimes complicated, we tried to automatized and sometimes works others not, the same script! and because of that, you can have an empty DB

Verified Reviewer
Overall rating
  • Industry: Computer Software
  • Company size: 201–500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

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

The right database for 95% of use cases

Reviewed on 2020/05/01

Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether...

Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search.

Pros

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data.
- Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time.
- The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned).
- Newer versions even has support for advanced use cases such as arrays and JSON objects.
- The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

Cons

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

Alternatives Considered

MongoDB and MySQL

Reasons for Switching to PostgreSQL

I picked Postgres over MySQL is not as battle tested and was behind Postgres in terms of JSON object support. I picked Postgres over MongoDB because it's easier to set up, didn't have anyone else on the team that knew how to use it (whereas all 5 of my teammates have Postgres experience), and because Postgres can handle our traffic currently.
Verified Reviewer
Overall rating
  • Industry: Computer Software
  • Company size: 501–1 000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

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

Java developer on PostgreSQL. A look back after several years.

Reviewed on 2022/07/16

I have been using PostgreSQL for 6 years in most of the applications I write. It is my default...

I have been using PostgreSQL for 6 years in most of the applications I write. It is my default choice for a relational database.

Pros

PostgreSQL is a database that every programmer is familiar with. I value its versatility and universality. It's easy to implement it production-wise with not much scale.

Cons

Great for simple applications, when it comes to scaling/replication problems begin.

Alternatives Considered

MongoDB

Reasons for Choosing PostgreSQL

I changed jobs and the new job used PostgreSQL.

Switched From

MySQL

Reasons for Switching to PostgreSQL

PostgreSQL was easier to learn for most team members.
Showing 5 reviews of 410 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.