PostgreSQL Reviews

217 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.0 out of 100

Do you work for this company? Learn how we help vendors

TrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 34)

Companies can't remove reviews or game the system. Here's why.
Javier Blanque | TrustRadius Reviewer
April 27, 2020

PostgreSQL - The database that fits all

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is an excellent DBMS, which is scalable, performs well, allows replication, supports ACID and a big subset of the SQL standard (in several cases, it is a superset).
  • Is much better at data types than the other DBMSs, with a more rich semantics, with geo-spatial types, complex numbers, etc.
  • It supports several methods of indexation, including B-trees, Genetic Algorithms based indexes, and GIN indexes that accelerates full-text searches.
  • Its flexibility to select from a variety of procedural languages to make stored procedures is astonishing.
  • The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
  • The replication services could be done directly within the database, and more easily.
  • The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
Read Javier Blanque's full review
Anonymous | TrustRadius Reviewer
February 14, 2020

Battle-tested-never-data-loss alternative to MySQL

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • As I mentioned before, Postgres has an incredibly flexible and simple-to-use user/role management system. First, there are users--login information so that you can hand out to individual users. Then, there are roles, which specify read and/or write access to all the tables that you can assign to users. Through this system, you can easily control who can read and update which tables, and the system is very well-tested, so there's no concern with users accessing or writing to data that they shouldn't be unless your Postgres admin really messes up!
  • I could write pages on this and would need to reference the Postgres manual itself to do this justice, but Postgres is dang scalable! There are so many ways to scale it. Postgres has undergone active development by some of the brightest engineers for over 30 years now, and the result is that Postgres has so many ways you can scale it besides just upping the SSD and CPU and memory speed. You can scale reads horizontally through multiple slaves that handle all the reads. You can add highly optimized indices to your tables. You can change columns to JSONB types for super fast JSON queries. You can turn on special caches to bulk writes so they don't overwhelm the disk. Between those three options and other tips and tricks experienced Postgres admins have, you can get a lot out of them. There's a reason Yahoo stuck with Postgres for decades up until their main database even past the point of 4 Petabytes and 10k writes/second!
  • Postgres, simply put, has achieved super-wide industry adoption (6% market share), which means it's really easy to integrate it into your stack and hire knowledgeable developers to service Postgres. All the major database libraries of the common web frameworks that I know are out there (e.g. Rails-ActiveRecord, Spring-Hibernate, Play Scala-Slick) have out-of-the-box deep Postgres support, with no extra configuration needed to get your web app to start reading and writing to Postgres. I also know many universities in the US include Postgres in their curriculum too (e.g. UC Berkeley). It's really easy to hire either new grads or experienced software engineers for positions that require Postgres knowledge.
  • If you are comparing Postgres to MySQL and you want to use JSON, know that Postgres has better performance and features on indexing JSON blobs simply because Postgres beat MySQL to the JSON game by several years. I haven't used MySQL's JSON support before, but that's what my co-workers say (and it's true that Postgres definitely started support MySQL years earlier).
  • If you are comparing Postgres to MySQL, MySQL does have superior write performance. I don't want to get toooo technical here because it involves knowledge of how deep database internals work, but if you most know Uber actually switched from Postgres to MySQL for this exact reason and wrote a great article about why here: https://eng.uber.com/MySQL-migration/.
  • Anecdotally, the Postgres replication process for keeping slaves up to date with the primary is a bit buggy. I say anecdotally because it just happened to us here at my company. A schema update made to the primary didn't make it to a replica for almost a minute and caused probably 50% of the traffic to our website to see 500 internal server error pages for the whole time, and we didn't know why until we dug deep into Postgres logs on that replica.
  • Postgres' migration from 9 to 10 was a disaster. If you want to be on the latest and greatest, which all tech companies should want, migrating your existing database from 9 to 10 was a real pain. Sure, there's a tool to do it for you, but it involved hours of downtime for our mere 4 TB of data. I wish the Postgres maintainers had put more thought into the tool to make it faster or do it bit-by-bit without downtime. And don't get me started on how confusing the configuration for the migration was....
Read this authenticated review
Arthur Zubarev | TrustRadius Reviewer
October 12, 2019

