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.

Frantisek B.

CTO

Information Technology and Services

Small-Business (50 or fewer emp.)

11/27/2023

"Enterprise-grade open source RDBMS with extension"

4.5/5

What do you like best about PostgreSQL?

Probably the best open source SQL solution, universal use due to the possibility of installing extensions. Easy administration and High availability in combination with patroni and etcd. Commercial support by some companies.

Useful extensions:

PostGIS : geography data

TimescaleDB: time series data with automatic partitions, automatic aggregation and deletion

Several options for HA.

Several options for backup and recovery, i personally user Barman (pgbarman.org)

Easy of deployment with containers (Docker, podman, Kubernetes). Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Does not support automatic creation of partitions. For automatic partition it is possible to use triggers and PL/pgSQL, extension pg_partman (you have to do manually while locking the database tables) a my preferred way timescaleDB extension and hypertables. Review collected by and hosted on G2.com.

Michelle C.

Director KPMG

Information Technology and Services

Mid-Market (51-1000 emp.)

7/4/2023

"Secure, Powerful and Open-source database management system"

5/5

What do you like best about PostgreSQL?

PostgreSQL is a powerful open-source object-relational database management system. It is one of the highly used databases across different organizations worldwide. It can run all operating systems and manage data held in relational databases. It provides support for a variety of data such as images, text, video, audio, and more. It is very easy to learn for new developers as it supports all SQL features and we can add extensions to enable additional functions.

A user can work with PostgreSQL either through the CLI interface or through the pgAdmin desktop application. Once you enter the credentials to connect pgAdmin app with the database all the queries and operations will be in sync with the CLI interface as well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The only drawback I found using PostgreSQL is that the initial setup is a bit challenging. Sometimes it creates difficulties in creating new users for PostgreSQL and setting up credentials to log in to the database. If this could be made easy it will really help and save us a lot of hours of configuration time. Review collected by and hosted on G2.com.

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

My organization uses PostgreSQL as a primary solution for storing, retrieving, and manipulating data in Relational databases. We store users' data such as profile information, images, texts, and transaction details in the PostgreSQL database. We integrated PostgreSQL with DataGrip by Jetbrains to get a UI view of data that saves a lot of time and resources in running queries to view data. It can perform queries in milliseconds in petabytes of data. It maintains data integrity, security, and validation on the go and is easily scalable to size limits. Also, it allows developers to run it on container and virtual machines. The multiple language support and similarity with SQL make it easy to onboard new developers. Review collected by and hosted on G2.com.

Jainesh K.

Senior Software Engineer

Mid-Market (51-1000 emp.)

8/31/2023

"An opensource and reliable DB with essential functionalities"

4/5

What do you like best about PostgreSQL?

- It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members.

- It's a scalable database that can be used for a variety of applications.

-Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system.

- Full text search feature is also provided by PostgreSQL which can help in a variety of applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- There are some opensource apps that might not support PostgreSQL but MySQL because It is not owned by a single entity and hence lacks the recognition It deserve.

- Might not be a good solution for the shared dataset as there is no out of the box approach available for it in PostgreSQL.

- It might have a steep learning curve for beginners. Review collected by and hosted on G2.com.

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

- Using relational and non-relational data on the same system as It handles JSON data type very gracefully thanks to JSONB.

- It can significantly help in improving your application cost as Its available free of cost.

- Works well with large data/applications as well.

- Strong support from a larger developers community makes It reliable and easy to use. Review collected by and hosted on G2.com.

Kaustubh K.

Devops Engineer

Computer Software

Mid-Market (51-1000 emp.)

8/24/2023

"Great services and simple db to use"

4/5

What do you like best about PostgreSQL?

PostgreSQL is open source database management solution. For SQL queries, it supports both SQL and JSON. Also we can use complex data types and performance optimisation tools that we would normally only find in pricey commercial databases. And as per the develoeprs view we can create custom data types , functions and all and if configured correctly , we can perform complex data operation , recursive queries and many more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If we talk. About the speed then mysql is works beeter in that but PostgreSQL works more on compatibility. And also just one thing that many open source application support needs to be given in PostgreSQL.to add this just one thing if it is not configured correctly , it can give issues while optimisation. Review collected by and hosted on G2.com.

Deepak o.

Software Engineer

Mid-Market (51-1000 emp.)

9/29/2023

"powerful object-relational database: PostgreSQL"

5/5

What do you like best about PostgreSQL?

1- its perfomance is awesome.

2- its response time analysis of query

3- its features like indexing to optimse your query.

4- its easy to use

5- its beginner friendly Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

1- resource intensive and sometimes it lags

2-once the data is lost then it becomes diffucult and complex to back it

3- when i started working with it i found its setup and configuration is little bit difficult. Review collected by and hosted on G2.com.

Dinesh S.

Team leader

Information Technology and Services

Small-Business (50 or fewer emp.)

10/26/2023

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

"Postgre SQL Review"

4.5/5

What do you like best about PostgreSQL?

Postgre is a database where we have execllent features in wrinting the complex sql queries and easy connection of databases by database integration.The application installation and implementation is easy and the saved data and query does not erase whcih makes way to execute the query often. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The table result set displays only for certain number of rows as it has some limitations.We need to export data everytime to view larger set of results. Review collected by and hosted on G2.com.

Nagesh C.

Software Engineering Lead

Small-Business (50 or fewer emp.)

9/12/2023

"Free and open-source RDBMS with extensibility and SQL compliance"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL comes with all the existing features of an RDBMS as well as additional extensibility of replicating programming data types likes Arrays, Enumerated & Binary Data etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres is not owned by any organization. So, it has had trouble getting its name out there despite being fully featured and comparable to other DBMS systems. Review collected by and hosted on G2.com.

Piyush G.

Programmer Analyst

Enterprise (> 1000 emp.)

7/28/2023

"Best Cloud DB."

5/5

What do you like best about PostgreSQL?

The best part about PostgreSQL is it is very easy to use in comparison with other SQL Databases.I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It can be a little complicated for someone who is new to SQL Database or for begginers because of it's deep learning Curve. But there are so many resources and it's official documentation that helps a lot to start. Review collected by and hosted on G2.com.

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

I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. As we are developing a enterprise application and the data is huge so it's the ideal choice because it very secure,reliable and it can be scaled up at any time. It's top notched DB Management System Review collected by and hosted on G2.com.

Dhanush R.

Customer Success Engineer

Mid-Market (51-1000 emp.)

9/6/2023

"Postgres user friendly RDBMS"

4.5/5

What do you like best about PostgreSQL?

Postgres is opensource, it supprts scalability, role based access to it also one of the major factor, where people like using it.Even for secure access it provides SSL authentication. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's bit hard to setup, no user friendly GUI tools like, SQL developer for oracle. I see there is some GUI tool called PgAdmin which I use, which is not that of user friendly like other RDBMS DB's Review collected by and hosted on G2.com.

Shivam M.

Product Evangelist

Mid-Market (51-1000 emp.)

10/31/2023

"Review on Postgres"

5/5

What do you like best about PostgreSQL?

Postgrest provied very easy to use interface which is very easy to implement as well because of which users preffer to use it frequently and it has n numbers of features which makes it easy to integrate with multiple sowtwares and it has good customer support as well which increase its creadiblity in market. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres is bit slow than MySql and if we delete any records from table then it is not auto vaccume and reindex because of which table size and database size is not reduced which reduces its performace some times. Review collected by and hosted on G2.com.