App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

PostgreSQL Logo

Write a review

Open source relational database management system

(5)

GetApp offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links. Learn more

PostgreSQL Features

Features Summary

Functionality

4.6

/5

410

Total features

22

2 categories

PostgreSQL features

Access Controls/Permissions
Backup and Recovery
Configuration Management
Data Dictionary Management
Data Import/Export
Data Migration
Data Replication
Data Retrieval

Common features of Database software

API
Access Controls/Permissions
Activity Dashboard
Ad hoc Query
Audit Management
Authentication
Automatic Backup
Backup and Recovery

Price starts from

0.01

One-time payment

Pricing options
Free plan
Subscription
Free trial

Screenshots

Contenders comparison

Functionality

4.6

/5

410

Price starts from

0.01

One-time payment

Total Features

22

Unique features

  • Disaster Recovery

  • Data Retrieval

  • OLAP

  • NOSQL Database Management

Functionality

4.6

/5

1.9K

Price starts from

13748

One-time payment

Total Features

29

Features in Common

10

Unique features

  • Data Verification

  • Performance Metrics

  • Visual Analytics

  • Benchmarking

Functionality

4.6

/5

1.8K

Price starts from

ic-pricetag

No pricing info

Total Features

107

Features in Common

16

Unique features

  • Workflow Configuration

  • Multi-Language

  • Performance Monitoring

  • Data Virtualization

Common PostgreSQL comparisons

Reviewers who mentioned features said:

AvatarImg
AvatarImg

Nairoby D.

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

It's free!

Reviewed 6 years ago

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

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

OD
AvatarImg

Osman D.

Computer Software, 1,001-5,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Postgresql_02-07-2022

Reviewed 2 years ago
Pros

Postgresql is the best database system to store data.

Cons

The most usaged features is an extensions. I think that this features should include to standard postgresql distribution.

AvatarImg
AvatarImg

Pedro P.

Computer Software, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend6/10

Share this review:

database alternative to mysql

Reviewed 5 years ago

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

AR
AvatarImg

Verified reviewer

Information Technology and Services, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Powerful database

Reviewed 4 years ago

Excellent database engine with a lof of features and great overall performance. It has a very huge community so you could get help very easily. I'd recommend to use it.

Pros

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

Cons

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

AR
AvatarImg

Verified reviewer

Banking, 10,001+ employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL is the best open source database

Reviewed 4 years ago

I used another database for a large Brazilian bank. It was not a free database. The migration was excellent.

Pros

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Cons

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

AY
AvatarImg

Abbas Yusufzai K.

Oil & Energy, 51-200 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Postgre SQL.. Best 2D spatial database tool for geologists.

Reviewed 3 years ago

It's a pretty reliable database manager that provides for excellent data management and a very comprehensive security implementation, as well as the installation of procedures that make data integrity easy to maintain.

Pros

One of the advantages of this manager is that it is simple to install and has a free license for various distributions and operating systems. It also allows you to configure the manager according to the team requirements. Other capabilities include the ability to run read-only queries while in recovery mode. pg-Admin, for example, is a graphical application that allows us to simply administer our database. It is a great resource distribution for complex queries, very adjustable, allowing it to be tailored to the needs of individuals who use it, Allows you to limit the number of incoming connections to avoid timeouts caused by developers.

Cons

Indexing is some times very slow. Also database syncing or importing and exporting database is some time a headache. Apart from that, I don't see any major shortcoming in it.

AR
AvatarImg

Verified reviewer

Computer Software, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Nothing but praise for *the* SQL DBMS

Reviewed 5 years ago

We are running tens of Postgres databases and we have no reason to switch.

Pros

It's been reliable beyond all expectations. Put your data in Postgres, you know you'll find them when you need them.

Cons

VACUUMs are a big performance penalty, and the default auto-vacuum settings aren't always optimal for all use cases.

AvatarImg
AvatarImg

Maryury P.

Banking, 10,001+ employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

Database Manager PostgreSQL

Reviewed 6 years ago

In my experience using the software I really liked that it allows adding custom functions developed using different programming languages. The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters. I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error.

Pros

PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters. It also allows to activate triggers to execute in tables or views in special cases or eventualities. It...

