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 Information Technology and Services

Enterprise (> 1000 emp.)

1/7/2019

"Really easy to use"

5/5

What do you like best about PostgreSQL?

Very user friendly, can easily query large datasets in an efficient manner Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Reading a file as input is cumbersome and not intuitive. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

2/20/2019

"Efficient query language"

5/5

What do you like best about PostgreSQL?

Simple syntax and usefull for large volumes of data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Query behaves sometimes very strangely which i dont like Review collected by and hosted on G2.com.

Mark S.

Accessibility Software Developer

Information Technology and Services

Enterprise (> 1000 emp.)

11/20/2018

"PostgreSQL best in business"

5/5

What do you like best about PostgreSQL?

Postgres makes tracking and sorting data easy while also being able to creat complicated data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The dashboard for pgadmin is somewhat difficult to use Review collected by and hosted on G2.com.

Michal M.

Analityk Systemowy

Information Services

Small-Business (50 or fewer emp.)

4/13/2018

"Free and really good database not only for scientists but also for business applications"

5/5

What do you like best about PostgreSQL?

This is free

big community

a lot of extensions

the ability to use Python

it just works Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Limiting the number of columns in the table. However, other databases have similar limitations.

Older versions had very nice tools, in particular the SQL client. In newer versions, it has been replaced by a nicer graphical solution that is slow and sometimes slightly annoying. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

A complete tool, free and easy to integrate with other software. For this you can create your own functions in PL-SQL and Python. Accessibility, stability, sense of security - these are the main features that caused me and the organizations for which I work to reach for this product. Review collected by and hosted on G2.com.

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

I used PostgreSQL in Data Mining and BI projects. I used it as background database for solutions based on JIRA. Moreover I used PostgreSQL for specialized engines that are working in on-line class systems. Review collected by and hosted on G2.com.

Jesús G.

Mid-Market (51-1000 emp.)

7/30/2018

"Robust and powerful database"

4.5/5

What do you like best about PostgreSQL?

What I like most about PostgreSQL is that it maintains its speed at any database size and its license has no cost, making it a good choice for any company. Additionally, it is cross-platform. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I like least about PostgreSQL is that it is not one of the fastest on the market, although its speed is the same in any database regardless of the number of rows. The support is also one of the disadvantages. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

2/10/2019

"Simple yet powerful"

3/5

What do you like best about PostgreSQL?

Simplicity and ease of use and operation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is good for small scale data storage and analysis but may not be suitable for big data operations. Review collected by and hosted on G2.com.

Verified User in Education Management

Mid-Market (51-1000 emp.)

1/22/2019

"PostgreSQL"

3.5/5

What do you like best about PostgreSQL?

its a nice easy database to use with simple, easy to understand design Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

SQL is probably one of the harder languages, can make coding more tedious than needs to be Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

11/7/2018

"Most advanced and efficient open-source database "

4.5/5

What do you like best about PostgreSQL?

Extensible, efficient, supports SQL, Mongo and NoSQL as well. It is open-source so there is no cost involved. Online community for PostgreSQL is excellent, leading to better support. It is second to none in terms of reliability and stability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Slower than MySQL. Installation and configuration can be difficult to grasp at first. Review collected by and hosted on G2.com.

Verified User in Civil Engineering

Enterprise (> 1000 emp.)

2/6/2019

"The best db hands down "

5/5

What do you like best about PostgreSQL?

The extensibility, stability, and spatial capability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

GUI interface is not as well developed as the CLI and intimidates newer users Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

2/14/2019

"Great Database to work with"

4/5

What do you like best about PostgreSQL?

Easy to setup and works well with Sequelize Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not great with performance compared to Oracle or teradata 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

$$$$$

View More Pricing Information

Categories on G2

Relational Databases

Explore More

top customer service automation software

What's the top CPQ tool for large companies in tech

digital experience companies

top customer service automation software

What's the top CPQ tool for large companies in tech

digital experience companies

Staffing Agencies in San Antonio

Best influencer software for businesses in tech

Pros and Cons Details

PostgreSQL Comparisons

PostgreSQLVSMySQL

PostgreSQLVSMariaDB

PostgreSQLVSOracle Database

Compare PostgreSQL ratings to similar products

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Top Rated PostgreSQL Alternatives

638 PostgreSQL Reviews

PostgreSQL Pros and Cons

Verified User in Information Technology and Services

"Really easy to use"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Financial Services

"Efficient query language"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Mark S.

"PostgreSQL best in business"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Michal M.

"Free and really good database not only for scientists but also for business applications"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Jesús G.

"Robust and powerful database"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Information Technology and Services

"Simple yet powerful"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Education Management

"PostgreSQL"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Information Technology and Services

"Most advanced and efficient open-source database "

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Civil Engineering

"The best db hands down "

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Information Technology and Services

"Great Database to work with"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Pricing Insights

Time to Implement

Return on Investment

Average Discount

Perceived Cost

Categories on G2

Explore More

PostgreSQL Comparisons