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.

Arvind T.

Technical Leader

Mid-Market (51-1000 emp.)

10/15/2025

"Great Functionality, but Long Queries Can Slow Down the Database"

4.5/5

What do you like best about PostgreSQL?

Support many functionalities like spatial database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Actually postgresql used MVVM pattern and run query on core base so if any query take long time to run so it busy complete database. Review collected by and hosted on G2.com.

Swapnil i.

Product Engineer

Computer Software

Enterprise (> 1000 emp.)

9/17/2025

"High Data integrity and complex query support with various data types choose postgres sql only"

5/5

What do you like best about PostgreSQL?

We can play with many data types and we are in fintech domain so it is quite efficient in term of banking. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometime i need analytical processing then i lag somehow with postgre sql. Review collected by and hosted on G2.com.

Dhiraj D.

Data Engineer

Enterprise (> 1000 emp.)

9/16/2025

"Best DB workbench"

5/5

What do you like best about PostgreSQL?

It's user interface is very friendly. It easily give data modification table , schema , views create scripts. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it's crashes when we run heavy queries Review collected by and hosted on G2.com.

prathamesh s.

intern

Mid-Market (51-1000 emp.)

9/23/2025

"great software experience"

4.5/5

What do you like best about PostgreSQL?

NO LISCENCE COST, EASY TO HANDLE, FULL SUPPORTSFOR JOINS ,PROCEDURES AND WINDOW FUNCTIONS Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

HEAVY WORKLOAD, SLOWER WRITE PERFORMANCE Review collected by and hosted on G2.com.

Duvan Dario D.

Data Engineer

Mid-Market (51-1000 emp.)

10/1/2025

"very good database, a bit complicated user management"

5/5

What do you like best about PostgreSQL?

special features and integrations Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

role management and permission management for users Review collected by and hosted on G2.com.

Verified User in Accounting

Small-Business (50 or fewer emp.)

4/30/2025

"PostgreSQL:"

5/5

What do you like best about PostgreSQL?

Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in JSON support makes it an excellent choice for handling semi-structured data without sacrificing relational capabilities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication and clustering can be more manual compared to solutions like MySQL’s built-in replication Review collected by and hosted on G2.com.

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

Using PostgreSQL in a corporate environment brings several benefits, as it addresses key challenges in data management, scalability, and performance.

Reliable Data Integrity: PostgreSQL’s ACID compliance ensures transactions are processed reliably, which is crucial for maintaining consistency in business operations.

Advanced Querying & Analytics: Its powerful SQL capabilities allow businesses to run complex queries efficiently, making data-driven decision-making smoother. Review collected by and hosted on G2.com.

saif eddine m.

i can't tell

Enterprise (> 1000 emp.)

2/27/2025

"My Experience With PostgreSQL"

5/5

What do you like best about PostgreSQL?

What i like most about PostgreSQL is the ergonomic interface , easy to understand . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I didn't actually encounter any Problems or downsides . Review collected by and hosted on G2.com.

Akshay P.

Data Science And Business Analytics intern

Retail

Small-Business (50 or fewer emp.)

10/1/2024

"PostgreSQL Performance Insights"

4.5/5

What do you like best about PostgreSQL?

One of the best part is Open source, Handle large datasets, strong security, easy to use and most important community support. Also It provide advance features like: support complex qeries, Custom functions Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

one thing i.e. fewer GUI tools compared to other database like MySQL Review collected by and hosted on G2.com.

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

It addresses the need for scalability by efficiently handling large datasets and supporting complex queries, making it ideal for big data and analytics. Additionally, PostgreSQL simplifies complex data handling with support for advanced data types like JSON and arrays, allowing businesses to manage structured and unstructured data seamlessly. Review collected by and hosted on G2.com.

Diego G.

Engineering Lead

Mid-Market (51-1000 emp.)

11/22/2024

"Simply an amazing tool"

5/5

What do you like best about PostgreSQL?

It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments Review collected by and hosted on G2.com.

NAYAN K.

Data Scientist

Mid-Market (51-1000 emp.)

7/26/2024

"PostgreSQL: Most popular SQL DBMS Software"

5/5

What do you like best about PostgreSQL?

Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There should be some more extensions with widely used open source software/apps. Review collected by and hosted on G2.com.