PostgreSQL is a Well Poised for the Future, Venerable, More Than a Database Solution for Many

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Flexibility and Unicode compliance combined with nearly full SQL features support makes PostgreSQL an ideal tool to conducting complex data analyses
  • Ease of administering PostgreSQL, SSL, SSO support make it possible to operate a very private and secure data repository
  • Programmability of PostgreSQL is superb. Multiple standard programming languages are supported, PL/SQL flavour of programming is possible
  • PostgreSQL runs on any platform
  • Replication, high availability are some of the enterprise features that anyone can implement on its own
  • Free, relatively mature for everyday use client tools
  • Most languages have native drivers
  • Superb support for JSON makes it not stop by thinking of NoSQL
  • Not exactly parallel, means a single query often is run in a sequential manner, no threads. The optimizer is hard to understand and deliver quicker queries faster is not often possible (MVCC model)
  • Index operations are slow
  • Can chew up on the CPU quite a bit
  • Comes in too many pieces, here I mean there are way too many diverse extensions that often belong to different vendors or providers
  • The "schemas" are over-thought
  • Lack of some minor basic DML features as MERGE/UPSERT (however can be done with "On Conflict"), also lacking an ability to reposition table column, case sensitive when it comes to database objects
  • No explicit user control over data compression
Read Arthur Zubarev's full review
Jacob Biguvu | TrustRadius Reviewer
June 05, 2019

PostgreSQL - open-source, flexible and futuristic

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Open-source. No license issues like Oracle and SQL server.
  • Full SQL Compliance.
  • GIS extension for search engines or queries.
  • Extensions/plugins to be used for on-premises and cloud technologies.
  • Easy installation/configuration.
  • Performance optimization is needed for the database as well as SQL.
Read Jacob Biguvu's full review
Anonymous | TrustRadius Reviewer
November 07, 2019

PostgreSQL has rich feature sets and it's completely free!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Support the JSON column and able to query by the JSON value.
  • Free to use.
  • Has fairly high performance.
  • Installation and configuration can be difficult for first time users.
  • Somewhat hard to upgrade/update, especially for major releases.
  • Less online documentation and resources available compared to MySQL or SQL Server.
Read this authenticated review
Aaron Smith | TrustRadius Reviewer
January 18, 2019

PostgreSQL is making a comeback!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Redundancy and clustering can be handled in multiple different ways, offering complete control over specific use cases.
  • GIS extension for spatial data.
  • Full SQL compliance.
  • A little lighter on resources than SQL Server.
  • The documentation can be sometimes lacking, however, there are lots of online resources for troubleshooting.
  • The tooling could be better. If you're used to SQL Server Management Studio and all the 3rd party add-ons, moving to PostgreSQL can be hard to get used to at first.
  • If you are on a version older than 11, you cannot use Transactions in Stored Procedures. While this isn't an issue moving forward, not all cloud providers support version 11 yet.
Read Aaron Smith's full review
Richard Rout | TrustRadius Reviewer
October 18, 2018

An amazing free option for an enterprise level database tool

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Free relational SQL based database
  • Tonnes of community support
  • Fast, scalable database.
  • Hard learning curve if you are unfamiliar with SQL databases
  • The graphical tooling isn't as good as some of the tools provided by Microsoft for the example.
  • Can be hard to figure out what went wrong unless you know how.
Read Richard Rout's full review
Carlos Alberto Pedron Espinett | TrustRadius Reviewer
August 15, 2018

A great database manager without platform distinction the best relational option

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The genetic algorithm that is part of the PostgreSQL core allows the manager to take the most efficient route for the realization of certain queries, which offers superior performance to the options presented as their competitors.
  • The possibility of limiting the simultaneous connections that the manager receives allows us to channel their resources efficiently and optimally.
  • PostgreSQL allows adding additional languages ​​to Transact-SQL itself to perform its functions or procedures. This is important since it allows teamwork without major limitations to the knowledge of the language being worked, and its availability as an extension for PostgreSQL.
  • In short or quick queries, PostgreSQL usually shows disadvantages compared to other, similar applications.
  • The knowledge or management of commands by console is desirable. That is to say, it would be better to avoid depending on the graphical interface for the manager to be able to operate it correctly, since the pgAdmin option that this proposes usually consumes a lot of computer resources.
  • While it isn't quite bad, the documentation regarding the handler could improve. The current one is usually sufficient, but could improve.
Read Carlos Alberto Pedron Espinett's full review
Venkateswar Reddy Thatikonda | TrustRadius Reviewer
November 14, 2017

Postgresql - OpenSource and objecr relation database with NOSQL(JSON type) support

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Object relational database
  • Rich support of procedural languages like R, C, Python, Perl and PL/ PGSQL
  • Geo Spatial and JSON support
  • MVCC concurrency model gives less locking
  • Deployment gets difficult for folks who are habituated with commercial databases.
  • We cannot write our own database engine unlike MySQL.
  • PostgreSQL do not allow us to execute batch of statement. we have to embed it in a function to achieve this.
Read Venkateswar Reddy Thatikonda's full review
Bhargav Nanekalva | TrustRadius Reviewer
September 19, 2017

The "best" open source ORDBMS out there.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It works extremely fast for our applications including very complex queries as well
  • They provide one of most complete and precise documentation in the open source market and even compared with a few proprietary projects
  • It's an enterprise level database where even few banks have migrated from legacy databases like IBM DB2
  • One of the best open source communities, with paid support options available as well
  • It provides very unique data types which other databases might not support.
  • PostgreSQL security is arguably one of the best
  • PostgreSQL can provide richer auditing options as the current options are enough for few large enterprises
  • Replication can be improved
