PostgreSQL Reviews & Product Details

PostgreSQL is a powerful, open-source object-relational database system renowned for its reliability, extensibility, and adherence to SQL standards. Originating from the POSTGRES project at the University of California at Berkeley in 1986, it has evolved over nearly four decades into a robust platform capable of handling complex data workloads across various operating systems. PostgreSQL's architecture emphasizes data integrity and scalability, making it a preferred choice for developers and organizations worldwide. Key Features and Functionality: - Comprehensive Data Types: Supports a wide range of data types, including primitives (Integer, Numeric, String, Boolean), structured (Date/Time, Array, Range), document (JSON/JSONB, XML), and geometric types. - Advanced Data Integrity: Ensures data accuracy through features like UNIQUE constraints, primary and foreign keys, exclusion constraints, and various locking mechanisms. - High Performance and Concurrency: Utilizes advanced indexing methods (B-tree, GiST, GIN, BRIN), a sophisticated query planner, multi-version concurrency control (MVCC), parallel query execution, and table partitioning to optimize performance. - Reliability and Disaster Recovery: Offers write-ahead logging (WAL), various replication methods (asynchronous, synchronous, logical), point-in-time recovery (PITR), and active standbys to ensure data durability and availability. - Robust Security Measures: Provides multiple authentication methods (GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, OAuth 2.0), a comprehensive access-control system, and supports multi-factor authentication. - Extensibility: Allows the creation of custom data types, functions, and operators. Supports procedural languages like PL/pgSQL, Perl, Python, and Tcl, with additional languages available through extensions. Primary Value and User Solutions: PostgreSQL addresses the needs of developers and organizations by offering a highly extensible and standards-compliant database system that ensures data integrity, scalability, and robust performance. Its open-source nature allows for continuous innovation and adaptability, enabling users to tailor the database to their specific requirements. Whether managing small applications or large-scale enterprise systems, PostgreSQL provides a reliable foundation for storing and processing data efficiently.

Seller

PostgreSQL

Discussions

PostgreSQL Community

Overview by

Avi Ashkenazi (CTO at Coronys LTD.)

Value at a Glance

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

PostgreSQL Media

PostgreSQL

PostgreSQL Reviews (667)

View 2 Video Reviews

G2 reviews are authentic and verified.

Here's how.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

7/28/2022

"PostgreSQL review"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is one of the best relational databases. It supports multiple data types and has good query and data management support. The documentation is maintained and is the best place to learn everything about the database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL supports JSON datatype but the supporting methods are difficult to understand and work with. The documentation is present but there aren't enough examples that would help developers understand and use the methods. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Mid-Market (51-1000 emp.)

6/16/2022

"Powerful open source relational database"

4.5/5

What do you like best about PostgreSQL?

It is an open-source relational database that supports a heavy range of workloads. it follows the ACID properties and SQL queries. PostgreSQL has views, tables, store procedures etc. The database can connect with multiple interfaces and supports python, java, C++, PHP and perl. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has a slow Comparatively low reading speed. Its documentation is only available in English. In some circumstances, the lack of columnar stores renders PostgreSQL less capable in analytics tasks. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Highly scalable relational database. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL, help to store the data in the databases. It is highly programable and hence can load and transform the data in different stages using python. PostgresSQL procedural language PL/PgSQL is much more powerful than MySQL’s SQL and hence used to load the aggregated data into publishing layer tables. Review collected by and hosted on G2.com.

Verified User in Chemicals

Enterprise (> 1000 emp.)

6/30/2022

"Fast and Open Source RDBMS"

4.5/5

What do you like best about PostgreSQL?

Compared to MySQL, PostgreSQL is quicker and provides ACID characteristics. Storage procs can be created in PL/pgSQL, PL/Python, PL/Perl, and C/C++, and it has broader community support. It is a highly expandable database that handles large datasets, challenging queries, and read-write operations more quickly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Only limited documentation is available in English. Additionally, the reading speed is really slow. PostgreSQL is one of the best open-source databases available besides this. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Good DB for storage purpose Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We used PostgreSQL to accommodate a large amount of data. Establishing the Datawarehouse to transform the daily loads into tables and update the dimensions, Facts, and other tables. It's used for data analysis and running the transformation on multiple tables and layers. Review collected by and hosted on G2.com.

Saurabh K.

Software Engineer

Enterprise (> 1000 emp.)

5/9/2022

"Very simple and clean UI"

4/5

What do you like best about PostgreSQL?

PostgresSQL has very clean UI and very simple to use. Anyone can open multiple tabs. Developer can write custom queries in it. It is unique sql software for developers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgresSQL sql is not very famous and it is not used by many companies. But it deserves to be part of every company. PostgresSQL can more work on its UI. So that it would be competitive in the market. Review collected by and hosted on G2.com.

