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 Information Technology and Services

Enterprise (> 1000 emp.)

11/7/2018

"The most advanced and efficient open-source database"

4.5/5

What do you like best about PostgreSQL?

Extensible, efficient, supports SQL, Mongo, and NoSQL as well. It is open-source, so there is no cost involved. The online community for PostgreSQL is excellent, leading to better support. It is second to none in terms of reliability and stability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Slower than MySQL. Installation and configuration can be difficult to grasp at first. Review collected by and hosted on G2.com.

Verified User in Civil Engineering

Enterprise (> 1000 emp.)

2/6/2019

"The best db hands down "

5/5

What do you like best about PostgreSQL?

The extensibility, stability, and spatial capability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

GUI interface is not as well developed as the CLI and intimidates newer users Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

2/14/2019

"Great Database to work with"

4/5

What do you like best about PostgreSQL?

Easy to setup and works well with Sequelize Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not great with performance compared to Oracle or teradata Review collected by and hosted on G2.com.

John R.

Co-founder, lead developer

Small-Business (50 or fewer emp.)

1/2/2018

"By far the most powerful and advanced open source database software"

4.5/5

What do you like best about PostgreSQL?

The developer community behind Postgres is phenomenal. Not only do they keep the software active, they give their time speaking and teaching about the software. The speed and reliability of the software is also great. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres number one priority is data reliability, then speed, which causes some features like COUNT() to be slower than I'd like. While this is ideal 99% of the time, there is that 1% when I wish there was an option to configure the software to make COUNTs faster, even if it meant less reliability for that qeury's result. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Setup and configuration are not easy, but it's mostly system administrators and DBAs using it so that is to be expected. Admin tools, such as pg_basebackup, have improved. Review collected by and hosted on G2.com.

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

Postgres powers our web based software, Intervals. It's been the best choice we could have possibly made for over 11 years since we first adopted it. We have benefited most from the speed improvements and replication features. Review collected by and hosted on G2.com.

Juan M.

Project Manager

Information Technology and Services

Small-Business (50 or fewer emp.)

9/7/2018

"Relational database for professionals"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is the best open source relational database system. It is the most complete and it gives you the best performance and functionality. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a bit complex at the beggining. There are a lot of options even in the query interface PgAdmin. You need a lot of database background to take it for Bussiness. Review collected by and hosted on G2.com.

Jose Antonio G.

Mid-Market (51-1000 emp.)

9/3/2018

"Easy database manager"

4/5

What do you like best about PostgreSQL?

Open source and free to use.

PostgreSQL allows you to make backups and exports of your databases very easily, what is very important if you wan t to keep your work safe. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When working with huge databases, PostgreSQL can be slow and sometimes it seems to be crashed, even though it's working. Review collected by and hosted on G2.com.

Verified User in Military

Mid-Market (51-1000 emp.)

1/4/2019

"Great Product, especially for small projects"

3.5/5

What do you like best about PostgreSQL?

Easy to spin up a simple database, free to start, open source community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much, but the wrappers for Postgres can be somewhat complicated. Review collected by and hosted on G2.com.

Daniel R.

Software Engineer Intern

Computer Software

Enterprise (> 1000 emp.)

7/30/2018

"PostgreSQL used with Ruby on Rails"

5/5

What do you like best about PostgreSQL?

It packs all the features you need in a simple to use interface. It has several GUI tools and you can install it either in windows or UNIX OS. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

So far there is nothing I dislike. I haven't come up with any problems so far. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I really recommend PostgreSQL, I think is the best relational database out there and it packs the most modern technology too. Review collected by and hosted on G2.com.

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

It's free and we find it really useful even when storing information in JSON columns. Review collected by and hosted on G2.com.

Ashish G.

Software Engineer

Information Technology and Services

Enterprise (> 1000 emp.)

12/26/2017

"Open source object-relational database management system for Web Developers"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL or simply Postgres implements the SQL standard very well. Postgres provides a easy to understand tool called pgAdmin to interact and manipulate database. It provides support for complex data types like Array and Json. It can handle workloads ranging from small web applications to large data warehousing with many concurrent users. It is available till 10,000 rows on Heroku. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL query syntax for some complex queries like array,string functions and case operator are is not easy to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as MySQL and it is bit harder to google search results. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I recommend PostgreSQL to all web application who are looking for cost effective database. It supports almost all types of backend server like, Java, Ruby, Python etc. Postgre SQL provides high level of parallel queries. It support very useful types like array and JSON. Review collected by and hosted on G2.com.

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

From last one year we moved from MySQL to Postgres for database needs reason being of its support for multiple concurrent connections in affordable price. We are now using Postgres database for our new projects. I got benefit using PostgreSQL in term of price, speed, support of complex type and easy to learn query syntax. Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

11/13/2018

"PostgreSQL MPP database review"

4/5

What do you like best about PostgreSQL?

Performance. This is the promise of a MPP and PostGreSQL lives up to its promise. Also frequent releases adds more and more features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. A little more UI tools would be useful. Also the provision to support more external tables will definitely help. Review collected by and hosted on G2.com.