Cons

There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources

Rd
AvatarImg

Rahul d.

Hospital & Health Care, 1,001-5,000 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Quality review of PostgreSQL

Reviewed 9 months ago
Pros

- Good management of data tables & possibility to have service of multiple Servers

Cons

- Great to improve user interface & SQL query error classification to make easy accessibilities of data.

AvatarImg
AvatarImg

Aníbal M.

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL is powerful and robust, it fits perfectly in large projects

Reviewed 6 years ago

With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses and I are happy with the results we have obtained, saving hardware investment costs because we have focused on the database, I hope to have future benefits to the use it in projects for own clients.

Pros

I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database...

Cons

There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative.

AR
AvatarImg

Verified reviewer

Marketing and Advertising, self-employed

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend5/10

Share this review:

Solid database, but not user (or even admin) friendly

Reviewed 3 years ago
Pros

It's a solid database tested over the years by half of the world. Whatever features you need it has it.

Cons

You'll often need to Google for the exact command you need to run, the docs are very dry and the syntax is unconventional. You'll suffer greatly trying to write code to access the database. If you want to upgrade, scale, or do anything significant with a large production database you're probably best off hiring a specialized consultant - it's risky and not easy.

dc
AvatarImg

daniel c.

Computer & Network Security, 51-200 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

"PostgreSQL: Ease and Efficiency in Application Development

Reviewed 8 months ago

From the first time I tried this software, I knew it stood out. All my databases now reside in it, not just for its efficiency, but for the sense of security and trust it gives me. Even when running it on less powerful machines, and experiencing some slowdowns, it has always delivered on its promises. I've been with it for nearly 7 months and have no regrets; it's been a solid choice for my projects

Pros

I started using it because of my university and I was instantly charmed by how user-friendly the software is with its tools. I have two databases and it has never let me down. Its security is good and the information doesn't get lost.

Cons

Throughout my journey with PostgreSQL, I've had moments of love and frustration. While I adore its sturdiness and the features it offers, I've stumbled a couple of times with its performance in specific scenarios. Sometimes, it feels like that reliable old car you know inside out, but occasionally takes a bit longer to start. Despite the minor hiccups, it remains my go-to companion when I want my data to be safe and well looked after

AA
AvatarImg

Ashish A.

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

Open source object-relational database management system for Web Developers

Reviewed 6 years ago
Pros

PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

Cons

PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.

RK
AvatarImg

Rajesh K.

Computer Software, 501-1,000 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

Review Of PostgreSQL

Reviewed 3 years ago

Overall PostgreSQL best in Market. They have better support and help their customers.

Pros

The PostgreSQL is best and most powerful RDBMS software in opensource platform. This PostgreSQL better in Data Storage, Data Dedupilication and Data Replication.

Cons

The PostgreSQL need some of security loop holes .

CH
AvatarImg

Carlos Hugo Martin C.

Information Technology and Services, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Experience with PostgreSQL

Reviewed 2 years ago

We have used the database for the implementation of reporters in most cases, seeking to remove the load from the main database.

Pros

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

Cons

There are functionalities that with third-party products can obtain better results.

SA
AvatarImg

Samuel A.

Telecommunications, 1-10 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Best Relational Database and it's Open Source

Reviewed a year ago

I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases

Pros

PostgreSQL excels in its strong documentation, large data handling, and exceptional security.

Cons

Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly

AK
AvatarImg

Aekansh K.

Computer Software, 201-500 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Great SQL db

Reviewed 5 years ago
Pros

Free and open source database Ease of scaling the database Easy to work with date, time and timezone jsonb type is really great so we don't need to use non relational database like mongodb fast queries

Cons

I have yet not found a great admin tool for postgres. pgadmin is ok but It is not as good as phpmyadmin or others.

IP
AvatarImg

Isak P.

Information Technology and Services, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Open source relational database with lots of features

Reviewed 2 years ago
Pros

Open source. Offers a rich set of features and extensions. Available as fully managed database on most cloud platforms.

Cons

Some cases, often involving large sets of data, might require some advanced knowledge in order to run properly/performant.

GC
AvatarImg

Goran C.

