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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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.
Biruk T.
BT
Sr. Database Administrator
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integration with tools like pgAdmin and support for Oracle compatibility. Their technical documentation and support response times were impressive during our migration phase. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Pricing for some enterprise tools can be expensive for small teams. Also, while support is strong, initial onboarding for complex configurations (like replication or migration) could benefit from more hands-on guidance or clearer tutorials. Review collected by and hosted on G2.com.

Verified User in Accounting
UA
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in JSON support makes it an excellent choice for handling semi-structured data without sacrificing relational capabilities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication and clustering can be more manual compared to solutions like MySQL’s built-in replication Review collected by and hosted on G2.com.

saif eddine m.
SM
i can't tell
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

What i like most about PostgreSQL is the ergonomic interface , easy to understand . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I didn't actually encounter any Problems or downsides . Review collected by and hosted on G2.com.

Akshay P.
AP
Data Science And Business Analytics intern
Retail
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

One of the best part is Open source, Handle large datasets, strong security, easy to use and most important community support. Also It provide advance features like: support complex qeries, Custom functions Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

one thing i.e. fewer GUI tools compared to other database like MySQL Review collected by and hosted on G2.com.

Diego G.
DG
Engineering Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments Review collected by and hosted on G2.com.

NAYAN  K.
NK
Data Scientist
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There should be some more extensions with widely used open source software/apps. Review collected by and hosted on G2.com.

CHIRADEEP B.
CB
Associate Technology
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Very easy to use and set up

PostgreSQL comes with a very easy to use UI ( User Interface ) tool like PG-Admin for every client to connect & Interact with the database.

PG Admin is very easy to use & setup with just a mouse click unlike other traditional RDBMS .

I highly recommend PostgreSQL for every client to connect & Interact, apart from MYSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such, sometimes query execution get delayed but that is very rare.

Overally its a very light-weight & user friendly tool for ervery client who want to connect with the database seamlessly.

I Review collected by and hosted on G2.com.

Ashwini B.
AB
Software Developer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is easy to use in daily development life. Developer can easily implement and integrate it into system by using gem postgres. It has different versions for operating system. It is open source relational database model and i can use it in operating system like window , ubuntu, mac ect. Most of the developer use it frequently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When i execute large data query or complex query application stop responding. It has enormous number of users so customer support may take time to resolve query. Review collected by and hosted on G2.com.

Aavinashh L.
AL
Manager Dashboards and Business Intelligence
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has one feature that needs improvement on resources useage as it uses lots of your system resources. Review collected by and hosted on G2.com.

Rodrigo A.
RA
Media Activation Manager
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It's super easy to understand, implement, and adapt to any data lake. PostgreSQL has implemented many features to facilitate joint and data selections Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't complain about anything about postgreSQL Review collected by and hosted on G2.com.