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 Education Management

Small-Business (50 or fewer emp.)

4/19/2022

"PostgresSQL is a powerful database"

5/5

What do you like best about PostgreSQL?

It's very easy to set up, especially when using a managed service from a cloud provider. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Migrating when there are version upgrades can be a bit of a pain. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

2/8/2022

"PostgreSQL is open source for all OS"

4/5

What do you like best about PostgreSQL?

PostgreSQL is open source, and we can use it in any OS like Windows, Linux, etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A stored procedure is not fully supported here, and we can not return a dynamic table. Also, his output window returns only a single query result. Review collected by and hosted on G2.com.

Naveed A.

Angular & React Developer

Small-Business (50 or fewer emp.)

4/20/2022

"PostGreSQL Developer Experience"

4/5

What do you like best about PostgreSQL?

The relations among the tables to avoid duplicate data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Limited JSON data support therefore we need many number of tables Review collected by and hosted on G2.com.

Verified User in Automotive

Enterprise (> 1000 emp.)

12/26/2021

"Working on SQL with PostgreSQL"

5/5

What do you like best about PostgreSQL?

The code/Query you type in the database, if overwritten by another new query by user, the previous query /Queries will still be available in the history, which you can easily refer to and copy the old code Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There's not much to Dislike to be honest - but every database may have some or the other query restricted limitations. Such as, in PostgreSQL I could'nt use the LIMIT command and few more - which were working in MySQL server. But other major things were working fine only. Review collected by and hosted on G2.com.

Prasad B.

Principal Consultant

Enterprise (> 1000 emp.)

4/27/2022

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

"SQL with most user friendly behaviour."

5/5

What do you like best about PostgreSQL?

- Easy to code and interpret.

- DB compatible Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Need to get more in-built libraries and opcodes. Review collected by and hosted on G2.com.

Franco M.

PLSQL Developer

Small-Business (50 or fewer emp.)

4/21/2022

"Postgresql solve it for free"

5/5

What do you like best about PostgreSQL?

It's similar to oracle and mysql but it's free Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UI is not the best. Could be even better. Review collected by and hosted on G2.com.

Jagruti P.

Senior Analyst

Enterprise (> 1000 emp.)

7/25/2021

"PostgreSQL Review and experience on my point of view"

4.5/5

What do you like best about PostgreSQL?

- Simplicity and flexibility compared to other SQL databases.

- Logging is available for each and every activity if you eneabled that so its easy to understand if some users has changed any data.

- We can use complex data types which is available in postgres like geographic objects which help us to manage location data in the database if your application needs to manage user or other location.

- English Documenetation available for easy of use and that will not take much time to learn this database Software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- The speed of fetching data is very low compare to others.

- Each and every open source software not support PostgreSQL compare to mySQL which support most of each and every open source sotware. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Check your requirement before choosing this database or any other relational database. If your condition is to read data from the database too frequently, then it might be slowness shows in your whole application. Review collected by and hosted on G2.com.

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

- Firstly, I solved many issues using this database. I like it the most because we can use both the console and User interface to manage the database.

- Secondly, we can use easily use AWS RDS to manage this database as RDS contains its configurations.

- Third, My requirement is to read data from Queue and then process data and store in database based on schdeuler which is run timely basis so I didnt find any slowness in my system bacase all things are managed at background level. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

4/22/2022

"Performance packed database"

4/5

What do you like best about PostgreSQL?

When you think about the performance of a database and it's robustness postgresql is the best option. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Pg admin should be simplified,some times split windows are too crowded to look at. Review collected by and hosted on G2.com.

Charlie O.

CTO

Small-Business (50 or fewer emp.)

11/16/2021

"I've learned to use Postgres for everything unless there's very good reason not to"

5/5

What do you like best about PostgreSQL?

Postgres is rock solid, widely available, and very performant. In my opinion it is usually best to start with everything in Postgres and spin things out as you scale. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much; integrated connection pooling would be nice. And a native column store option. Review collected by and hosted on G2.com.

Wade W.

Director of Information and Analytics

Mid-Market (51-1000 emp.)

7/27/2021

"THE preferred solution for an open source relation database"

5/5

What do you like best about PostgreSQL?

Postgres has many of the features that I have come to enjoy in more enterprise-scale databases, with the benefit of an open-source pricetag and community support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you are looking for a vendor, Postgres isn't your tool. In many ways though, that is a positive. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are comfortable doing a little sys admin work to get it up and running, you probably already know that Postgres is the way to go. Review collected by and hosted on G2.com.

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

Postgres was our primary data store for many years for our centralized data warehouse. Any relational data can be stored in Postgres, and there is broad support for clients and other tools to interact with that data. Review collected by and hosted on G2.com.