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

8 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

PostgreSQL Integrations

(29)

Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL

G2 reviews are authentic and verified.

Here's how.

Niels M.

Head of Software Development

Small-Business (50 or fewer emp.)

10/20/2018

"PostgreSQL - The perfect database for our needs"

4.5/5

What do you like best about PostgreSQL?

One of the best feature of it is it's array datataype. We needed to define a table with a huge amount of floating data fields/columns. The normal column amount was restricted to 1300 fields. For our use case we needed more and dynamically. Postgresql offered us the array datatype double which doesn't restrict us in the amount of values and can easily be accessed by it's index. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The inhouse db managment tool is a bit slow and buggy. A shame they don't deliver one useful one with it. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

8/23/2018

"Complete Open Source DBMS"

4.5/5

What do you like best about PostgreSQL?

Open Source, so no licenses to pay.

Fully compliant with SQL (including inheritance, for example) and ACID.

Good performance and stability on large databases.

Extensible.

With the extension PostGIS, it is one of the most powerful DBMS for GIS, among both commercial and open source alternatives. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as simple to master as other alternatives such as MySQL (of course, it has more features).

No native clustering (there are some extensions trying to solve this).

Some GUI tools are not reliable, but you can always go back to command line to do whatever you need. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you need a relational DBMS, go with PostgreSQL. If you need a relational DBMS with support for geographic data or json data with complex queries, definitely go with PostgreSQL. Review collected by and hosted on G2.com.

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

DBMS for Information Systems, and Geographic Information Systems. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/3/2019

"Powerful and necessary"

3/5

What do you like best about PostgreSQL?

PostgreSQL is easy to like even when sometimes it is not easy to use. Our team likes how the data from vmware is gathered well inside of PostgreSQL and able to used/connected to for other uses and dashboard creation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes users of postgresql dislike how difficult it can be to access the data inside of the db without having to do some tricks to get to the data when it is locked down...but that can depend on what is creating the db. Review collected by and hosted on G2.com.

Samir M.

Small-Business (50 or fewer emp.)

7/10/2018

"Powerful, Lightweight, and feature packed"

5/5

What do you like best about PostgreSQL?

Postgres is great for what it is. A well packed version of SQL that does everything you need your database to do. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. If using it for standard data storage, Postgres has everything that you'll need. It's easily connectable to your codebase and the syntax is sql just with extra functions which make life easier. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgres is great for what it is, an easily implementable SQL database that plays nicely with other pieces of your system. Review collected by and hosted on G2.com.

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

We're using Postgres as half of our back end data store. It's not a triple store, so we need a second database to accomplish that, but most of our system is run thru Postgres Review collected by and hosted on G2.com.

Verified User in Computer & Network Security

Small-Business (50 or fewer emp.)

3/7/2019

"Once and never again"

2/5

What do you like best about PostgreSQL?

Its free, good for wordpress, but it really let me down with an important project Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sorry but postgresql let me really down, unrepairable database Review collected by and hosted on G2.com.

Verified User in Defense & Space

Mid-Market (51-1000 emp.)

4/6/2019

"Great for academics"

4.5/5

What do you like best about PostgreSQL?

I do like the open source nature of it, as well as the ease of use when setting up a DB using Python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It isn't as versatile as other software such as mySQL. Review collected by and hosted on G2.com.

George G.

GIS & Database Developer

Small-Business (50 or fewer emp.)

6/27/2018

"The go to Spatial Database"

5/5

What do you like best about PostgreSQL?

Excellent performance on handling and manipulating Spatial Data. Free and Open Source. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The lackluster and inconsistent front end management studios. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you wish to hanlde spatial data in any way PostgreSQL is the way to go. Works well with everything, it is really easy to develop and maintain and has a ton of tools setup around performance (e.g. PgBouncer). The PostGIS spatial extension is the best perfomance-wise (e.g. GIST Indexing) and most complete toolkit in the market (especially true for 2D data). It doesn't have a great Management Studio but PgAdmin has come a long way and the extremely dilligent documentation makes up for that. It is free, it has a growing active community, it's the fastest growing Relational Database and the best one as of date for spatial data. PostgreSQL is the way to go. Review collected by and hosted on G2.com.

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

Storing, handling and serving spatial data on my GIS & WebGIS applications. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

4/10/2019

"Good database "

5/5

What do you like best about PostgreSQL?

I have been using postgresql for 8 years as a lead developer. We prefer it over MySQL Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I dislike is that it can be difficult to set up as a local environment. Review collected by and hosted on G2.com.

Soumyajit P.

Data Scientist

Oil & Energy

Small-Business (50 or fewer emp.)

12/21/2018

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

"Best SQL Query tool in the market"

5/5

What do you like best about PostgreSQL?

The ease of data base management system. Its simple user dashboard and quick cloud response time. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing specific dislikes. Sometime there are server errors. You could have a review on that. Review collected by and hosted on G2.com.

Verified User in Automotive

Mid-Market (51-1000 emp.)

3/26/2019

"Lightweight and Open Source"

4.5/5

What do you like best about PostgreSQL?

PostGreSQL is easy to implement and administer and is self sustaining for large databases. It's open source so a big cost savings compared to Oracle or SQL Server Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance is not optimal on low latency disks Review collected by and hosted on G2.com.