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

Enterprise (> 1000 emp.)

6/10/2016

"PostgreSQL is user friendly software for database management"

4/5

What do you like best about PostgreSQL?

I use postgres as database in many different projects. Very easy to use. You can quickly learn to use this and create simple to complex queries. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing really to dislike. If required it can be enriched in user experience. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I used its as database in various project developments. Very easy to use. You can quickly learn to use this and create simple to complex queries. Review collected by and hosted on G2.com.

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

I use this for a various projectdevelopment . It is very simple to use and can be effectively embedded. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

4/11/2016

"Great Tool for using SQL at a novice level "

4/5

What do you like best about PostgreSQL?

It is a super powerful tool with the ability to get the job done with work with your database. I am newer to SQL and have found this tool to be great with my skill level. I love the ability to export the files I need and the speed in query execution. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it can run a little slow and that can be unpredictable without reason. Most times it's very fast, but when it bugs out, you have to restart and it just can be a pain. Review collected by and hosted on G2.com.

Vitor H.

Software Developer

Computer Software

Enterprise (> 1000 emp.)

3/28/2016

"Great, free and open source database for any project"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is free and open source and fits great in any project size.

It's easy to connect to PostgreSQL with any technology.

It has a strong and active community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lacks popularity.

Performance in read-heavy operations. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

12/21/2015

"Use it since 10 years for an online card game"

5/5

What do you like best about PostgreSQL?

- the price

- the availability of great support, for example at the mailing list and at Stackoverflow

- the features to keep the data valid (checks, triggers) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I somewhat dislike the necessity to setup and use pgbouncer or similar, I would have better preferred everything to be available in a single package.

Also, optimizing performance for my needs has been a tedious process. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is great.

There are lot of docs and friendly users out there. Review collected by and hosted on G2.com.

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

Good support by other users, many nice features provided by the database.

The PostgreSQL software is very mature:

Whenever there were any problems, I knew that root cause has been me and not this great software. Review collected by and hosted on G2.com.

Timothy S.

Principal Developer Advocate

Mid-Market (51-1000 emp.)

7/17/2015

"Postgresql - The Only RDBMS You Need"

5/5

What do you like best about PostgreSQL?

Everything. It supports all the SQL-92 standards, plus some of their own editions. It has a very mature GIS querying and every type of index. It supports in memory and a ton of different trigger languages. There's no feature or item missing from postgresql.

Use it and you will be happy.

It's an exact replacement for oracle without the cost. Supports triggers, procs, functions and everything you can think of including a datascience machine learning package MADLIB.

There's no reasons not to use Postgresql. The drivers for Java and Scala and NodeJS are excellent. Postgresql also powers a lot of servers like Cloudfoundry. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The problem with Postgresql is that there's a lot of version and no single owner of the enterprise verison. No really a concern. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

There is no reason to not use PostgreSQL, it is amazingly mature coming from Ingres and Dr Stonebreaker. It's been around forever and is really solid. A dozen or so commercial vendors have MPP and datawarehouse forks of it that they use.

Postgresql JSON features are very helpful for front-end usage and the indexes make most queries blazing fast.

We have no dba and really don't need one. The DB runs itself.

You do need to run a few dba tasks weekly like vacuum, analyze and backup.

Check your explain plans and make sure you have adequate queries. Review collected by and hosted on G2.com.

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

We are using it for data warehousing, basic data for web sites, blog storage, backup data and research data. It is also our main analytic database and transactional store.

It has saved us a lot of development time and money. Spring Data JPA and hibernate work perfect with PGSQL. pgADMIN and all JDBC SQL tools work perfect with it. Review collected by and hosted on G2.com.

Alex M.

Software Engineer (Technology R&D)

Research

Mid-Market (51-1000 emp.)

3/24/2016

"Postgres - Great for GeoSpatial"

4.5/5

What do you like best about PostgreSQL?

Geospatial data is very handled by the PostGIS extensions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The command line interface is quite foreign from the conventions of other systems, and lacks many useful features like tab completion for identifiers. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

3/14/2016

"The best relational database"

4.5/5

What do you like best about PostgreSQL?

This is RDBMS that i use the most. I like the performance and and also hstore. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its relational database, its not specific to postgres. But when im working in research project i will not use RDBMS because in research schema change often. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

12/14/2015

"Great for everything"

5/5

What do you like best about PostgreSQL?

PostgreSQL was my first database that I used when initially developing rails apps and I prefer to use it if I have the option. It's open source, and it's well maintained. There is also a huge community of people who use it so there are plenty of answers for questions on stackoverflow etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Off the top of my head there isn't anything I dislike about it. Once you learn to use it it is pretty straightforward and there is a lot of documentation for learning to use it. I would certainly recommend it over other options like mysql in terms of ease of use, although it depends on what you want to use it for. Review collected by and hosted on G2.com.

Bryan F.

VMware Engineering Consultant

Information Technology and Services

Small-Business (50 or fewer emp.)

7/30/2015

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

"Solid Open-Source RDMS"

4/5

What do you like best about PostgreSQL?

PostgreSQL is stable and performs well, even at large connection loads. They have the best documentation of any piece of software I've dealt with. On top of that, it's completely free! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The default GUI for interacting with the database isn't very intuitive. Scaling can be a problem due to the rudimentary clustering tools and lack of third party support. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

This is a great product for small to mid scale implementations. If you're looking for a scale out system or high availability cluster, it may be prudent to look at other options that are easier to work with. Review collected by and hosted on G2.com.

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

We use the PostgreSQL database as a back end for our monitoring system. It's easy to install, integrate, and use and at the free price tag it has saved us a lot of money. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

4/1/2016

"A Workhorse"

5/5

What do you like best about PostgreSQL?

This database can do just about anything. For a modern web application the support for JSON, and JSONB columns is incredible. The addition of native upsert in 9.5 is huge, too. Review collected by and hosted on G2.com.