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.
Verified User in Marketing and Advertising
AM
Mid-Market (51-1000 emp.)
"Open Source DBMS with vast community and Consistent Developments"
What do you like best about PostgreSQL?

One of the best open source DBMS available and a lot of community support in mailing lists, social platform etc Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Streaming Replication Not Possible across Different PostgreSQL Versions

Selective/Logical Replication is available in latest version 9.10. Still need some time for this feature to gain stability Review collected by and hosted on G2.com.

Nadim H.
NH
Senior Web Analyst
Mid-Market (51-1000 emp.)
"A very convenient DBMS!"
What do you like best about PostgreSQL?

I like the ease of use, that it supports almost all sql contructs, free, and suitable to most projects, small or large Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The UI could be updated, but for a database server the current does the job and more Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise (> 1000 emp.)
"SQL Use and Review"
What do you like best about PostgreSQL?

Robust, efficient and productive software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

That it crashes from time to time which has me having reboot and reinstall Review collected by and hosted on G2.com.

Verified User in Information Services
CI
Enterprise (> 1000 emp.)
"Used for Blood hub application integration using PostGreSQL"
What do you like best about PostgreSQL?

Easy to use, small learning curve and light weight

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Heavy enterprise applications may not be able to use it. Review collected by and hosted on G2.com.

Verified User in E-Learning
UE
Small-Business (50 or fewer emp.)
"Great experience"
What do you like best about PostgreSQL?

Its very easy to use and learn. I have used it for a long time. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing I dislike about this tool. Review collected by and hosted on G2.com.

Verified User in Information Services
CI
Small-Business (50 or fewer emp.)
"A serious DB for serious usage"
What do you like best about PostgreSQL?

PostgreSQL's reliability and robustness is impressive. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing comes to mind when thinking about negatives. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Enterprise (> 1000 emp.)
"PostgreSQL is a good database software. "
What do you like best about PostgreSQL?

Easy to load database and write queries to fetch data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It was kind of slow.Loading large datasets took lot of time Review collected by and hosted on G2.com.

Verified User in Telecommunications
AT
Mid-Market (51-1000 emp.)
"PostgreSQL - OpenSource DB"
What do you like best about PostgreSQL?

It's free and easy to use. We had software that would use this DB to keep and modify data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could be more intuitive, the graphical user interface could be improved. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Enterprise (> 1000 emp.)
"works smoothly with our PKI software"
What do you like best about PostgreSQL?

Runs steadily with no major upkeep required Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Haven't used much hands-on other than initial setup and config, so not much to dislike. Review collected by and hosted on G2.com.

Verified User in Retail
UR
Mid-Market (51-1000 emp.)
"Satisfied customer"
What do you like best about PostgreSQL?

Very satisfied with PostgresQL database, ease of use and the functionality it provides for our business. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is really nothing I dislike about the product. 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