TrustRadius Insights
PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage …
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.
Recent 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
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
Product Details
- About
- Integrations
- Tech Details
- FAQs
What is PostgreSQL?
PostgreSQL Video
What is PostgreSQL?
PostgreSQL Integrations
PostgreSQL Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
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).
Comparisons
Compare with
Reviews and Ratings
(323)
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!
- Business Problems Solved
- Pros
- Cons
- Recommendations
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-25 of 53)Companies can't remove reviews or game the system. Here's why
November 07, 2022
Best Relational and Open Source Database
Score 9 out of 10
Vetted Review
Verified User
- Cost Effective
- Easy To Use
- Improved the Productivity of devlopment
- it has allows us to quickly deploy database dependent systems with an isolated data layer
- The cost has saved us a large sum of money compared to paid options in the space
- Setup time is very short meaning we can spend more time developing and less time configuring
Score 8 out of 10
Vetted Review
Verified User
- A robust and reliable platform reduces the risk of data loss and confusion.
- Using an almost free product is economical. No license fees = minimal ownership cost.
- Efficiency is high due to quickness and excellent resource management.
- PostgreSQL helps us achieve our goals, and there are no time-consuming management tasks.
June 22, 2021
PostgreSQL Review
- reduce costs in lookup for reference data
- Easily backed up vs doing backups of files over and over
- versioning of data, vs backups of db
- structuring of data to decrease storage costs
- Free to use, means that we can have as many database instances as we need without cost increase.
- JSON support is very helpful and saves quite a lot of time querying and searching for data.
- ACID compliance means with the right implementation and usage we can almost certainly trust the data.
- It definitely helped us to save licensing cost.
- Cheaper support cost.
- Cheaper maintenance cost as it's not resource intensive.
June 05, 2021
Don't be afraid on adopting it. PostgreSQL delivers more features than most of the paid databases from big brands.
- No license costs
- High availability
- Scalability
June 02, 2021
PostgreSQL you don't want to stop using it
- Being a platform of great robustness and quality, it generates confidence in the security of the data, which minimizes the risk of confusion or loss of data.
- Efficiency is extremely high due to the speed and excellent management of resources.
- PostgreSQL contributes greatly to the fulfillment of the objectives of our area that is focused on legal aspects of the population that requests them and this tool helps to streamline our internal processes.
- Open source means reduced initial startup cost.
- Very reliable means we do not need to worry about data loss.
May 19, 2021
Postgres - tons of people use it for a reason!!
- Postgres has been a great database solution without breaking the bank
- Cost of running and maintenance is very low
- License free of cost
- Sufficient resources available to implement and practices
May 14, 2021
Professional and Free
- Since it did not create a cost step before the project, it enabled us to act more flexibly on the upper source or software side.
- We got rid of unpredictable costs such as user CAL licenses after project completion
- Instance number or core count is not the cost on the postgresql side, but the units of performance do not need to learn a lot for license.
May 14, 2021
A solid solution for data teams
- We don't need as many developers because we can hire analysts to write dashboards in BI tools
- Minimize risk of errant queries slowing down the production database
May 02, 2021
PostgreSQL, the best data retrieval
- Achieve our objectives speedily
- Obtain all of our data, not just bits and pieces like some other apps
- Very low cost of ownership with zero license fees
- Cost of running PostgreSQL using RDS can be high but has lots of value
- Agility in the implementation of applications.
- Data integrity.
April 20, 2021
PostgreSQL as Solution base database solution
- Open Source solution that does not cost more money to our customers help us keep our solution cost affordable.
- Excellent database that is well supported and continue development allow us to benefit from our investment for many (more than 15) years.
April 08, 2021
NoSQL workloads shine on PostgreSQL
- Performance over NoSQL solutions when you introduce data consistency guarantees
- Licensing costs don't exist
April 08, 2021
PostgreSQL delivers on its promise.
- Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
- Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
- It's free. You can't beat that.
- By using our product we managed to save over 8000 hectares of winter wheat at the years 2015-2020
April 01, 2021
Postgres review
- It's a great database but it's hard for me to quantify ROI for it versus other popular database solutions.
April 27, 2020
PostgreSQL - The database that fits all
- Being open source free software, the ROI couldn't be better.
- There are a lot of young developers who know the technology and are interested in advancing their careers with the platforms and technologies in which they are invested. It is more easy to contract developers for the platform, then the projects are more quickly finished, then the ROI is made in shorter time.
- There is a lot of prejudice with PostgreSQL and open source in general, because, they say, there is no company behind it, but thank God, their minds are changing. A lot of companies and consultants will technically support your project and your infrastructure.
February 14, 2020
Battle-tested-never-data-loss alternative to MySQL
- The user-role system has saved us tons of time and thus money. As I mentioned in the "Use Case" section, Postgres is not only used by engineering but also finance to measure how much to charge customers and customer support to debug customer issues. Sure, it's not easy for non-technical employees to psql in and view raw tables, but it has saved engineering hundreds of man-hours that would have had to be spent on building equivalent tools to serve finance or customer support.
- It provides incredibly trustworthy storage for wherever customer data dumped in. In our 6 years of Postgres existence, we have not lost a byte of customer data due to Postgres messing up a transaction or during the multiple times the hard-drives failed (thanks to ACID compliance!).
- This is less significant, but Postgres is also quite easy to manage (unless you are going above and beyond to squeeze out every last bit of performance). There's not much to configure, and the out of the box settings are quite sane. That has saved us engineers lots of time that would have gone into Postgres administration.
January 20, 2020
A robust, free, and high quality DB
- It has expanded our capabilities to work with companies which do not want to pay for Oracle licences, but still need a reliable DB.
- It's one of the most successfull DBs. Knowing how to use it has extended our value on the market.
January 16, 2020
PostgreSQL is fast, cheap and easy (and fully featured!)
- Reduced overall database costs
- Reduced time to deploy