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

Likelihood to Recommend

PostgreSQL is open source, and then, there are several companies that could give you technical support, like EnterpriseDB or Percona.
PostgreSQL is easy to install and configure and is multi-platform, you could use Windows, Mac, Linux, FreeBSD, and you could use ALL the hardware you have purchased for your project, without sinking hundreds of thousand of dollars in proprietary software, to use only a small part of your server for the database.
Let's see a concrete case: You have a project to make an information system which uses an underlying database. Then you purchase 3 servers, which cost USD 50K for the Production server, USD 25K for the Contingency Server and USD 10K for the Development Server.
If you use a proprietary database, we know what companies, they price their software licenses per every 2 cores if we use the servers physically or every 2 vcpus (threads) if we use virtual machines, and the cost range is between USD 15K and 50K for each 2 cores license. If my production server has a configuration of 24 SSDs of 3,84 TB, 2 TB of ECC RAM, and 2 CPUs AMD EPYC 7702, with 64 cores each (128 cores and 256 vcpus or threads per server), the cost of the proprietary database could be more than USD one million, and if we use a subscription mechanism to get the updates, we could be talking of another million each 3 to 5 years. That is ten times the cost of the hardware. And you can TOUCH the hardware.
Is PostgreSQL slower than the proprietary databases that we talk about? Yes; but for what margin? In in-house tests, the performance of PostgreSQL was from 50% to 75% typically, with several scenarios where PostgreSQL where speedier. But we could use ALL the cores for the DBMS, not just a few.
For us PostgreSQL is the best database in existence. Period. If we use proprietary databases yet it's only for legacy information systems, for contractual restrictions or because our providers haven't seen the light (yet).
Read Javier Blanque's full review
Balázs Kiss | TrustRadius Reviewer
January 20, 2020

A robust, free, and high quality DB

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

For smaller development projects where a reliable and free database is required, PostgreSQL is quite good. But for bigger, more robust solutions, it also stands it ground next to the "big" DBs. PostgreSQL's improvement is community based, meaning it will have all the tools and helpful features that a modern software developer needs. It's quite easy to administrate as well.
Read Balázs Kiss'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

Likelihood to Recommend

Postgres is useful for perhaps 99% of apps that simply need to store user data somewhere and make it quickly retrievable at some later time. If you want to do full-text dynamic JSON searches (e.g. you are building a search engine), perhaps one of the NoSQL databases will serve you better. But regardless, you will probably need to store user data, even if you are building a search engine and storing it in Postgres (or a similar relational database) is much simpler. Postgres is also really good for work in industries where you get audited regularly (e.g. legal or financial) and cannot ever corrupt or lose user data, and that is because Postgres is fully ACID compliant, meaning if Postgres receives an update query, it will ALWAYS execute it even if lightning strikes the server.
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

Likelihood to Recommend

PostgreSQL is a go-to database for any web application, especially if one is going to reside with one of the many hosting/Cloud providers. It can analyze some, up to a few TBs, of transactional data, or can be used in data warehouses, and extending it - Geospatial, JSON, Failover, Replication are all within reach.

Not so great for ETL or large volume data processing, e.g. pulling data from foreign sources is not easy often. It is slow to read so any large table scans would be detrimental speed-wise or noticeable to end-users. No in-memory storage, so not good as cache.
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

Likelihood to Recommend

PostgreSQL is best for OLTP applications and searches engines/queries. Want to save the budget? PostgreSQL is best. Want database support on On-premises and Cloud? PostgreSQL is best.

For the non-critical applications, I would recommend using PostgreSQL. For critical applications, I would recommend going through the database design, modeling, and architectural decision-making process. Proper design decisions mitigate many performance issues.
Read Jacob Biguvu's full review
Anonymous | TrustRadius Reviewer
July 24, 2019

PostgreSQL is great for data analytics and engineering work.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

PostgreSQL is great as a data warehousing solution in large organizations but it is also problematic when it is improperly used as a transactional database. Postgres is a OLAP, not an OLTP database where you would use something like MySQL instead for storing live data. It has great read but poor write speeds.
Read this authenticated 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

Likelihood to Recommend

PostgreSQL is perfect if you are an experienced software engineer or database admin. Its wide feature set will be really useful the more you use it. It is also a cheap alternative to SQL Server since you need to pay a fairly pricey SQL Server license especially for business and enterprise, meanwhile, PostgreSQL is completely free to use.
The learning curve is a bit steep compared to MySQL and SQL Server, so might not be suited for a beginner.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 02, 2019

PostgreSQL - Data Warehousing Technology

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

PostgreSQL is the best solution out there for data warehousing for relational data if that is what you need in your various analytics and dashboarding projects. It doesn't work that well as a transactional database, for that you'd probably want to stick with MySQL. The other flavors of PostgreSQL that are optimized may work better again, depending on your specific data types and workflows.
Read this authenticated review
Anonymous | TrustRadius Reviewer
June 06, 2019

