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

Bruce R.

Senior Associate Scientist

Research

Mid-Market (51-1000 emp.)

4/28/2015

"PostgreSQL is a great database system"

5/5

What do you like best about PostgreSQL?

The combination of PostgreSQL and PostGIS. It has been the foundation of our glacier mapping system for years, and has always been rock-solid and packed with features we need. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can think of no dislikes that would not apply to any other relational database system as well. Review collected by and hosted on G2.com.

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

Web-accessible database of Earth's glaciers. Combined with MapServer, we provide interactive maps and Open Geospatial Consortium web services. The stack is reliable, configurable, and flexible. Performance on a VM is more than sufficient. The database contains data and metadata for close to 200,000 glaciers, including polygons that are the outlines of the glaciers. Review collected by and hosted on G2.com.

Regina O.

Chief Database Architect

Mechanical or Industrial Engineering

Small-Business (50 or fewer emp.)

4/3/2015

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

"Database development and application development with PostgreSQL"

5/5

What do you like best about PostgreSQL?

Lots of ANSI SQL features, array support, extended type support, great query planner works well with custom types. Free without strings. Runs on windows, mac, and Linux. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Needs parallelization for queries like SQL Server and Oracle have. Need ability to replicate single databases easily. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is a great database. It has both fantastic relational support and other type extensions for NoSQL like workflows so you get the best of both worlds. It supports many stored procedure languages in db JavaScript, SQL, Perl, Python, and R. Review collected by and hosted on G2.com.

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

We use it as a back end for most of our applications. We've been able to use advanced SQL constructs that we didn't have available in SQL Server, allowing us to be able to move most logic into the database where it can be used across many applications. Review collected by and hosted on G2.com.

Verified User in Consumer Services

Mid-Market (51-1000 emp.)

4/24/2015

"My Postgre experience"

3.5/5

What do you like best about PostgreSQL?

There are window functions. It makes a lot of things to be solved much easier than without them. Hive databases also have similar functions so it's relatively easy to move to Hive from PostgreSQL. Also has a function already available to create a custom functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not the best performance on reading operations compared to MySQL database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Want your data to be safely stored? - Use PostgreSQL.

Also if you use pretty complex database designs, PostgreSQL is nice solution for that. Review collected by and hosted on G2.com.

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

We used id while creating an online web store. It wasn't the best solution to choose but it covered our needs. Review collected by and hosted on G2.com.

Rohit V.

Senior Software Engineer

Mid-Market (51-1000 emp.)

4/15/2015

"Stable for large scale relation data"

3.5/5

What do you like best about PostgreSQL?

It is very fast for large amount of data. The front end client (pgAdmin III) is bundles with the database and is very responsive for a large number of concurrent connections. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A steep learning curve for proprietary configuration. Review collected by and hosted on G2.com.

Daniel B.

President

Computer Software

Small-Business (50 or fewer emp.)

3/14/2014

"A stable, powerful, feature-rich and fast database "

4.5/5

What do you like best about PostgreSQL?

One of PostgreSQL's best features is strong adherence to the ANSI-SQL:2008 standard, which makes it a very comfortable choice when switching from other database systems. It's open source, well maintained, industry proven and battle-hardened, with a rich set of features that I could not begin to list here. I've consistently been impressed by its extensibility, stability, and robust set of built-in functions, including handy cryptographic functions. I make regular use of nested transactions, wide language support for stored procedures, and complex subquery expressions. This is a powerful tool suitable for a wide variety of application domains, and it is well supported in every major programming language with drivers and connectors. A plethora of tools exist to interact with your PostgreSQL databases, from command line to powerful GUI tools suitable for both experienced and novice users. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuring PostgreSQL instances can be challenging, and is not to be entertained by the layman. If you can, find an experienced DBA to handle configuration of your instances or cluster, unless you have a very competent system/database administrator in-house. It will work just fine out-of-the-box, but more demanding integrations require configuration tweaking. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Consider PostgreSQL early in your RDBMS search. Every major and minor release adds significant functionality -- this is a living, breathing, growing product that will almost certainly address your needs. Review collected by and hosted on G2.com.

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

We migrated from Oracle to PostgreSQL, saving significantly on licensing costs with no loss in performance or features. Since that switch, we have used PostgreSQL as our data backplane for every new product initiative with great success and no insurmountable difficulties. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

5/12/2014

"Excellent database product with loads of possiblities"

5/5

What do you like best about PostgreSQL?

Extremely easy to setup. Good security features. Can easily deploy in the cloud or use pre built Amazon services. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The GUI. pgAdmin has not been a very stable product. But once you work through the issues it does the job. Review collected by and hosted on G2.com.

Neil B.

Database Manager

Research

Enterprise (> 1000 emp.)

8/5/2013

"It Just Works."

5/5

What do you like best about PostgreSQL?

The documentation is very well written and logically laid out. I can't find anything in the MySQL docs but familiarity is certainly a factor.

Rock-solid stability and point-in-time recovery. Go ahead -- pull the plug!

When working with spatial data the PostGIS extension is very powerful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing! Review collected by and hosted on G2.com.

Jared T.

Solutions Architect

Enterprise (> 1000 emp.)

11/5/2012

"Nice Database option for non enterprise users"

4/5

What do you like best about PostgreSQL?

Either free or way more affordable than other Database software, i.e Oracle. And they are not owned by Oracle, as opposed to MySQL which is not Larry Ellison's property. More robust and secure compared to MySQL. Review collected by and hosted on G2.com.