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

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Ojoswi Basu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PostGre SQL is the relational data source for our Tableau Data. It holds data ETL-ed from MQ Listener via SSIS. This application houses all the patient and long term care facility details in a normalized relation data model. Tableau connects to Postgres and joins/massages the data to produce business consumable reports.
  • Edit data after View
  • Instantaneous access and update for Tableau extracts hooked to this data source
  • Simple syntax for DDL
Postgre SQL is well suited well in a POC and quick turn around time development activities. It is not suited to hold a dimensional data model in star or snowflake schema.

  • The Data layer for Tableau is being met and reports can be produced quickly at a summarized level
Oracle: Ideally suited for a large enterprise. Expensive product.
MS Access: Scalable for medium to small businesses
DB2: Needs expertise to implement in an organization
30
DDL/DML
Joins on Tableau VizQL for Data Visualization
3
Build And Integration team takes care of the Data Server
  • Data Layer for Analytics
  • Expand the Data Repository to other Verticals within the company
As a needed software for day to day development activities
No
  • Price
  • Product Usability
  • Third-party Reviews
  1. Product usability in the space of an Open Source-based Enterprise DB
  2. The price point for an Open-Source product is minimal, where the cost incurred is for developers working with the tool
We would want to continue using PostgreSQL for the sheer completeness of the product as to how it meets project and enterprise needs.
  • Implemented in-house
No
Change management was minimal
Since our organization is a privately owned product company in EHR long term health care, we started out with defined goals and milestones. We had a vision of leveraging open-source products from the get go. PostgreSQL was a natural choice to house analytics data in this DB.
  • There was some in-house learning curve that had to be met and
  • in-house training of debelopers
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
  • Online training
  • Self-taught
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Yes, I would strongly recommend to teams looking for an open-source EDB solution. Yes, this product is easy to learn for folks who have basic idea of PL/SQL. Yes, this product can be learned by non-technical folks with the help of product documentation and online help artifacts. With examples and code snippets, the online documentation is a great starting point.
No
It is an in-house trained team that supports softwares
Easy, quick, to the point support
No
  • Group DDL Functions on the Schema
  • Snowflake Schema
No
There are a few areas of improvement
The DB is reliable, scalable, easy to use and resolves most DB needs
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Return to navigation