A Great General Purpose DBMS

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

PostgreSQL is really good at being a data source for many applications. Because each database has the ability to have multiple schemas, a database can be separated logically according to criteria, such as which business unit the underlying data belongs to. Then, within that database, multiple schemas can be created for different purposes -- maybe one schema per application.
This setup of the DBMS is great for a more monolithic data source, but not so much for a more micro-service style setup.
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

Likelihood to Recommend

PostgreSQL is great for all types of data storage needs. Even if you have a use case for minor document storage, it can handle it. As with most things, you use the right tool for the job, anywhere you would use MySQL or SQL Server, you can just swap in PostgreSQL. However, if you are needing a NoSQL or schema-less storage model, look elsewhere.
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

Likelihood to Recommend

If you're using C# and other products from Microsoft then you get a lot of benefit from Microsoft SQL Server and the Entity Framework ORM. However if you're building an app in almost anything else, then there is almost guaranteed PostgreSQL tooling, utilities or packages for that environment, it's a great database to use.
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

Likelihood to Recommend

PostgreSQL is indicated for companies with a large database that requires the maximum database manager and needs to squeeze all its benefits. It is not recommended for use in small databases or ones with a low level of transactions, many of which will be lost. Those are benefits of this application, and there are options that can provide better results.
Read Carlos Alberto Pedron Espinett'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

Likelihood to Recommend

PostgreSQL supports most of standard SQL, which is almost same as other SQL servers, and it has wide variety of features that are not present in other SQL servers. PostgreSQL has database drivers readily available for popular web programming languages like PHP, Python, Java, and C#. PgAdmin makes it easy for people who likes to work with it's GUI, even though it's not the best yet. There are many companies that provide enterprise level support and many SaaS and PaaS providers which makes it even more easier to migrate and get support.

Only case where it might not suit is for companies that want to implement themselves and don't have enough expertise in doing so. That's because PostgreSQL is extremely powerful despite its size.
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

Likelihood to Recommend

I have used it as a data warehouse, client specific database for a web application, test systems where each developer has their own schema for testing, local application database, and as a remote application database. It has worked well in each of these situations. Currently the main area where I would not use PostgreSQL is when I need an embedded database - in which case I would look at something like SQLite or other.
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

Likelihood to Recommend

Postgres is best suited as an OLTP database, and even for non-huge OLAP use cases. We especially love the third-party extensions to PG that make the database a clear winner amongst open source databases. When evaluating PG, look beyond traditional RDBMS workloads and also into areas where NOSQL databases have use cases. With PG's support for the JSON and JSONB data types, PG is now a competitor on the schema-less database space.
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

Likelihood to Recommend

PostgreSQL is very good for quick projects with structured data. It allows for easy schema development for complex relational structures and also for document storage (using JSON-encoding for documents). The query model against these nested JSON structures is amazing!

If looking for a strict document database, though, PostgreSQL might be overkill when compared to tools like DynamoDB.
Read Eric Mann's full review
Josh Stapp | TrustRadius Reviewer
March 15, 2017

PostgreSQL is great for storing large amounts of data

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It works better if you need JSON support. It's very fast and a little more complicated than MySQL especially with query planning. It's bad on keeping space usage small [for] dump/restore. The whole db shrank out 6TB DB to 2TB. Any large project I would definitely pick postgres just in case more advanced stuff is wanted later.
Read Josh Stapp'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

Likelihood to Recommend

Good if we want to extend the database and use existing plugins
Good for research and academic use cases like learning database internals
Not good in places where customer support is mandatory for enterprise (as far as I know)
Not good in cases where distributed system is required for availability as there are other better distributed database systems
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

Likelihood to Recommend

If you want to use it to store your operational data in the records, PostgreSQL will do best. It has a lot of great features. When it comes to analytics and if you have a lot of data (like in billions of rows), it is probably not a good idea. In that case, a columnar database like Vertica or Redshift will do a great job, because they are made for analytics.
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

Likelihood to Recommend

PostgreSQL is in my opinion the best open-source option for any enterprise-level product requiring a standard relational database. Areas where it might be considered not ideal would include: smaller-scale projects requiring a database (MySQL might be an alternative here), or document stores with unstructured data (some would argue that NoSQL options are better here).
Read David McCann'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

Likelihood to Recommend

For a general purpose SQL database that is fully SQL 92 compliant, PostgreSQL is a feature rich open source database. It is underrated in this area and frequently passed over in favor of MySQL or MariaDB. PostgreSQL is more akin to SQL Server or Oracle than it is to MySQL. For general purpose applications that need some database side programming, PostgreSQL is an excellent choice.

If you need a lighter weight and trivial to configure database, MySQL is a better choice. Also, PostgreSQL sometimes is not as performant as other solutions, meaning scale and load can be issues.
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