PostgreSQL

PostgreSQL

Top Rated
Score 8.6 out of 10
Top Rated
PostgreSQL

Overview

What is 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.
Read more

Recent Reviews

Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of PostgreSQL, and make your voice heard!

Return to navigation

Product Demos

PostgreSQL: What is PostreSQL AKA Postrgres | Course | 2019
01:40
Return to navigation

Product Details

What is 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 Video

What is PostgreSQL?

PostgreSQL Integrations

PostgreSQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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.

Reviewers rate Support Rating highest, with a score of 9.4.

The most common users of PostgreSQL are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-25 of 55)
Companies can't remove reviews or game the system. Here's why
vijay bhopalwani | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Using PostgreSQL is a Very great experience it's very simple to use and PostgreSQL easily handles large datasets. and if you looking for a relational database management system PostgreSQL is great because the cost is very low compared to other databases. And the large queries speedily run and if you are stuck somewhere the documentation is great.
Score 8 out of 10
Vetted Review
Verified User
For a quick configuration of a database for an isolated system, PostgreSQL is a great choice. We use it as an external Database to support our build server systems. it is lightweight enough to be installed on the same system as the build server and provides a more robust storage system.
Aurpa Fiza | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.
June 22, 2021

PostgreSQL Review

Anson Abraham | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Like any RDBMS, it's perfect for storing structured and sometimes non structured data in the db engine. Transactional data is perfect for PostgreSQL. OLAP data works well.
What it's not suited for, is large document stores. This is where PostgreSQL doesn't do well, compared to mongo. however, newer releases show that it is getting there. Genomic data (raw data) is not suited for PostgreSQL. And PostgreSQL engine alone is not suited for timeseries data. But with extensions in place, works really well.
Score 10 out of 10
Vetted Review
Verified User
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.
Score 8 out of 10
Vetted Review
Verified User
We migrated most of the oracle databases that were used by the application services to PostgreSQL database. In most of the cases it has improved performance. From my experience, performance is good for medium to large databases but not as much different for small databases.
Erlon Sousa Pinheiro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I simply can't see any reason to use another object-relational database (other than licensing of compatibility with legacy applications) instead of PostgreSQL. I can surely affirm PostgreSQL is the most powerful, scalable, and reliable open-source object-relational database ever. Being able to handle a huge amount of data safely, PostgreSQL will offer you a final result many other paid options can't.
Moris Mendez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.
Score 10 out of 10
Vetted Review
Verified User
PostgreSQL is a phenomenal product that can satisfy most relational data needs. If you are in an environment where cost is a factor, or you are just starting with a project and needs to get up and running quickly, then PostgreSQL should be your go-to choice. It is robust, reliable, and has all the features you would need from a SQL compliant database, without all the additional baggage that comes with other more heavyweight alternatives.
Score 10 out of 10
Vetted Review
Verified User
Postgres is well suited for a variety of applications, especially where relational data is involved. Its low cost and its widespread use makes it an ideal choice when looking for a relational database. It's fast reading and writing, so it can be used in low latency applications like APIs. It works well in CRUD style applications as well.

I would not be my 1st choice for big data applications, querying extremely large data in Postgres can be slow.
Score 9 out of 10
Vetted Review
Verified User
Postgre[SQL] is well suited for various application and scenarios. Looking to its various distinct features, it is good for applications where a large data size is needed, and Analysis programs. In our case, we specifically utilized software for these too. Apart from this we saw that its distinct JSON support, custom data size, object oriented approach are too good.
Score 8 out of 10
Vetted Review
Verified User
Looking at many criteria such as the number of transactions, data type diversity, data size and application types to run in the front and concurrent use, PostgreSQL relational database is very suitable for medium and large projects. There are simpler applications for small projects.
Score 10 out of 10
Vetted Review
Verified User
PostgreSQL is well suited for complex queries, as well as simple queries. It is by far the fastest that I have seen in cloud applications to date. The number of users does not seem to affect performance.
Larger queries are able to be obtained quickly. There have been many times when asked for the information STAT and with other applications, I would not have been able to get the data in the time frame given.
Mark Mitchell | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
PostgreSQL is well suited for almost all industries and use case such as fInance, government, web apps, and even as a "NoSQL" document store with its JSONB/JSON and hstore capability. Its focus on ACID compliance makes it a trustworthy data store. It's a great central database with its ability to use external data sources and its ability to handle large workloads. Its ability to handle petabytes of data make it ideal for scientific and discovery workloads as well as AI neural networks. With PostgreSQL there is always a way to structure your data to make it fast and reliable.
Adolfo Maltez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
PostgreSQL works great for transactional environments where data integrity is a priority. It also offers different types of replication between instances that can be used for high availability and disaster recovery scenarios.
It can be very complex to use in simpler environments where what is needed is speed. Or in environments where multi-master replication is required.
Score 9 out of 10
Vetted Review
Verified User
Being an Open Source solution PostgreSQL is great choice for solutions that needs database and do not want to relay on customer database solutions.
PostgreSQL can easily integrated with many platforms we access the database from both our solution engines and the UI.
It is well known and appreciated so relaying on it as our system database can be easily accepted by our customers.
PostgreSQL continues development and support allows us to provide secure and reliable solution acceptable by customer security teams and advisors.
Paul De Audney | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
PostgreSQL is generally well suited to basically any database workload one can think of.
  • JSONB data types are great for dealing with various use cases that come up to avoid an EAV pattern.
  • Custom data types can be supported.
  • Various extensions can really add a lot of excellent features.
  • Logical replication in later versions supports per table replication.
Don Burks | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I don't know anyone who would choose another RDBMS other than PostgreSQL for a new project. Thanks to the wealth of field types, it can even function in situations where you might choose a document-based "NoSQL" db. Its indexing is excellent, meaning that high-performance applications with low thresholds for latency can benefit from it. It is the primary datastore that I recommend to anyone starting a new project which has relational data.
Vladimir Salnikov | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
In my humble opinion, the best area to use PostgreSQL - is small and medium databases with several billion or tens of billions of records/entities with some spatial attributes analytics involved in the data processing pipeline, if needed. Using PostgreSQL with the conjunction of PostGIS extension and some other open-source software such as QuantumGIS, Leaflet, etc allows users rapidly create spatial data analytics software, maintain and modify it with few resources spend.
Javier Blanque | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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).
Score 9 out of 10
Vetted Review
Verified User
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.
Balázs Kiss | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
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.
Return to navigation