Information Technology and Services, 11-50 employees

Used monthly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Best open source database for enterprises

Reviewed 2 years ago

We use PostgreSQL as RDMS for our custom made solution for customers\projects without dedicated enterprise RDMS.

Pros

It supports advanced database features like partiotions, scalability, optimized concurrency management, security. It is offered under MIT-style license.

Cons

It is difficult to troubleshoot PostgreSQL. Not as widely used as My SQL for example, not as active community

AR
AvatarImg

Verified reviewer

Computer Software, 501-1,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Best SQL for Analytics and in terms of speed.

Reviewed 5 years ago

By using PostgreSQL as backend database for our large applications which uses large amount of data then selling that applications to customers we are getting benefits.

Pros

PostgreSQL is the best I can say. Its performance is very fast in terms of getting data and inserting data. Means if we are inserting entries in bulk then it would do it in a good speed as compared to other databases. It is very good for Analytics and it has good tooling than other databases. It supported many other features like using of arrays which is not in MySql so I would say it is good database to use to make applications.

Cons

The big disadvantage is it takes more memory than other databases if you have many connections and replication is bit difficult in PostgreSQL which might get easy in future updates else it is a good software.

AvatarImg
AvatarImg

Samantha N.

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

The best SQL and open source database.

Reviewed 6 years ago

Because range queries are integrated, it is much less effort to query compared to MySQL.

Pros

 It is fast and reliable, manages inserts and updates of tens of thousands of lines impeccably. PostgreSQL implements SQL standards very well and supports advanced SQL stuff, the PostSQL database works very well with hibernation HPA and we have been using it extensively together with the Spring framework, the consistency is also very good, you will never lose data or lose data. JSON support in the latest version has made things easier for us now, since we do not need to migrate the schema as always before.  Finally, the backup methods through pg_dump are easy to use and ensure that you can always back up before any major changes.

Cons

It is not very intuitive, in my opinion, and I think those problems must be solved before I can get the kind of traction that MySQL has, also more open sources admit mysql but not postgres. These are some of the problems with postgres.

AvatarImg
AvatarImg

Arjun K.

Computer Software, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

The Reliable Workhorse with Infinite Flexibility

Reviewed a year ago

Nothing short of exceptional. It covers all the bases with its reliability and performance, and its flexibility is unmatched. I've found it difficult to recommend any other database unless you have specific requirements, such as a document store or a graph database. Postgres fills in all the gaps and has become my go-to choice for any project that requires a rock-solid, flexible relational database.

Pros

does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project.

Cons

No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right.

AvatarImg
AvatarImg

Joseph M.

Civil Engineering, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Agrxis Review on PostgreSQL

Reviewed a year ago

I can state with confidence that PostgreSQL has exceeded my expectations as a database management system based on my whole experience with it. I strongly rely on PostgreSQL as a data-driven professional to store, retrieve, and analyze massive volumes of data. PostgreSQL's adaptability and scalability have been crucial in meeting our expanding data demands. The knowledge that our important information...

Pros

In my experience with PostgreSQL, its adaptability and dependability as a database management system were its strongest points. I like PostgreSQL's broad range of features and capabilities as a data specialist. In order to satisfy the various data requirements of our firm, it has been essential to be able to manage enormous datasets, conduct sophisticated queries, and support advanced data types. The versatility it offers with its support for several programming languages, which enables us to smoothly incorporate PostgreSQL into our current tech stack, is something I personally enjoy. The performance analysis tools have been crucial in improving query execution and system performance as a whole.

Cons

My least favorite aspect about PostgreSQL was the steep learning curve and complexity involved in setting it up and configuring it. I haven't used database management systems for very long, so navigating PostgreSQL's installation and configuration options proved to be a challenge. I had to spend more time and effort learning the many PostgreSQL-specific concepts and settings.

AvatarImg
AvatarImg

Brunei A.

Computer Software, 201-500 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgresSQL Review

Reviewed a year ago
Pros

PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution.

Cons

PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out.

AvatarImg
AvatarImg

Janne M.

Telecommunications, 10,001+ employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

One of the best overall databases in the market

Reviewed 3 years ago

For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.

Pros

PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.

Cons

Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.