Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

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

MySQL
(1,636)
4.4 out of 5

638 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
SW
Software Engineer
Small-Business (50 or fewer emp.)
"Review for PostgreSQL"
What do you like best about PostgreSQL?

PostgreSQL is one of the best choice when it comes to managing relational databases and it is available to use for free! It provides an ease of use to its users. It allows developers the freedom of using many languages eg. Python for scripting. It works well with large amount of data too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Processing big data is need of the day and very much required in all businesses. Even though postgreSQL can support large databases, It is not suitable for big data due to large computation time. Review collected by and hosted on G2.com.

eleomar d.
ED
Reviews sobre sistema operativo windows 7
Small-Business (50 or fewer emp.)
"Review about PostgreSQL"
What do you like best about PostgreSQL?

I like the way it manages the database and connectivity, and the version is free and unlimited. It is stable and reliable, very secure.

Very secure when storing information and stable on different operating systems. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it does not have online or phone support but rather a forum where your questions will be answered.

it tends to be slow in insertion and updating in low-volume databases, it is oriented towards databases with large storage capacity. Review collected by and hosted on G2.com.

Verified User in Entertainment
UE
Small-Business (50 or fewer emp.)
"PostgreSQL is great for database management!"
What do you like best about PostgreSQL?

PostgreSQL allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources. Review collected by and hosted on G2.com.

MD
CTO
Mid-Market (51-1000 emp.)
"Backbone of our stack"
What do you like best about PostgreSQL?

Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic. Review collected by and hosted on G2.com.

Ahmadou N.
AN
Soccer Referee
Enterprise (> 1000 emp.)
"Database as you know it"
What do you like best about PostgreSQL?

I pretty much enjoy the elastic factor in its design and implementation. Offers a huge deal with data storage and security. As compared to MySQL and other database systems, PostGresSQL stands out as the go-to database when it comes to data redundancy and better maintenance.

The pricing is not bad either and cloud solutions providers offer great supports. I should know, I use them whenever I need. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The setup is not that easy mostly on the Linux environment. The user has to have a better knowledge about the installation and usage before engaging on this database choice but it is worthy to spend time and energy learning. Review collected by and hosted on G2.com.

Verified User in Education Management
UE
Enterprise (> 1000 emp.)
"An Open source database for small to large scale organizations for free"
What do you like best about PostgreSQL?

The PostgreSQL server has the advantage of having the security features of a paid service database, and the features of an open source database such as contact support, strong customer base which makes the service unique. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There are few technical glitches while trying to login using PostgreSQL server, because of this issue I had to uninstall the application multiple times to login into the server. It also has a problem regarding the duplication and restoring the database. Review collected by and hosted on G2.com.

EW
Database Administrator
Small-Business (50 or fewer emp.)
"Postgres is probably the best relational DBMS in the node community"
What do you like best about PostgreSQL?

Postgres is very stable. Borrows some features from both relational database systems and NoSQL databases giving it very complex and powerful hybrid features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Although postgres has been growing recently, it is not easy to find a professional who is well trained in postgres compared to other more popular DBMS like MySQL, Microsoft SQL and Oracle Review collected by and hosted on G2.com.

DG
Software Engineer
Small-Business (50 or fewer emp.)
"A good open source database"
What do you like best about PostgreSQL?

The simple GUI, combined with the CLI commands - makes this database very easy to use. Additionally, the fact that it is open-source and powerful makes it a go-to database for everyone. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

No dislikes as of now. PostgreSQL being such a good open-source database, one would have to nit-pick really hard to find out something. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Mid-Market (51-1000 emp.)
"Easy database to setup and configure"
What do you like best about PostgreSQL?

Good open source database that implements the SQL standard. Very easy to administer, and standard SQL works well with it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Their internal database commands in psql are a little confusing at times. Commands like \d \d+ etc. QL Review collected by and hosted on G2.com.

Yuriy P.
YP
Senior Software Engineer (Blockchains Infrastructure) @ Fireblocks
Small-Business (50 or fewer emp.)
"Best choice between compatitors. "
What do you like best about PostgreSQL?

Open source.

Huge plug-ins offerings.

Great documentation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Less known than MySql for example.

Less used by enterprise companies,

No official support representative for solving problems. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL