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

Small-Business (50 or fewer emp.)

7/30/2018

"Flexible and powerful"

4/5

What do you like best about PostgreSQL?

It's a full on relational database with good tooling and an extensive community. Even better it's got built in support for json and array types and even has full-text search features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It requires some care and feeding, and like all relational databases works best with well-structured data. Review collected by and hosted on G2.com.

Verified User in Financial Services

Small-Business (50 or fewer emp.)

8/3/2018

"Excellent OpenSource Database with impressive performance and scaling capabilities"

5/5

What do you like best about PostgreSQL?

Postgresql is open source, easy to setup, easy to replicate and backup. The "Select Distinct On" function really helps in seeking the right unique data from large data sets. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I would like to see better documentation about configuration parameters as well as optimization parameters that can be applied to the DB setup. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

12/26/2017

"Excellent open source object-relational database management system "

4/5

What do you like best about PostgreSQL?

Once you've used it for awhile, it's natural. It's easy to see all the data you need, doesn't overcomplicate things either. Wildcard Search queries are simple and I love the number of extensions there are available for developers to take advantage of.

I enjoy using the PostgreSQL app on Mac OSX. I always know when I have it running because I can see the icon on the top of my Desktop. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installation can be tricky your first time around. I just helped a new developer set it up and it only took a few minutes of looking at the docs to give myself a reminder. The new developer was overwhelmed by the PostgreSQL documentation that he had kinda given up. After that, you'll quickly get the hang of it. PostgreSQL query syntax for more complex queries can be difficult and take a moment to learn but once you've gotten the hang of them, you'll be fine.

Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Although the documentation is a bit overwhelming at first glance, take some time and read through it. It'll help you in the long run and it's really not the scary. Review collected by and hosted on G2.com.

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

We use as our main database for 5 different projects. We've never had any issues and we like the flexibility it offers us. Review collected by and hosted on G2.com.

Verified User in Accounting

Mid-Market (51-1000 emp.)

7/31/2018

" good pretty and cheap"

4/5

What do you like best about PostgreSQL?

It is easy to use and configure this produc Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the Latino user community is not very big Review collected by and hosted on G2.com.

Antonio R.

Analista de Gestion TIC

Enterprise (> 1000 emp.)

12/20/2017

"A performant open source alternative to Oracle and SQL Server"

4/5

What do you like best about PostgreSQL?

It is open source, it means we can look at the code and help to improve the product and troubleshoot bugs Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it is very strict on its SQL language, Mysql lets you slack a bit, postgresql does not. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Read a lot about SQL, it uses strict language so you cant get away with things like In MYSQL. I recommend Heidisql to use with Postgresql, it is a great front end. Review collected by and hosted on G2.com.

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

Data storage, We migrated an entire database from aging Oracle and SQL server to postgresql and we are very happy with it. We currently have many databases with it and we love it. Everything we think of a new product we choose Postgresql without a doubt. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

10/7/2018

"Easy access to database"

5/5

What do you like best about PostgreSQL?

I like the command line interface and the ease of use of SQL to query the database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There really wasn't anything I disliked about PostgreSQL. Review collected by and hosted on G2.com.

Verified User in Internet

Enterprise (> 1000 emp.)

11/1/2018

"easy to use for biz people"

4/5

What do you like best about PostgreSQL?

easy to use. fun to learn . and it's very powerful Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UX can be improved . but it serves the purpose and better than others. Review collected by and hosted on G2.com.

Mithul G.

Software Engineer

Enterprise (> 1000 emp.)

8/16/2018

"Great DB!"

5/5

What do you like best about PostgreSQL?

Ease of queries and intuitive ways to search. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Harder to get community support, replication is not that well implemented Review collected by and hosted on G2.com.

Hari A.

ECM Developer

Information Technology and Services

Small-Business (50 or fewer emp.)

12/26/2017

"Postgres is the most effective Open source Database"

5/5

What do you like best about PostgreSQL?

It's open source. So, its great for startup companies. It is fully SQL compliant. The admin tool PGAdmin is powerful. I am impressed with the custom data types supported by Postgres mainly JSONB. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We faced problem while using custom data types like JSONB. Inserting data to these type of columns via Hibernate is not straightforward. We referred a couple of articles on that to resolve the issue. https://github.com/thjanssen/HibernateJSONBSupport/tree/master/PostgresJSONB Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgres is the most effective Open source Database Review collected by and hosted on G2.com.

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

We are using Postgres as a database choice for a custom product development. This database will contain a large amount of data. As an open source, it provides enterprise level RDBMS functionalities. Review collected by and hosted on G2.com.