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 Banking

Mid-Market (51-1000 emp.)

7/16/2018

"excellent DB that integrates with the package"

4.5/5

What do you like best about PostgreSQL?

reliability and total compatibility with Oracle DB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

probably the need for additional training Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

5/1/2018

"Best DB for Open Relational DB"

4/5

What do you like best about PostgreSQL?

I loved the Common table Extensions (CTE). This is one of the excellent feature you see in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I really don't see anything dislike. Moreover i am loving its features Review collected by and hosted on G2.com.

Curtis M.

Senior Test Automation Engineer

Small-Business (50 or fewer emp.)

10/27/2017

"Simple to use, Easy SQL management tool."

5/5

What do you like best about PostgreSQL?

Coming from a MySQL background it is very similar and allows me to manage my data in any way I see fit. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The PostgreSQL management tools out there today aren't the best. It's hard to find a GUI tool that allows me to manage my data simply. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are used to MySQL and are unable to use that for your database management needs, PostgreSQL is a great alternative. With all the other tools that are being offered right now, AWS and GAE, this is still light weight and open source. Review collected by and hosted on G2.com.

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

I have a lot of data that I need to keep historical track of and PostgreSQL keeps that all in one place that allows me to keep track of it. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

1/22/2018

"We use PostgreSQL for enhancing our functionality pertaining to Data storage as compared to RDBMS. "

3.5/5

What do you like best about PostgreSQL?

The best feature about PostgreSQL is that it is open source software with easily available user defined types and concurrency control. Also the newly added features of tablespaces in recent versions has made it very much comparable to other popular RDBMS available in the market thus making this a good option for replacing traditional RDBMS at a low cost. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I dislike the fact that PostgreSQL is not very much user friendly and finding documentation on postgreSQL is bit tedious making it difficult for supporting daily operations of business. Review collected by and hosted on G2.com.

Alex S.

Trans. Engineer 2: Survey Party Chief

Government Administration

Small-Business (50 or fewer emp.)

6/1/2017

"Excellent (and FREE!) Enterprise-Level DB."

4.5/5

What do you like best about PostgreSQL?

Several items: 1) it's FREE; 2) the ability to program functions and triggers in a variety of languages; 3) it is ACID-compliant which is extremely important to me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Although it will run on Windows machines, it does seem (to me) that PostgreSQL is much more at home on a *nix computer. I had some strange access/permissions issues with some Windows directories/files whereas on Linux it was a non-issue. Your mileage may vary. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is FREE! Review collected by and hosted on G2.com.

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

The NPO that I am assisting currently uses MS Access and has been doing so since circa 1992, with a very large number of data entry additions which were prone to error. Furthermore, their membership has grown from approximately 300 folks in 1992 to about 4,000 in 2017. This has made their existing setup a nightmare. I volunteered to normalize their data and streamline their data entry procedures with feedback from their current data manager with respect to possible refinements on the data entry forms. Essentially, we are implementing PostgreSQL as a back-end and because of the wide variety of tools available and its versatility, it should provide a large degree of DB future-proofing for the NPO. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

4/22/2018

"Great open source database"

4.5/5

What do you like best about PostgreSQL?

Extremely reliable, allows large amounts of data to be stored and accessed. Also very good documentation, great AWS RDS support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance management tools are lacking. The database engine is quite opaque when performance issues occur. It is quite hard to diagnose issues like 100% CPU or why some SQL plan is selected rather than some seemingly faster ones. Review collected by and hosted on G2.com.

Verified User in Consumer Electronics

Small-Business (50 or fewer emp.)

4/19/2018

"Robust and Versatile"

5/5

What do you like best about PostgreSQL?

Very accurate system. It works more than well in most scenarios. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The installation process is not the most straightforward ever. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Enterprise (> 1000 emp.)

7/9/2018

"Good for medium application"

2.5/5

What do you like best about PostgreSQL?

Open source and free to use is one of the thing Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

No good UI and ancillary tools is available in the postgres world Review collected by and hosted on G2.com.

Dustin F.

Analyst, Insurance Analytics - Marketing and Fraud

Information Technology and Services

Enterprise (> 1000 emp.)

1/30/2018

"Regular SQL with some nifty documentation"

4/5

What do you like best about PostgreSQL?

Whenever I had any questions, the well organized documentation allowed me to find answers quickly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

With so many versions of SQL, it is unavoidable to have some syntax differences. Not bab, but always takes some getting used to when switching. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

10/25/2017

"Great opensource relational database"

5/5

What do you like best about PostgreSQL?

As of yet, I haven't had any issues with Postgresql. I honestly don't think I've utilized it to its full potential. Some of the features that I've found very helpful are its upsert, or insert on conflict feature as well as the ability to have multiple schemas in order to support a multi tenant data model without having to use multiple databases. It is also quite easy to backup and restore, as well as create followers for high read capacity as well as automatic fallover. Also, we use Ruby on Rails coupled with Heroku for deployment, and Heroku has a great managed PostgreSQL service that makes utilizing all of its features really easy and painless. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I do wish there was a free tool similar to SQLPro for Postgresql on Mac. There are some paid tools. But I'm fairly cheap. The default management application PGAdmin is very featureful, but the UX isn't amazing, particularly for simple things. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It works really well for us using Ruby on Rails and deploying to Heroku utilized Heroku Postgres. Review collected by and hosted on G2.com.

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

We use PostgreSQL for almost all our relational database needs, typically for backend data storage for web and mobile applications. It has been fantastic and works great coupled with Ruby on Rails applications. Review collected by and hosted on G2.com.