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 Information Technology and Services

Small-Business (50 or fewer emp.)

4/21/2022

"Great open-source database system"

4.5/5

What do you like best about PostgreSQL?

It is completely free, easy to set up, extremely robust, and has great performances on concurrency, transactions, and schema. It is also well-supported so new features and improvements are rolled out frequently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For large-scale enterprise applications, PostgreSQL is slow. Horizontal scaling is difficult and a culprit. Could use improvements for JSON. Not a lot of online documentation and resources available compared to MySQL. Review collected by and hosted on G2.com.

Anish Mahesh S.

Gasoline Blend Optimization Engineer

Small-Business (50 or fewer emp.)

4/24/2022

"Not just another SQL"

5/5

What do you like best about PostgreSQL?

Intuitive front end and GUI. Quickly becoming an industry favourite Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The interface could be an acquired taste to some but it does take some while to get used to Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

6/10/2022

"PostgreSQL Review"

4/5

What do you like best about PostgreSQL?

PostgreSQL provides us much more Datatypes that are not present in Oracle or Mysql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slow as compared to Oracle Database Review collected by and hosted on G2.com.

Savan S.

Senior Software Engineer

Enterprise (> 1000 emp.)

1/30/2022

"Invaluable RDBMS with MVCC"

4.5/5

What do you like best about PostgreSQL?

In terms of security, it has one of the most advanced locking mechanisms available. It has a large amount of storage space and is well-known for the integrity of its data. Server-Side Programming features that are mature. Due to robustness, many dynamic websites and online apps rely on PostgreSQL as their back-end database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Column re-ordering is not available,

slower than MySQL Review collected by and hosted on G2.com.

Gajendra K.

Technical Team Lead

Enterprise (> 1000 emp.)

3/5/2022

"Very complete and stable database"

5/5

What do you like best about PostgreSQL?

It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installment and handelling of initial infrastructure is big complex. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

2/12/2022

"Found helpful for storing large transactional logs"

4/5

What do you like best about PostgreSQL?

PostgreSQL was a cost effective option to choose from RDBMS. It was easy to configure and get setup. As it is similar to other RDBMS in market so learning this by other team members was not complicated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We want to move some of our workloads from other RDBMS to Postgres, but couldn't find any suitable tool. Also, some dashboard to see the health and statistics of Server, DB and table would be helpful. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

2/9/2022

"Cheap and Fast alternative to Enterprise Level DB requirements (beats MSSQL)"

2.5/5

What do you like best about PostgreSQL?

I like that its free, open source, and very fast. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Connecting requires a local daemon running and using the web browser (they have a windows app, but it is just the browser wrapped in the app using Electron). Deployment is a bit trickier than MySQL but easier than MSSQL Server, considering the price being free, its not much of a concern) Review collected by and hosted on G2.com.

Verified User in Music

Mid-Market (51-1000 emp.)

1/11/2022

"PostgreSQL"

3/5

What do you like best about PostgreSQL?

I have used this as this was free and so to save product cost client wanted to migrate from SQL to PostgreSQL. There are some offcourse syntax changes but overall logic remains same. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing to dislike as such but ya but 1 thing i would like to point out, it doesn't contain every method which is used is sql. So there are some changes which you need to do if you are looking for a migration. Not all collation such as sql latin1_general_ci_as for eg are nt available. Review collected by and hosted on G2.com.

Sagar D.

Software Architect and developer

Small-Business (50 or fewer emp.)

6/21/2021

"Great scalable db for small and large project"

4/5

What do you like best about PostgreSQL?

I like how this database could handle extensive data and small data. I have been using it for lots of small projects as well as for large project that handles data processing and event-driven projects. It's good to see such flexibility in heavily read-write processes. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I dislike about it is the GUI to handle all the operations are not that user-friendly compared to what mongo DB or MySQL has. I wonder if the Postgres team gets to have some good UI UX for postgres as well. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

GUI for managing Postgres is a bit complicated, and you should continue considering that you might have some bad experience with Postgres. Other than that, Postgres is excellent if you have huge read and write operations. Review collected by and hosted on G2.com.

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

I am using PostgresSQL on heavy read write application, and analytics project for huge data. Along with that working on projects for small scale project general management project.

The main benefit that I saw with using PostgreSQL is that its good for small and large project. I could use the same db server for large project while development and also small projects as well without having to thinking much on performance changes for small and large project. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

5/9/2022

"One of the best solution for RDBMS"

5/5

What do you like best about PostgreSQL?

PostgreSQL is one of the best available open-source relational database management systems. Available on all the platforms. GUI is also available which is again the best thing. Review collected by and hosted on G2.com.