Read Bhargav Nanekalva's full review
Louis Marceau | TrustRadius Reviewer
September 18, 2017

PostgreSQL - A great database at a great price.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The biggest reason I have used postgreSQL and continue to use it in places where I work - is the cost. There is none. It is a great feature rich database which doesn't cost you anything.
  • When using properly design database, tables, and relationships - we have not ran into any particular database limit
  • For my uses I have none. Currently we are developing a new application using the lastest version of PostgreSQL and are exploring any limitations.
Read Louis Marceau's full review
Anatoly Geyfman | TrustRadius Reviewer
August 16, 2017

PostgreSQL, especially with PostGIS is a standout among open source databases

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Spatial Analytics and other GIS use cases - PostGIS is an excellent way to get into spatial analytics, loading it up with data is trivial, power is on par with commercial solutions.
  • Interactive queries over large (but not huge datasets) - easy to load data, query it with standard SQL, easy to set up and maintain.
  • Support for a variety of data types - storing data in the database using semantic types is helpful for deeper analysis.
  • Clustering -- we'd love to see clustering built into the product itself instead of third-party
  • Parallelization -- PG is already going in this direction, but it will take a few more releases to be there
  • Tooling -- we use a third-party tool right now to query PG, would love to see a first-party quality query tool
Read Anatoly Geyfman's full review
Eric Mann | TrustRadius Reviewer
March 21, 2017

The best of both Relational and Document DB paradigms

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Native JSON support
  • Intuitive command line integration
  • Easy Docker hosting
  • Shared extensions. We use the pgcrypto extension (for UUID support) and frequently install it to the wrong schema by mistake. Extensions are difficult to move, and this is an easy mistake to make.
  • Clearer delineation between "databases" and "schemas" would help to better understand the system.
Read Eric Mann's full review
Nitin Pasumarthy | TrustRadius Reviewer
November 03, 2016

PostgreSQL, the best research oriented central database

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Relational database with great collection of GeoSpatial functions
  • Open source which enables researchers to tweak and extend
  • Good resource for learning internals of a database like Query Optimizer, Buffer Manager etc.
  • Installation can be a little tricky sometimes. Wrote a decent blog post how to do it on a MAC - https://sites.google.com/site/nitinpasumarthy/blog/installingpostgresonmac
Read Nitin Pasumarthy's full review
Nikhil Karkare | TrustRadius Reviewer
February 14, 2017

A great RDBMS

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • I like the pre-defined functions of PostgreSQL.
  • It has got some advanced data types which are not available in many other relational database systems.
  • It is reliable and we can write the stored procedures in Python, which is a great feature.
  • It is probably one of the best relational database systems but I find it not good enough for analytics purposes (not bad if you have less data).
  • I haven't done its configuration but I came to know that this is not really easy as in the other RDMS tools.
  • It doesn't have the proper documentation, considering it has a lot of features.
Read Nikhil Karkare's full review
David McCann | TrustRadius Reviewer
August 02, 2016

PostgreSQL - the last database you'll ever need

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Broad array of custom functionality/formulae built atop standard SQL statements
  • Transactional support for schema migrations
  • Great low-level performance tuning capabilities
  • Performant implementation of bulk merge (upsert)
  • Some of the custom SQL functions thatPostgreSQL provides could be optimized. Specifically I've seen that the "is contained within" operator for inet columns is slow to the point of being unusable in bulk (e.g. as a join criteria).
Read David McCann's full review
Vishal Arora | TrustRadius Reviewer
November 08, 2016

Worry Free

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is simple to use, no overheads.
  • It has a simple GUI as opposed to other opensource databases
  • Its free to use.
  • PostgreSQL needs to improve upon its storage engine.
Read Vishal Arora's full review
Christopher Weiss | TrustRadius Reviewer
October 26, 2016

PostgreSQL is too often overlooked

Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The backend stored procedure language is complete, and lends itself to better programming and data manipulation tasks than MySQL.
  • PostgreSQL has complex data types like object columns and record data types that allow it to better mirror object relational structures directly within tables.
  • It is a fully SQL 92 compliant database even in its fully open source version.
  • For some more advanced features like replication, PostgreSQL can be a pain.
  • PostgreSQL can experience some bottlenecks under heavy read query load.
  • An in-memory or similar transaction caching strategy could greatly expand the appeal of PostgreSQL as developers look for other solutions such as Reddis to do in memory processing.
Read Christopher Weiss's full review

About PostgreSQL

PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.

PostgreSQL Integrations

PostgreSQL Technical Details

Operating Systems: Unspecified
Mobile Application:No