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 Education Management

Small-Business (50 or fewer emp.)

12/28/2017

"Easy to use and no brand name cost"

4/5

What do you like best about PostgreSQL?

The product is very similar to the large scale

Brand name product. It functions and works the same and does not Cost nearly as much. If you know SQL, the slight variations on la gauge from MSSQL will be no issue at all. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There was a small learning curve due to some language structure changes. But nothing that is difficult. Review collected by and hosted on G2.com.

Terence F.

Enterprise Development Manager

Utilities

Small-Business (50 or fewer emp.)

4/12/2017

"Cost Effective alternative Databse"

4/5

What do you like best about PostgreSQL?

It's open source software and a large community that supports the incredible features that the database offers Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing yet! Replication could be improved Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Do a cost / benefit analysis - this is fundamental for any new customer engagement solution that uses your product. A database is the core of any software application and you must understand and search out the issues and requirements that face the customer. Every implementation is unique and needs to be looked at holistically - architecture, security, performance, disaster recovery, reliability etc Review collected by and hosted on G2.com.

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

Most solutions do not need a heavy-weight database like Oracle or MS SQL; PostgreSQL offers a very convenient and powerful database that pack a lot of features. Review collected by and hosted on G2.com.

Verified User in Financial Services

Small-Business (50 or fewer emp.)

1/2/2018

"Performant and scalable"

4.5/5

What do you like best about PostgreSQL?

Uses a large subset of standard SQL. Transactional and enterprise-ready. Used a lot, by a lot of companies and people; any problem you have has probably already been solved. Should be familiar to anyone familiar with any other SQL-based RDBMS Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Esoteric management commands like \du are weird and hard to remember. Review collected by and hosted on G2.com.

David H.

Network Engineer

Legal Services

Mid-Market (51-1000 emp.)

11/2/2017

"Linux client difficult to adjust but worth it"

4/5

What do you like best about PostgreSQL?

very flexible, good community behind it supporting each other, lots of web resources. Small footprint Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It was an adjustment to all CLI Linux database as I'm not a DBA but it was worth figuring out. Review collected by and hosted on G2.com.

Verified User in Banking

Enterprise (> 1000 emp.)

12/27/2017

"Agile and easy database"

4/5

What do you like best about PostgreSQL?

BD graphic design and management tools, good scalability since it is able to adjust to the number of CPUs and the amount of available memory optimally Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of robustness for high availability Review collected by and hosted on G2.com.

Laveena B.

Graduate Services Assistant (Part-time)

Higher Education

Mid-Market (51-1000 emp.)

12/28/2017

"Replacement for mysql"

5/5

What do you like best about PostgreSQL?

Query optimization time and flexibility. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Complex to understand and tough installation in Ubuntu. Review collected by and hosted on G2.com.

Verified User in Internet

Small-Business (50 or fewer emp.)

10/24/2017

"Postgres is a great example of great OSS"

5/5

What do you like best about PostgreSQL?

The amount of updates, and support by the community is amazing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular, only that replication could take a page out of mysql. Review collected by and hosted on G2.com.

Verified User in Internet

Enterprise (> 1000 emp.)

10/30/2017

"Convenient tool for end users"

3/5

What do you like best about PostgreSQL?

Used PostgreSQL for more than 4 years on 2 different jobs. Convenient and easy to learn. All main stream functionalities are there. No fancy add-ons. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When I used the software it did not support tabbed query editor, so I had to switch query windows fairly frequently, adding a little difficulty to use. Now I guess they must have changed. Review collected by and hosted on G2.com.

Julio Rafael R.

Analyst and Software Developer

Program Development

Mid-Market (51-1000 emp.)

11/16/2017

"the fastest relational DataBase i had used"

5/5

What do you like best about PostgreSQL?

after version 9.6 you can use "on conflict" functions to handle PK conflicts Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PG Admin is to slow... but nothing to worry about. Review collected by and hosted on G2.com.

Jonathan G.

System Architect

Mid-Market (51-1000 emp.)

7/26/2017

"Easy to use RDBS that gets the job done"

3.5/5

What do you like best about PostgreSQL?

It has a lot of integrations with products we use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Editing existing data and modifying existing settings isn't as easy as other platforms in my opinion Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

After switching to PostgreSQL, we realized there weren't really many amazing benefits over staying with a DB tech we were already familiar with. We still experienced bugs and had to run DB update scripts etc. It was just a little difficult because it was new to us then. Review collected by and hosted on G2.com.

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

We use many Atlassian products which recommend using PostgreSQL for their backend, so that's why we're using this. Review collected by and hosted on G2.com.