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/15/2022

"Great choice database for relational model structurr"

4.5/5

What do you like best about PostgreSQL?

Dynamic creation of tables/models differenciate from other databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing which I can think of and its best and mostly used database Review collected by and hosted on G2.com.

Krinal P.

Software Engineer

Mid-Market (51-1000 emp.)

9/11/2021

"PostgreSQL - is the greatest database software"

4.5/5

What do you like best about PostgreSQL?

The bash shell script may be used to perform psql commands. Execution time notifications should be shown in the data/log folder's log file. In order to maximise performance, a prepared statement is used.

PostgreSQL comes with built-in extensions. PostgreSQL offers a great deal of flexibility. Data types, indexes, functional languages, etc. may be customised. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

few tools can be integrated with MySQL but not with PostgreSQL. Review collected by and hosted on G2.com.

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

A relational database management system, PostgreSQL is a sophisticated, enterprise-class, open-source database management system. Data is saved in RDBMS tables, which are database objects that contain data. In a table, the columns and rows are used to group related data items. As a result of PostgreSQL, you may access and alter databases. Review collected by and hosted on G2.com.

Chandresh M.

System Engineer

Mid-Market (51-1000 emp.)

9/7/2021

"Good Database You Need"

4.5/5

What do you like best about PostgreSQL?

The thing I like about the PostgreSQL database is it is open-source available. So, I can modify it based on my business requirement. Another thing is, it is very easy to learn. You don't need any extra time to learn if you know a little bit of SQL. You can also import/export databases in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The Dashboard of PostgreSQL is very complex. Sometimes, you need to find what are the options you want to use. So first I have to read its documentation, then I'll understand, which required more time. Review collected by and hosted on G2.com.

ercument y.

ERP Software Development Specialist

Mid-Market (51-1000 emp.)

11/19/2021

"OpenSource DB"

5/5

What do you like best about PostgreSQL?

Being open source is very good in terms of license fees. It is advantageous to have easy backup and restore in postgre. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

postgre is a little weak compared to its alternatives in performance metrics. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is free and open source software. This means that you will never have to pay anything for this service. Review collected by and hosted on G2.com.

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

I am using the mobile application to keep the web service log information. The fast work of successful inquiries was a factor in my preference. Review collected by and hosted on G2.com.

Akshay P.

Freelance

Small-Business (50 or fewer emp.)

1/24/2022

"Easy to use"

4.5/5

What do you like best about PostgreSQL?

Easy to use and simple. I have used it couple of times but it doesn't feel like i am working on it for the first time Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The think which i dislike is the side panel which is congested Review collected by and hosted on G2.com.

Jimesh S.

Senior Software Engineer

Mid-Market (51-1000 emp.)

10/10/2021

"Postgresql is the Excellent ORDBMS"

5/5

What do you like best about PostgreSQL?

PostgreSQL supports geographic objects, which enables it to be used for location-aware services and geographic information systems. Queries are simple to write since they do not need any training. Additionally, PostgreSQL supports multiversion concurrency control(mvcc). Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

In order to complete the upgrade procedure, more storage will be needed. Review collected by and hosted on G2.com.

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

PostgreSQL is a commonly used Object-Relational Database Management System (ORDBMS) (ORDBMS).

As a result, businesses are increasingly turning towards PostgreSQL because it can handle massive amounts of complex data. This is the foremost reason behind PostgreSQL is more capable of coping with very stressful database conditions. Review collected by and hosted on G2.com.

adwaith p.

Python Developer

Mid-Market (51-1000 emp.)

10/26/2021

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

"Good database for django"

4/5

What do you like best about PostgreSQL?

It is very simple to use.

It is easy to use for a begginer compared to xamp Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

In some hosting platforms postgresql have payment to use Review collected by and hosted on G2.com.

Shubham M.

Small-Business (50 or fewer emp.)

10/28/2021

"Great Data storage tool"

5/5

What do you like best about PostgreSQL?

The easy to install and use database app for local storage or web applications Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I wish we could install postgres integrated in Visual Studio or Pycharm so it would be easy to check and not go back and forth. Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

4/29/2022

"Super great value database"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is open source so great value Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There isn't anything I didn't like about it. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

2/18/2022

"Very advanced RDBMS with a wide variety of data types to use"

5/5

What do you like best about PostgreSQL?

It is very easy to use for people who already know some basic SQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

performance-wise it is slower than MySQL Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is the best relational database amongst the options I feel Review collected by and hosted on G2.com.

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

I have loved working with Postgres as knowing SQL has definitely helped due to similar syntax. The join makes it all the more interesting once you start using them. Review collected by and hosted on G2.com.