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

Paola S.

Experto de Productos y Segmentos I

Small-Business (50 or fewer emp.)

7/6/2018

"It is a good manager of data bases oriented to objects, it is open source"

3.5/5

What do you like best about PostgreSQL?

The speed is maintained when managing small and large databases, its installation is unlimited, it is low cost of operation in maintenance and adjustment, it is multiplatform, it is stable during the use of databases, it operates on different Linux web platforms, Window, MacOs X, has an excellent security system (user and passwords), large storage capacity Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slow in incersiones and updates, it has online support but it is not official Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

10/29/2018

"PostgreSQL Review as a Developer"

2.5/5

What do you like best about PostgreSQL?

It is Open source so free to use and install Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing much but PostgreSQL tool UI is not user friendly Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are working on Pega Tools then installing Postgre is highly recommended. Also if you want to do some POC you can do in postgre as it is free. Review collected by and hosted on G2.com.

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

I used it always for our Pega personal edition. It is very useful for a developer Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

10/25/2018

"Great product for many use cases"

5/5

What do you like best about PostgreSQL?

I have used it for extremely small projects, and extremely large projects. The ability to drill down in the config to make sure to use resources carefully or the ability to just get it working has been really convenient. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is a pretty good learning curve to be able to become very proficient with it. Review collected by and hosted on G2.com.

Mehmet James B.

Business Intelligence Manager

Small-Business (50 or fewer emp.)

7/30/2018

"Wonders with Postgre"

5/5

What do you like best about PostgreSQL?

This is a great database that I just met and it is super reliable, fast, and easy to maintain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I wish it has a better query editor that enables formatting of the queries as well as ease on execution. Review collected by and hosted on G2.com.

Verified User in Internet

Small-Business (50 or fewer emp.)

7/20/2018

"Postgres is a good replacement for expensive Oracle."

4.5/5

What do you like best about PostgreSQL?

I like the Sequence that can be declared for each table, similar to Oracle DB.

90 % syntax and features of Oracle does match with Postgre Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, it is proven to be production ready Review collected by and hosted on G2.com.

Verified User in Entertainment

Small-Business (50 or fewer emp.)

7/29/2018

"Postgres is the best relational database"

5/5

What do you like best about PostgreSQL?

Built in functions: pg_cron, levenshtein, ease of timestamp/interval manipulation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Adding constraints in Postgres is less straightforward than in vanilla SQL Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Highly recommend over any other flavor of relational sql... even supports some NoSQL. Not a fan of Mongo and MySQL is (in my opinion) just a poor man’s Postgres. I know some people like Aurora, I can’t comment because I’ve never personally used it Review collected by and hosted on G2.com.

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

Central relational database - speed/scalability Review collected by and hosted on G2.com.

Tomas D.

Vice President

Mid-Market (51-1000 emp.)

3/21/2018

"great database with easy and robust backup and recovery"

5/5

What do you like best about PostgreSQL?

The way how easy it is to customize the database to suit your needs.

One can use DB Protection for PostgreSQL using IBM Spectrum Protect to have a very efficient and fast backup as it o my backup changes in the database.

Https://ligtas.org

ANSI SQL complaint.

Easy to migrate Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The way how the transaction logs are handled can be problematic especially during a recovery if you perform that multiple times Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Mid-Market (51-1000 emp.)

6/29/2018

"Small learning curve if you know SQL"

5/5

What do you like best about PostgreSQL?

I liked that it is an open source program and that there is a small learning curve if you already know SQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like that there is no way to report errors, so there's no way to track bugs or fixes. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you know SQL, it's easy to pick up and there are great resources on line for free. Also check out https://www.postgresql.org/ for a wealth of information! Review collected by and hosted on G2.com.

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

We use it to run all our reports and pull data from our EHR. Review collected by and hosted on G2.com.

Ross M.

Corporate GIS Data Coordinator

Government Relations

Enterprise (> 1000 emp.)

11/29/2017

"PostgreSQL - the heart of our GIS"

5/5

What do you like best about PostgreSQL?

PostgreSQL with PostGIS and pgRouting offers us a flexible, robust and reliable open source database platform on which to build the rest of our GIS infrastructure. The open source license gives us the freedom to install and use it as we like. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If I had my way I would switch out all our other RDBMS for PostgreSQL. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL offers a solid database platform on which to build applications for organisations not willing to pay large annual maintenance fees. It scales well from small single use applications to large clustered enterprise-wide systems. The open source license lets you install as many instances as you need for free. The open source, standards compliant database allows you complete flexibility in designing the database and any applications it underpins. PostGIS and pgRouting are database extensions that add greatly to the capabilities of the product and are core to our GIS infrastructure. Documentation for the product is second to none and the user community is excellent. If you so wish, support contracts are available from a number of suppliers in the UK and internationally. PostgreSQL is also available from many cloud service suppliers and runs on all major operating systems. Review collected by and hosted on G2.com.

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

PostgreSQL replaced Oracle at the heart of our GIS infrastructure. We have saved money on software licenses, reskilled a number of people in database administration and reduced the number of files stored in directories to almost zero by putting the data in the database. The database is becoming the single source of truth for all spatial data in the organisation. The flexibility offered by the database has improved the efficiency of a number of different data creation and maintenance workflows and as a result we have grown the number of users from 10 to 75. Review collected by and hosted on G2.com.

Denish P.

LinkedIn Learning Instructor

Small-Business (50 or fewer emp.)

1/19/2018

"The best open source database product "

5/5

What do you like best about PostgreSQL?

Postgres can be used as multi-model database

- RDBMS

- Document store

- Search Engine

- Geo spatial database

- Key-value store

- JSONB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of mature GUI tools

Built in sharding support Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are using any closed source database, you should explore Postgres. I have converted a couple of Oracle and MongoDB applications and users love it! Review collected by and hosted on G2.com.

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

Postgres should be your first choice for the data store for mission critical applications. You can use Postgres to store any data and you don't have to look for other database systems to store various kinds of data. Postgres FDW helps to connect to your existing databases i.e SQL server, Oracle, MySQL, Hadoop, Cassandra so Postgres should be hub for your all your data needs Review collected by and hosted on G2.com.