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 Information Technology and Services
CI
Enterprise (> 1000 emp.)
"light weight opensource DB"
What do you like best about PostgreSQL?

Its opensource, lightweight DB. It provide good features to play with JSON structured data. More intuitive features available like filter , sorting , structuring data using Json syntax.

Most preferable db on cloud. very easy to optimize and analyze query performance . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

crash when play with millions of data. quiet slow processing with millions data. Need to setup always custom configuration for best performance. some Query syntax is different from other PL/SQL Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Mid-Market (51-1000 emp.)
"PostgreSQL experience review"
What do you like best about PostgreSQL?

Easy error recovery options like deleting and altering tables etc. in a given database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no clear documentation available on the official website , the search is is not good related to finding docs,especially once related to configuring the database itself on the machines and different OS. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Mid-Market (51-1000 emp.)
"I used it a project "
What do you like best about PostgreSQL?

I like the easyness and the reliability of this. I 7sed various features of posgresql and found it very easy and useful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I used it from command line 0f linux server. I don't if there is any tool for graphical use. I missed that part. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Cost savings and open source."
What do you like best about PostgreSQL?

We are using postgresql since 1 year, Eady and readymade query operations such as upadte delete,insert is very helpful and as compare to other database vendors postgresql is very scalable as well as powerful and simple to learn. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Need more stabilisation some functionality like when we are inserting data into row without query we are unable to insert but 'edit' option is available and connection issue need to fix. Review collected by and hosted on G2.com.

WM
Hardware Specialist
Small-Business (50 or fewer emp.)
"Great relational database with fantastic syntax"
What do you like best about PostgreSQL?

PostgreSQL is a standardized way to store and query data as necessary. It's intuitive and easy to use as a language and database so to speak. The methods are relatively standardized and haven't changed in years. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The databases are varied and sometimes are not consistent. Many providers have their own flavor of PostgreSQL Review collected by and hosted on G2.com.

KG
kritika
Enterprise (> 1000 emp.)
"best sql database"
What do you like best about PostgreSQL?

my compony is using this database from last 10-12 years. very easy to use, provides security by default. Provides easy setup.

Good integration with big data frameworks and vms. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

its gui tool i.e, PgAdmin is very very slow. Review collected by and hosted on G2.com.

Pedro P.
PP
Web Developer
Computer Software
Small-Business (50 or fewer emp.)
"fast and great DB, "
What do you like best about PostgreSQL?

Postgres is a great DB, allow you to do everything that others DB, but additional I found I can use pg_notify to send some kind of broadcast notification, this is great and an option to communicate to others software Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

sometime the backup/restore process is not 100% good, some issues restoring DB Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business (50 or fewer emp.)
"Data store , database "
What do you like best about PostgreSQL?

Simplified queries and the performance in result fetching Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much we can say I dislike , completely suitable for data store and fetch. Review collected by and hosted on G2.com.

Rob D.
RD
Senior Systems Administrator
Small-Business (50 or fewer emp.)
"Enterprise Windows/Linux Admin"
What do you like best about PostgreSQL?

simple low cost setup works with many applications and web hosts. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

i have no cons with this product pg admin is great also! Review collected by and hosted on G2.com.

Jenaro T.
JT
Jenaro
Mid-Market (51-1000 emp.)
"Postgre is used in many operating systems"
What do you like best about PostgreSQL?

PostgreSQL can be used to create databases in both windows and linux operating systems Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It takes a lot of time to install and also needs additional features to install 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