Skip to main content
TrustRadius
PostgreSQL

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

TrustRadius Insights

PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage …
Continue reading

Professional and Free

8 out of 10
May 14, 2021
Incentivized
PostgreSQL open source relational data management system takes on a task behind a critical and important application running in our …
Continue reading
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

Return to navigation

Product Demos

PostgreSQL for Beginners - Demos on pgbouncer

YouTube

PostgreSQL demo with CPP on Ubuntu Linux

YouTube

Spring Boot + Vue.js example | Spring Data JPA + REST + PostgreSQL CRUD Demo

YouTube

ASP.Net Core Web API con Docker Compose, PostgreSQL y EF Core

YouTube

Demo: Replicating Oracle Database to PostgreSQL - TechXperts

YouTube

postgresql conf demo

YouTube
Return to navigation

Product Details

What is PostgreSQL?

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.3.

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 and Ratings

(324)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage solution for traditional relational data in customer-facing systems, serving as a reliable and scalable option. Additionally, PostgreSQL is utilized as a NoSQL data store with JSON and JSONB data types, offering flexibility and versatility for developers. Users appreciate its near-complete ANSI SQL language implementation, making it handy for data extraction and analytics. PostgreSQL is also valued for its ease of integration or migration with AWS Redshift, enabling seamless data transfer between platforms. Moreover, it serves as a dedicated and per-application data storage engine, catering to the diverse needs of different business units. Whether it's for data analytics, reporting, ad-hoc data storage and retrieval, or building high-traffic API services, PostgreSQL proves to be a stable and cost-effective solution for various use cases.

Reliability and Performance: Users have consistently praised PostgreSQL for its reliability and performance, with many reviewers stating that they have experienced no downtime or issues related to the database. Some users also mentioned that PostgreSQL's performance is exceptionally fast, providing them with great speed in their operations.

Ease of Use and Flexibility: Many users find PostgreSQL easy to use and appreciate the availability of good open-source tools to work with it. Reviewers have highlighted that constructing queries in PostgreSQL is straightforward and that it integrates well with all development languages, making migration easy. The flexibility of PostgreSQL's user/role management system has also been praised by users, as it allows for easy control over access to tables.

Wide Industry Adoption and Community Support: Several reviewers acknowledge that PostgreSQL has achieved wide industry adoption, making it easier to integrate into a stack and hire knowledgeable developers. The availability of a huge online community for support was highly appreciated by users. Additionally, many users mentioned the extensive documentation available for PostgreSQL, along with the ease of finding examples, which further contributes to community support.

Complicated Installation and Setup: Many users have found the installation and setup process of PostgreSQL to be complicated, especially for Mac users. They have mentioned the need to learn new commands and have recommended blog posts for guidance.

Difficult Syntax of SQL: Users have expressed difficulty in understanding the syntax of SQL in PostgreSQL, which they find different and hard to grasp. This may be a reason why the software is not widely adopted.

Lack of Clear Benefits: Users have mentioned the lack of clear benefits for choosing PostgreSQL over other products. They feel that there are better alternatives available with more extensive features, documentation, and community support.

Based on user reviews, PostgreSQL is recommended for its ease of use, fast execution, and compatibility with other PostgreSQL users. Users also find its functionality, friendly SQL operations, and good GUI feature beneficial. It is suggested as an alternative to other complex query language platforms.

Reviewers highly recommend PostgreSQL for its scalability, robustness, and reliability. They believe it is the best relational database with great popularity among developers. It is suggested for work, learning, career purposes, as well as small and medium development projects. Users also mention its suitability for incremental development and cost reduction.

PostgreSQL is praised as a world-class and free database with a vibrant community that provides great support. Reviewers recommend it for its cost-effectiveness and suitability as a free relational database. It is suggested as the default database choice for developers, including testing and staging environments. The growing community around PostgreSQL is seen as an advantage.

Other notable recommendations include the speed, security, and reliability of PostgreSQL. It is considered suitable for querying large amounts of data and prioritizing security. Users emphasize the importance of familiarizing oneself with SQL, utilizing the documentation, and keeping up with the latest versions of PostgreSQL. They suggest having database experts on the team for production use.

Additionally, users suggest using PostgreSQL for lightweight installations, optimal database management, building reporting engines, data analysis with good security features at an affordable price, and implementation in systems with array support.

Some users request improvements such as easier configuration processes for Windows users or adding real-time database support or developing another database app. Online resources are recommended for training and support when learning PostgreSQL.

Overall, users find PostgreSQL to be a complete and easily accessible database system with multi-version concurrency support that offers a reliable solution for various needs.

Attribute Ratings

Reviews

