Compare this with other toolsSave it to your board and evaluate your options side by side.

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

G2 reviews are authentic and verified.

Here's how.

Verified User in Computer Software

Enterprise (> 1000 emp.)

8/28/2023

"Postgres - Open source RDBMS solution"

4.5/5

What do you like best about PostgreSQL?

The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome. Review collected by and hosted on G2.com.

Mohit S.

Mid-Market (51-1000 emp.)

9/1/2023

"Best open source database to achieve high performance and scalability."

4.5/5

What do you like best about PostgreSQL?

It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference. Review collected by and hosted on G2.com.

Jasmeet K.

Data Scientist

Mid-Market (51-1000 emp.)

4/20/2023

"Excellent RDBMS for production systems with minimal cost."

5/5

What do you like best about PostgreSQL?

I have used Postgres SQL extensively for the past few years and it is few of cost effective scalable RDBMS that runs very smooth with web applications specially with Django backend. This RDBMS can be tuned for performance quickly and offers amazing support for custom functions.

This RDBMS can be scaled quickly and is available in cloud services like Amazon RDS which can make this database manageable. The error messages in the RDBMS is very clearly laid out and I just love the way it provides flexibility of using custom SQL workbenches. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have loved my experience with Postgres SQL and the user community for this RDBMS is amazing. I have faced issues in reading documentation for Postgres but online community has always helped in getting my issues resolved. Review collected by and hosted on G2.com.

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

PostgresSQL has been a goto database management system in our projects because of its flexiblity and seamless integration with Django. I have been using PostgresSQL extensively for data storage and analysis. This RDBMS is really cost effective and we use it in Amazon RDS for production instance. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/1/2024

"Great database system to use for beginners."

4/5

What do you like best about PostgreSQL?

Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation is very dense which is nit easy to understand by beginners. Review collected by and hosted on G2.com.

Kwabena A. B.

IT Professional

Mid-Market (51-1000 emp.)

5/11/2023

"Enterprise Open Source Relational Database Management System"

5/5

What do you like best about PostgreSQL?

PostgresSQL shines as an enterprise RDBMS. It has all the enterprise features of a modern database management system, yet it is free and open source. It can handle a data intensive system very well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is really difficult to talk about any dislike about PostgreSQL, however it has a bit of a learning curve. Also, installation and configuration on a linux platform is a bit complicated. Review collected by and hosted on G2.com.

Ramiro L.

Small-Business (50 or fewer emp.)

5/25/2023

"Feature-rich, and performant database system that suits a wide range of applications"

5/5

What do you like best about PostgreSQL?

-Scalability and Performance: PostgreSQL can handle high-volume workloads and scale to large datasets.

-Cross-Platform Compatibility: PostgreSQL runs on multiple platforms, including Linux, macOS, and Windows. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Configuration and Performance Tuning: Optimizing performance in PostgreSQL can be challenging, particularly for complex workloads and large datasets.

-Upgrade Process: Upgrading PostgreSQL to newer versions may require careful planning and testing, as it involves migrating data and ensuring compatibility with existing applications and extensions. Review collected by and hosted on G2.com.

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

PostgreSQL solves several problems in the realm of data management:

-Data Integrity and ACID Compliance: PostgreSQL implements ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring data integrity and reliability.

-Data Integration and Interoperability: PostgreSQL supports integration with other systems and tools.

-Scalability and Performance: PostgreSQL offers scalability and handles high-volume workloads effectively. Review collected by and hosted on G2.com.

Akash N.

Enterprise (> 1000 emp.)

6/7/2023

"One of the best and free DBMS in the market!"

5/5

What do you like best about PostgreSQL?

Postgresql is a platform that shares unlimited sources accessible to every user. Its user-friendly features make it easy for beginners to understand its functionalities.

Whether maintaining or exploring new databases or setting up your database from scratch, Postgresql is one of the best tool user can rely upon! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While merging or blending data from different sources a few times, PostgreSQL lags or fails the first time, which can be a con for the platform, other than all other features work smoothly! Review collected by and hosted on G2.com.

Vladimir T.

Ingeniero y Desarrollador

Small-Business (50 or fewer emp.)

5/22/2023

"Most reliable database"

5/5

What do you like best about PostgreSQL?

Reliable: Even when there is no space in disk or with some hardware errors it can recover. Fast --it requires optimizing but it gives the tools to optimize. Open Source. Periodicaly updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For me that it uses Sql is a plus. But I guess for people who doesn't know Sql it may be hard, but it iw worth to learn it. Review collected by and hosted on G2.com.

Paresh K.

Junior Software Engineer

Mid-Market (51-1000 emp.)

2/22/2023

"The most powerful, feature-rich open-source relational database management system"

4/5

What do you like best about PostgreSQL?

The main plus point about PostgreSQL is that it's an open-source R-DBMS that is very reliable, making it a first choice for startups and other organizations. Also, it has gained a high reputation for its high performance while handling high volumes of datasets very efficiently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One thing I feel that's a downside in PostgreSQL is that its GUI functionality is very limited and not that user-friendly, making it challenging for first-timers to use its complete functionalities, especially when they are not used to the command-line interface. Review collected by and hosted on G2.com.

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

PostgreSQL helped us while working on a web application as the backend database management system, which was built on top of Java the main reason I chose this was that it was open-source and had a vast community, which was needed when we got stuck in some problem. Also because of the flexibility and its performance, it was the best option for us. Review collected by and hosted on G2.com.

Stefano A.

Direttore Ricerca & Sviluppo

Enterprise (> 1000 emp.)

1/10/2023

"PostgreSQL: a good alternative to Oracle RDBMS"

4.5/5

What do you like best about PostgreSQL?

High compatibility with Oracle SQL and Oracle PL/SQL. With very few changes, you are able to migrate an Oracle Database to PostgreSQL. There are also a good choice for what concern high availability and load balancing solutions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is able to manage JSON data with native datatype and APIs. But if you need to query datasets over 10 Gbytes of raw data, consider transforming JSON documents to normalized tables because queries may have time-out issues. Review collected by and hosted on G2.com.