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

Samuel C.

Originations Specialist

Financial Services

Mid-Market (51-1000 emp.)

7/29/2018

"Essential Tool"

4/5

What do you like best about PostgreSQL?

Easy to learn; Widely used in our company Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Little keyboard shortcuts available; browser program does not have ability to save macro Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

7/17/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"Pros and cons of PostgreSQL"

2.5/5

What do you like best about PostgreSQL?

The first thing to highlight is that it is open source, therefore it has no licensing costs. It is undoubtedly the best free option. Its GIS extensions are also worth mentioning. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its performance in handling large volumes leaves much to be desired, and the administrative tools are not as powerful as we would like. Review collected by and hosted on G2.com.

Eduardo H.

Ingeniero informático

Consumer Goods

Small-Business (50 or fewer emp.)

7/17/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"Great"

4/5

What do you like best about PostgreSQL?

Excellente software to manage databases. Is oriented to obejects and the best of all is that is free. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Don't have a official support from the depeloper of the software. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

10/12/2018

"A very versatile database"

5/5

What do you like best about PostgreSQL?

Has various extensions and a very wide dev base.

supports foreign data wrappers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could support more efficient caching and in-memory Review collected by and hosted on G2.com.

Ramon B.

Senior Software Engineer, R&D

Broadcast Media

Enterprise (> 1000 emp.)

9/19/2017

"Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first!"

4.5/5

What do you like best about PostgreSQL?

Awesome built in data types, JSON with indexing to then work with triggers and locks!

Best of both NoSQL and SQL. The community is very active, as well as several commercial enterprise offerings. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I found there to be a steep initial learning curve to be able to build an application effectively to use all the built-in magic if the development team come from using MySQL or MSSQL. Once the brain wraps around some of the over loaded terminology Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

have your team take the time to read or watch an introduction to postgresql methodology, and well as a comparison against MySQL. The hour/hour and a half of time in the beginning can save hours/days of reworking to use the internal tools to scale properly. Review collected by and hosted on G2.com.

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

We needed a database or databases that we could effectively have json stored, indexed, but allow for locked tables. Review collected by and hosted on G2.com.

Thanh P.

Software Engineer

Information Technology and Services

Small-Business (50 or fewer emp.)

11/15/2017

"Object-relational database management system, free and open source"

5/5

What do you like best about PostgreSQL?

A simple database server: store and query data

Multiversion concurrency control (MVCC) per "transaction"

Support JSON data type from version 9.2

Developer can define their objects, inherit from default system defined.

Has full text search and asynchronous notifications Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance and slow on older version. Need update at least 9.4 for better performance Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

Support full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger. Review collected by and hosted on G2.com.

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

Full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger. Review collected by and hosted on G2.com.

Pablo G.

Mid-Market (51-1000 emp.)

7/31/2018

"One of the best services"

5/5

What do you like best about PostgreSQL?

Efficiency, power, easy of use and environment. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The environment may be a bit powerful and with more functions. Review collected by and hosted on G2.com.

Verified User in Civil Engineering

Small-Business (50 or fewer emp.)

7/30/2018

"Great DB, lots of community support"

5/5

What do you like best about PostgreSQL?

It's very easy to setup with cloud hosting providers like Heroku and GCP Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

command line tools for mac are unintuitive Review collected by and hosted on G2.com.

Eric M.

Principal Software Engineer

Computer Software

Small-Business (50 or fewer emp.)

10/24/2017

"Scalable, flexible databases for any use"

4.5/5

What do you like best about PostgreSQL?

Data of almost any format fits well in Postgres. You can use one database instance to house multiple databases, but also host multiple discrete schemas in each database (each with its own set of tables). The scope with which you can shape and manage data structures is remarkable! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some key features from other database systems (like UUIDs for identifiers) are not included by default and require installing separate extensions (pgcrypto for UUIDs). Forgetting to install an extension before importing data can lead to data loss and errors all over the place! Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Keep your data structures clean and ensure your relations don't blend across schemas too often. While cross-schema queries are possible, building your application to use them will limit you in terms of scalability should you ever wish to spread your database across multiple servers/instances. Review collected by and hosted on G2.com.

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

We use Postgres to host our primary application database. It's given us massive scalability by allowing us to tie multiple microservices together into one application. Review collected by and hosted on G2.com.

Verified User in Food & Beverages

Enterprise (> 1000 emp.)

9/2/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"PostGresql for database"

5/5

What do you like best about PostgreSQL?

The abilty to quickly frame the ddl and form the databases and various tables Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing that I dislike about PostGreSql 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

Leading software for customer support centers

Best-rated employee review platform for software industry

Best low-code platform for small business apps

Leading software for customer support centers

Best-rated employee review platform for software industry

Best low-code platform for small business apps

Best purchasing software for small businesses

Best cloud collaboration software for small businesses

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

Samuel C.

"Essential Tool"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Computer Software

"Pros and cons of PostgreSQL"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Eduardo H.

"Great"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Information Technology and Services

"A very versatile database"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Ramon B.

"Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first!"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Thanh P.

"Object-relational database management system, free and open source"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Pablo G.

"One of the best services"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Civil Engineering

"Great DB, lots of community support"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Eric M.

"Scalable, flexible databases for any use"

What do you like best about PostgreSQL?

What do you dislike about PostgreSQL?

Verified User in Food & Beverages

"PostGresql for database"

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