(26-50 of 53)
Companies can't remove reviews or game the system. Here's why
Arthur Zubarev | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is used across the entire organization and in more than one instance. PostgreSQL was already a part of a wide scale Ruby On Rails implementation and thus was a natural fit for the use in data analytics in form of data marts, data inter-exchange, reporting, and ad-hoc data storage and retrieval.
PostgreSQL fulfills a role of a dedicated and/or per-application or solution data storage engine. Its versatility and flexibility combined with exceptional user community support make a stand-out product. Integration or migration with AWS Redshift is easy and seamless. PostgreSQL has a near-complete ANSI SQL language implementation which makes it very handy for data extraction and analytics.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is being used as the main data warehousing system by our organization for various analytics functions. It is being used across our whole organization both internally and externally to generate reports and other dashboards products. The business problems it addresses is the need to run complex analytics queries without having too much time be burned up by running the query on MySQL.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL on Greenplum is being used as a data warehouse by the entire data and analytics team on my project. There are also other teams using the database as well, but it solves the business problems of running large analytics workflows with billions of rows of archived data to create reporting dashboards. It is able to run in a massively parallel processing format.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is used throughout our company to power business applications and to drive data-driven decision making. It's mostly used by software development teams as a back-end for data-driven applications. We usually deploy PostgreSQL instances via AWS and connect to them through a PaaS (Platform as a Service) that hosts our applications. Other teams use it for analytical data processing.
Jacob Biguvu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Capital One has many LOBs (line of businesses). I have supported IAM and Commercial LOB. They are using PostgreSQL as an OLTP database solution. Company is using Oracle, SQL Server as OLTP solution for the most of their requirements. Since everyone moving to Cloud and want to use the open-source solutions, the company encourages the IT teams to use PostgreSQL.
Aaron Smith | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
After using Microsoft's SQL Server for many years for our application's back end data storage, we made the switch to PostgreSQL for all new application development. For our use case, PostgreSQL has the same feature set SQL Server has and comparable performance. We needed a way to have multiple server clusters for redundancy and licensing costs of SQL Server were starting to get prohibitive. PostgreSQL gives us a stable and more cost-effective solution for data storage.
Richard Rout | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use PostgreSQL as our database backend on the majority of our applications across the whole organization. It solves all of the problems that a relational database would solve. It's a very similar product to MySQL or Microsoft SQL Server and supports a very similar query syntax to both of those.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I personally have used PostgreSQL for several personal projects. I've also used PostgreSQL in previous roles at other companies. In my current role, I mainly rely on APIs and other systems built on PostgreSQL. In all instances, PostgreSQL was chosen because of its performance and versatility. Also a consideration was its longevity and market penetration - this product has been around for a long time and is well used in the industry.
Carlos Alberto Pedron Espinett | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL emerged as a robust option for a re-engineering process that consisted of migrating our business platform from Microsoft SQL server to PostgreSQL. The following were determining factors in our selection: the migration from Borland Delphi to PHP, the ability work in web environments in the frontend of the company, and the product's versatility and ability to adapt to content growth.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Currently, PostgreSQL is being used as an email texting mining tool, where I load a flat file email archive into postgresql and then auto-generate keys, which I can then use to find certain keywords.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is a good alternative in the open source database world. We were looking for an open source, reliable database for one of our products and selected PostgreSQL over MySQL due to its rich features. We used it as a transaction database.it has server side programming languages such as PL/Pg-SQL and have options to write functions in Python, Perl , Java, Ruby, C and R. With its latest releases it has support for JSON and is the only open source database with Geo spatial support.
Flávio Carmo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use PostgreSQL as our main database platform, for our cloud solutions, GIS applications and all new products. We used Oracle Database for many years before, but it is now only a bad memory, from high costs to low quality resources. PostgreSQL is superior, more simple but robust and a complete database solution.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
In my previous and current organisation we develop applications using PostgreSQL as one of or the database of choice to store application data. I have used it in both client-server implementations where it is used to store data for a single company as well as in cloud implementations where it is used to store data across many companies and users. Recently I have used it as the database in a data warehouse solution, data mining millions of rows.
Anatoly Geyfman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Postgres for both OLAP and OLTP use cases. We use it as our data warehouse, for interactive queries, and for storing application data. Postgres is one of our main data warehouses, and we use it in congress with BigQuery to store, analyze and finally index data into our ElasticSearch cluster. One of our primary uses of Postgres is for geospatial analytics, so we leverage the PostGIS extension extensively.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is used organization wide. We are a very federated organization and each team maintains its own instances of PostgreSQL. We use it through Amazon RDS. PostgreSQL is used to maintain transactional data about our acquisition customers and for AML.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use PostgreSQL as a central location for relational data. Almost all of our applications tie into PostgreSQL in one way or another. We also use PostgreSQL as a data warehouse and analytics engine for several hundred gigabytes of data. That figure continues to rise rapidly, and PostgreSQL is handling the load perfectly well.
Eric Mann | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use PostgreSQL across the organization for data storage across multiple web-based microservices. It's easily scalable, hosted on AWS, and provides deeper features we need when querying against complex data types (namely against JSON).
Josh Stapp | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is being used to store 5TB of advertising data for our web app. It has a very fast response time and the JSON support is a nice feature. Since we already know SQL learning it has been easy and the index/pg tables contain a lot of helpful information for us to use.
February 14, 2017

A great RDBMS

Nikhil Karkare | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are using PostgreSQL for our business intelligence and analytics purposes. We are using it to store the integrated data from the multiple data sources. In short, we are using it to store our data warehouse. We pull the data from here to create the reports in our reporting tool.
Nitin Pasumarthy | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I used PostgresSQL as a GeoSpatial database for creating map server. For that I installed PostGis plugin which provides GeoSpatial functions which are useful for creating map tiles from vector data. A detailed description of what all I did with Postgres in this project can be found at https://sites.google.com/site/nitinpasumarthy/blog/createyourowntileserverandmapclient under sections 2 and 3 ("Process Data" & "Create tiles from Postgres").
Christopher Weiss | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We have used PostgreSQL as an application database for PHP, Ruby, and Java based applications. It has been used primarily for our customers' internet facing application. PostgreSQL presents a feature-rich open source database with many of the same capabilities as enterprise databases.

PostgreSQL presents a better stored procedure language as well as having better integration for geo spatial capabilities than MySQL. For setup and administration it is more flexible than SQL Server or Oracle.

In general, PostgreSQL tends to be overlooked.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL was used when prototyping a new website for Ruby on Rails. It meshed seamlessly and allowed us to iterate quickly for our minimum viable product. We deployed on a Heroku server and there was no issue with getting it to work. It's comparable to the other free SQL solutions on the market, but it was great for us in this case.
Return to navigation