The G2 on PostgreSQL

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find PostgreSQL's ease of use exceptional, praising its user-friendly interface and straightforward setup. (14 mentions)

Users appreciate the robustness and feature-rich capabilities of PostgreSQL, highlighting its extensibility and community support. (8 mentions)

Users appreciate the open source nature of PostgreSQL, enhancing accessibility and flexibility for various applications. (7 mentions)

Users value the exceptional customer support of PostgreSQL, benefiting from its robust community and extensive features. (4 mentions)

Users value the easy integrations of PostgreSQL, simplifying their development process with seamless cloud connectivity and user-friendly tools. (4 mentions)

Users find PostgreSQL beginner-unfriendly, as its complex documentation makes initial usage challenging for newcomers. (7 mentions)

Users find the difficult learning curve of PostgreSQL challenging, especially during initial setup and feature understanding. (5 mentions)

Users experience slow performance with PostgreSQL, particularly during large data queries and when importing CSV files. (5 mentions)

Users find feature limitations in PostgreSQL, noting fewer configuration options and GUI tools compared to competitors. (3 mentions)

Users find the initial setup complexity of PostgreSQL challenging, especially for newcomers, despite its powerful features. (2 mentions)

Top Rated PostgreSQL Alternatives

RaimaDB

Visit Website

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.

Juan Carlos G.

Software Engineer

Information Technology and Services

Mid-Market (51-1000 emp.)

12/21/2017

"An alternative to traditional RDBM"

3/5

What do you like best about PostgreSQL?

It has a great performance, specially to handle big volumes of data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its query language is not the standard SQL, so a learning curve is necessary. Fewer tools that interact with it, and also less documentation is a concern. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Don't be afraid of the learning curve, it's a good first step to later enter the world of NoSQL databases. Review collected by and hosted on G2.com.

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

It was used as a demonstration of non traditional databases, it handled everything we throw at it. It has better support for json types. Review collected by and hosted on G2.com.