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.

Ross M.

Corporate GIS Data Coordinator

Government Relations

Enterprise (> 1000 emp.)

11/29/2017

"PostgreSQL - the heart of our GIS"

5/5

What do you like best about PostgreSQL?

PostgreSQL with PostGIS and pgRouting offers us a flexible, robust and reliable open source database platform on which to build the rest of our GIS infrastructure. The open source license gives us the freedom to install and use it as we like. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If I had my way I would switch out all our other RDBMS for PostgreSQL. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL offers a solid database platform on which to build applications for organisations not willing to pay large annual maintenance fees. It scales well from small single use applications to large clustered enterprise-wide systems. The open source license lets you install as many instances as you need for free. The open source, standards compliant database allows you complete flexibility in designing the database and any applications it underpins. PostGIS and pgRouting are database extensions that add greatly to the capabilities of the product and are core to our GIS infrastructure. Documentation for the product is second to none and the user community is excellent. If you so wish, support contracts are available from a number of suppliers in the UK and internationally. PostgreSQL is also available from many cloud service suppliers and runs on all major operating systems. Review collected by and hosted on G2.com.

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

PostgreSQL replaced Oracle at the heart of our GIS infrastructure. We have saved money on software licenses, reskilled a number of people in database administration and reduced the number of files stored in directories to almost zero by putting the data in the database. The database is becoming the single source of truth for all spatial data in the organisation. The flexibility offered by the database has improved the efficiency of a number of different data creation and maintenance workflows and as a result we have grown the number of users from 10 to 75. Review collected by and hosted on G2.com.

Denish P.

LinkedIn Learning Instructor

Small-Business (50 or fewer emp.)

1/19/2018

"The best open source database product "

5/5

What do you like best about PostgreSQL?

Postgres can be used as multi-model database

- RDBMS

- Document store

- Search Engine

- Geo spatial database

- Key-value store

- JSONB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of mature GUI tools

Built in sharding support Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are using any closed source database, you should explore Postgres. I have converted a couple of Oracle and MongoDB applications and users love it! Review collected by and hosted on G2.com.

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

Postgres should be your first choice for the data store for mission critical applications. You can use Postgres to store any data and you don't have to look for other database systems to store various kinds of data. Postgres FDW helps to connect to your existing databases i.e SQL server, Oracle, MySQL, Hadoop, Cassandra so Postgres should be hub for your all your data needs Review collected by and hosted on G2.com.

Alexander C.

Consultor Tecnico - JavaDeveloper

Mid-Market (51-1000 emp.)

7/5/2018

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

"robust and stable"

4.5/5

What do you like best about PostgreSQL?

easy to use, one of the best database managers to develop complex applications, apart from being robust and simple. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is usually very basic, it would require more functionalities to be of this tool, a more complete tool, additionally the installation is usually somewhat tedious as it requires certain dependencies. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

4/26/2018

"Awesome Tool!"

5/5

What do you like best about PostgreSQL?

The best things I like about PostgreSQL is all the functions and tools it provides to perform fast querying and calculations. Also I actually love how it integrates with other tools such as Postgis, that we used it to draw polygons and check if certain coordinates where inside these or not. It worked incredibly fast. Finally I love psql, is my goto tool, really fast to open a new connection to a database and perform queries right away over this one. I also love that the tool is open source, I'm a big supporter of that Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't dislike much about it, just that sometimes the querying is kind of slow when you are trying to get loads of data out of the db. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is a tool that has a huge community around it that it is always there to help through the different communication channels you have. Moreover it is really easy to set it up and also not difficult to learn. So developers will be able to reach a high level of understanding in little to no time. Review collected by and hosted on G2.com.

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

We are storing large amount of data in our db's to later perform analytics with it. The main benefits we've realize while using it is the large amount of functions and transformation we can perform while querying. It actually makes our life easier. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

3/27/2018

"Great Alternative to traditional Commercial Databases"

4/5

What do you like best about PostgreSQL?

PostgreSQL has grown in both popularity and features. It is now on par with many of the commercial database servers. Because of its popularity, if you need commercial support, you can find it. If you can go it all alone, you can save you (and your company money). It is available for many OSes to suite your needs Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Windows support has lagged behind Linux/Unix for a number of years. Some of the tooling feels weird when you run it on Windows. I think if they want better adoption on Windows, they should create native (non-cli) tools. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security

Enterprise (> 1000 emp.)

11/24/2018

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

"PostgreSQL is a best choice database for small to medium size organizations"

4.5/5

What do you like best about PostgreSQL?

Light wait. quick installation, Great documentation, Hundreds of online forums Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Partitioning is not as good as Oracle. PostgreSQL slows down when joining very large fact tables in VLDB environment. Review collected by and hosted on G2.com.

Verified User in Retail

Enterprise (> 1000 emp.)

1/3/2019

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

"PostGRES is same as Oracle SQL"

4/5

What do you like best about PostgreSQL?

PostGres follows ANSI SQL like Oracle does Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Less documentation and not like Oracle which have mature documentation Review collected by and hosted on G2.com.

Sharon L.

Small-Business (50 or fewer emp.)

7/30/2018

"PostgreSQL is a reliable data storage system"

4.5/5

What do you like best about PostgreSQL?

It is really compatible with other SQL languages and is very easy to use for persistent data storage. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Generally, PostgreSQL has a slight learning curve for newer developers to SQL. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Enterprise (> 1000 emp.)

10/19/2018

"High performant MPP - Postgres"

4/5

What do you like best about PostgreSQL?

The parallel processing capability and scalability of PostgreSQL. Opensource Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It could have more monitoring tools as provided by other implementations of PostgreSQL Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

7/31/2018

"Reliable and Configurable Relational DB"

4.5/5

What do you like best about PostgreSQL?

The best thing about postgres is that it is open source and you can install many extensions to make it perform the way you want. It has extensions for distributed storage and even GPU support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular but one of the cons of this database is that it is not meant to handle large volumes of data effectively. Review collected by and hosted on G2.com.