Sakchi .

Intern

Small-Business (50 or fewer emp.)

4/28/2022

"PostgreSQL review"

4.5/5

What do you like best about PostgreSQL?

The best thing i liked about PostgreSQL is that it's very easy to use and can handle various complex queries. It is also helpful when you need to run huge queries such as trigger. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As such there is no dislike about PostgreSQL but yes, for a beginner who have no or less Knowledge about SQL, it will be very difficult for him/her to work on PostgreSQL. Review collected by and hosted on G2.com.

Raj P.

Software Engineer

Mid-Market (51-1000 emp.)

11/8/2021

"For me this is the best and most robust RDBMS in the market"

5/5

What do you like best about PostgreSQL?

This is the most versatile and advanced DB system in the market available for free of cost. This DB system is similar to MySQL or Oracle DB system but it is more popular and has a bigger community than those. It has a convenient command-line interface for both Linux and Windows OS. It has intuitive commands that do what they sound like e.g., create table, create database, etc. For those who are not good with command-line interfaces, it also has GUI based management tool called pgAdmin for easier use. It has easy integration with Python and Golang and its frameworks like Django for Python. You can easily export table data in CSV. The best thing is, it has a detailed documentation website where you can explore all of its functionalities easily and release-wise. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Honestly, I don't think this RDBMS has any significant flaw or issue. One thing is, there are fewer drivers available for this database for integration in frameworks e.g. Python Django framework literally has one driver called psycopg2 which can create license issues. Another thing is, it has a huge number of commands that can be difficult for some people to grasp. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

For other PostgreSQL users, I can recommend this DB system as it is a general-purpose DB system but still the selection of a DB system mostly depends on the requirement. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I use PostgreSQL in a web application that needs to store a large amount of JSON data with very frequent access. PostgreSQL can also be used in data analysis which also requires the storage of a large amount of complex data. Review collected by and hosted on G2.com.

Jean-Marie R.

Open Source Database Technical leader

Enterprise (> 1000 emp.)

9/17/2020

Business partner of the seller or seller's competitor, not included in G2 scores.

"PostgreSQL DBA and trainer"

5/5

What do you like best about PostgreSQL?

SQL standards

Stable configuration settings per version

Improvments over time

A lot of tools around PostgreSQL: as pgAdmin4, programmaing language connectors, pgbadger, pgbackrest, patroni, ...

PostgreSQL is an Open source piece of software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A lot of different projets around PostgreSQL himself for same purpose.

No full featured and supported clustering solution embedded natively.

Long new features development cycle. Review collected by and hosted on G2.com.

Priya B.

Senior Software Engineer| Business Intelligence Developer

Enterprise (> 1000 emp.)

5/10/2022

Business partner of the seller or seller's competitor, not included in G2 scores.

"Postgresql - the object relational database system"

3.5/5

What do you like best about PostgreSQL?

Postgresql is a flexible relational database solution for transactional/statistical data and can also be used as a NoSQL solution. Postgresql has the best capabilities for handling spatial data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgresql database management system requires expertise and has certain limitations using it in the cloud. Also, cost and time are the two biggest challenges to be aware of when adopting this database. Review collected by and hosted on G2.com.

Tabassum K.

Senior Data Engineer

Enterprise (> 1000 emp.)

3/24/2022

"Known for Performance, Easy management & Schema Control"

4/5

What do you like best about PostgreSQL?

I liked this database because of easily schema control and very robust to setting the process, it is also less risky and hard to break out the security layers. Features like multi-inversion concurrency control help in fluid changes to be made to the system. data management is also very easy. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As such no disadvantages at all but we need to take care of so many things at the time of implementation. It could be improved by using parallization and need distributed computing. Review collected by and hosted on G2.com.

Ekta S.

Senior Software Developer

Mid-Market (51-1000 emp.)

2/15/2022

"Highly reliable and scalable RDBMS available to use."

4.5/5

What do you like best about PostgreSQL?

Easy to install and integrate with the application. It uses standard SQL and also supports object-oriented SQL programming and we can also perform JSON-based data transactions with this dbms. Client-Server network architecture support is the best thing is with Postgresql and of-course it is open source DBMS Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some speed issues with PostgreSQL when we perform data transactions on very large numbers. Backup features should be improved and PostgreSQL should provide some own GUI for DB operation, normally we use pgAdmin for the same purpose. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Scalable, Robust, and Reliable database. must use one time for better database exeperience. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I have used Postgresql for data analytics purposes, I have created a data warehouse for my project and due to it comes with a powerful SQL engine, it manages a large amount of data very easily. Review collected by and hosted on G2.com.