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.

Arik B.

CEO & Co-Founder

Computer Software

Small-Business (50 or fewer emp.)

12/13/2017

"Excelent and flexible open source SQL database"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is a mature database server with large user's community and continue development. Installation is very simple and also integration with multiple development environment is supported we user C++ library, PHP and Java integration Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

would like better admin package, managing changes as versions is bit complex Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

This is an open source SQL database that include many of the much more expensive solutions and it is open source with wide community of contributers Review collected by and hosted on G2.com.

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

We use PostgreSQL as our system DB and benefit from wide range of features and extensions. We need to access the database from several environment and this is very simple and supported with large number of libraries and connections. Review collected by and hosted on G2.com.

Samuel C.

Originations Specialist

Financial Services

Mid-Market (51-1000 emp.)

7/29/2018

"Essential Tool"

4/5

What do you like best about PostgreSQL?

Easy to learn; Widely used in our company Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Little keyboard shortcuts available; browser program does not have ability to save macro Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

7/17/2018

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

"Pros and cons of PostgreSQL"

2.5/5

What do you like best about PostgreSQL?

The first thing to highlight is that it is open source, therefore it has no licensing costs. It is undoubtedly the best free option. Its GIS extensions are also worth mentioning. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its performance handling large volumes leaves much to be desired and the administrative tools are not as powerful as we would like. Review collected by and hosted on G2.com.

Eduardo H.

Ingeniero informático

Consumer Goods

Small-Business (50 or fewer emp.)

7/17/2018

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

"Great"

4/5

What do you like best about PostgreSQL?

Excellente software to manage databases. Is oriented to obejects and the best of all is that is free. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Don't have a official support from the depeloper of the software. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

10/12/2018

"A very versatile database"

5/5

What do you like best about PostgreSQL?

Has various extensions and a very wide dev base.

supports foreign data wrappers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could support more efficient caching and in-memory Review collected by and hosted on G2.com.

Ramon B.

Senior Software Engineer, R&D

Broadcast Media

Enterprise (> 1000 emp.)

9/19/2017

"Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first!"

4.5/5

What do you like best about PostgreSQL?

Awesome built in data types, JSON with indexing to then work with triggers and locks!

Best of both NoSQL and SQL. The community is very active, as well as several commercial enterprise offerings. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I found there to be a steep initial learning curve to be able to build an application effectively to use all the built-in magic if the development team come from using MySQL or MSSQL. Once the brain wraps around some of the over loaded terminology Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

have your team take the time to read or watch an introduction to postgresql methodology, and well as a comparison against MySQL. The hour/hour and a half of time in the beginning can save hours/days of reworking to use the internal tools to scale properly. Review collected by and hosted on G2.com.

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

We needed a database or databases that we could effectively have json stored, indexed, but allow for locked tables. Review collected by and hosted on G2.com.

Thanh P.

Software Engineer

Information Technology and Services

Small-Business (50 or fewer emp.)

11/15/2017

"Object-relational database management system, free and open source"

5/5

What do you like best about PostgreSQL?

A simple database server: store and query data

Multiversion concurrency control (MVCC) per "transaction"

Support JSON data type from version 9.2

Developer can define their objects, inherit from default system defined.

Has full text search and asynchronous notifications Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance and slow on older version. Need update at least 9.4 for better performance Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

Support full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger. Review collected by and hosted on G2.com.

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

Full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger. Review collected by and hosted on G2.com.

Pablo G.

Mid-Market (51-1000 emp.)

7/31/2018

"One of the best services"

5/5

What do you like best about PostgreSQL?

Efficiency, power, easy of use and environment. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The environment may be a bit powerful and with more functions. Review collected by and hosted on G2.com.

Verified User in Civil Engineering

Small-Business (50 or fewer emp.)

7/30/2018

"Great DB, lots of community support"

5/5

What do you like best about PostgreSQL?

It's very easy to setup with cloud hosting providers like Heroku and GCP Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

command line tools for mac are unintuitive Review collected by and hosted on G2.com.

Eric M.

Principal Software Engineer

Computer Software

Small-Business (50 or fewer emp.)

10/24/2017

"Scalable, flexible databases for any use"

4.5/5

What do you like best about PostgreSQL?

Data of almost any format fits well in Postgres. You can use one database instance to house multiple databases, but also host multiple discrete schemas in each database (each with its own set of tables). The scope with which you can shape and manage data structures is remarkable! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some key features from other database systems (like UUIDs for identifiers) are not included by default and require installing separate extensions (pgcrypto for UUIDs). Forgetting to install an extension before importing data can lead to data loss and errors all over the place! Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Keep your data structures clean and ensure your relations don't blend across schemas too often. While cross-schema queries are possible, building your application to use them will limit you in terms of scalability should you ever wish to spread your database across multiple servers/instances. Review collected by and hosted on G2.com.

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

We use Postgres to host our primary application database. It's given us massive scalability by allowing us to tie multiple microservices together into one application. Review collected by and hosted on G2.com.