Try our new research platform with insights from 80,000+ expert users

CentOS vs PostgreSQL on Ubuntu comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Feb 15, 2026

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

CentOS
Ranking in Operating Systems (OS) for Business
8th
Average Rating
8.4
Reviews Sentiment
6.6
Number of Reviews
77
Ranking in other categories
No ranking in other categories
PostgreSQL on Ubuntu
Ranking in Operating Systems (OS) for Business
31st
Average Rating
8.6
Reviews Sentiment
6.6
Number of Reviews
6
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Mohammad Wasif - PeerSpot reviewer
IT infrastructure executive at a computer software company with 201-500 employees
Has supported reliable deployments and simplified issue resolution in complex environments
The most suitable feature of CentOS is its exceptional stability, security, and long-term support, which make it a popular choice for enterprise and server environments. CentOS is widely recognized for providing a stable and secure platform, especially suited for server and mission-critical workloads. Whenever we face critical work, it is easy for our team to handle. For long-term support, each CentOS release generally guarantees long-term updates, ensuring reliability for extended periods. For package management, we use YUM and DNF in the new version for flexible and efficient software management. It depends on our users' requirements for installing CentOS. Licensing for CentOS is above my management details, so I am not aware of this information. CentOS always provides good feedback, is easy to handle, and easy to troubleshoot. The experience with CentOS OS has been very good over the last two months. I rate CentOS nine out of ten.
Pranay Jain - PeerSpot reviewer
Senior Software Developer at hireHQ
Robust relational queries have supported secure user data growth and improve transaction safety
The best features PostgreSQL on Ubuntu offers are complex joins, which allow us to perform advanced SQL queries, providing the atomicity of our tables, ACID properties for transaction safety, and scalability that we can expand to, as we currently have 10 lakh users, and it is easily scalable. Complex joins are the best feature that PostgreSQL on Ubuntu provides because I have been using NoSQL solutions such as MongoDB, but PostgreSQL has better efficiency for complex queries when used correctly. PostgreSQL on Ubuntu has positively impacted our organization because, from the initial phase with around 1,000 plus users during user accessibility testing, we defined the tables in such a manner that even with future scalability increases, it would function well, and now it has grown to 10 lakh users, still holding up well with fast data retrieval and good query performance, supported by effective indexing methods. In our user table with PostgreSQL on Ubuntu, we initially added indexing on the email property, but after a while, we found that the phone number field was also frequently used, and adding indexing to it improved our query retrieving speed and efficiency by almost 20 to 30 percent.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It's less expensive than Red Hat."
"CentOS handled that situation reliably; while there were some difficulties changing some settings inside the application, once I managed to tweak the settings, it worked very well, allowing around 10,000 users to connect and chat simultaneously."
"The product is free to use."
"It helps us install and deploy our applications."
"Setting up CentOS is straightforward, and you simply boot from a CD to get started."
"The community and knowledge base are very robust."
"I like how you can alternate certain things and minimize admin features on there and just let it run on specific scripts. It's nice. Even if I had to put it in a container, I'd still do it. I prefer Linux over Windows any day."
"The product's initial setup phase is very straightforward."
"We have worked with various databases including SQL Server and MySQL, but I found PostgreSQL on Ubuntu to be the most cost-effective and most performance-friendly solution."
"PostgreSQL on Ubuntu offers reliability, performance, and cost-effectiveness, which were the primary factors in our decision to choose this database."
"PostgreSQL on Ubuntu has positively impacted my organization by being very reliable; it has solid recovery and the risk of data loss is very low, making it very robust and ideal for production projects."
"The best advantage of PostgreSQL on Ubuntu is its ability to fulfill all our requirements as an RDBMS; we frequently use various database-related operations such as storing, retrieving, and utilizing views and triggers, and its concurrency and connection handling are very efficient, especially since we have around 1,000 users."
"PostgreSQL on Ubuntu has positively impacted our organization because, from the initial phase with around 1,000 plus users during user accessibility testing, we defined the tables in such a manner that even with future scalability increases, it would function well, and now it has grown to 10 lakh users, still holding up well with fast data retrieval and good query performance, supported by effective indexing methods."
"The best feature of PostgreSQL on Ubuntu is its structure because it adds clarity and understanding when investigating a database, which enhances readability and understandability for someone new to the project."
 

Cons

"The main issue is the End of Support. For that reason, we will switch to another operating system."
"There is no notification before updates are applied to the solution, which occasionally means that new functionality isn't compatible with how the product is currently being used, and causes issues."
"I think CentOS can be improved, but it's not really a viable option anymore."
"If a proper GUI-based tool was connected remotely or on the machine, it could be a great addition to CentOS."
"The YUM install manager can be improved. It is below average as compared to the other install managers. This is the only major problem that I see with CentOS. They should reduce dependency on the YUM manager."
"We occasionally have issues with software installation."
"The solution must improve its security."
"The stability could always be improved."
"I did notice one downside about PostgreSQL on Ubuntu. Certain queries were not behaving in the same way that SQL Server was handling those queries."
"From an improvement perspective, the UI of PostgreSQL on Ubuntu can be somewhat better because from my experience, it is outdated compared to current UI generations, and the reliability without changing the entire system architecture can also be improved, along with optimizing index management such as adding proper indexes and removing unused ones."
"PostgreSQL on Ubuntu can be improved in terms of flexibility, which comes at a cost—specifically its learning curve and complexity."
"PostgreSQL on Ubuntu can be improved because it is a bit slower than other solutions I have used."
 

Pricing and Cost Advice

"I'm not required to pay a licensing fee."
"The solution is open source so is free."
"There are no licensing fees for CentOS."
"We don’t have to pay for the system’s licenses."
"The product is free."
"There is no license required for this solution."
"There are no licensing fees. CentOS is a free solution."
"We have a CentOS license that we pay for on a yearly basis."
Information not available
report
Use our free recommendation engine to learn which Operating Systems (OS) for Business solutions are best for your needs.
884,797 professionals have used our research since 2012.
 

Comparison Review

it_user281973 - PeerSpot reviewer
Storage and VMware Expert at a comms service provider with 1,001-5,000 employees
Aug 24, 2017
It's improved our company's system environments that run Oracle databases.
Red Hat is mission critical to our environment Red Hat has improved the mission critical environments running Oracle databases, while CentOS has improved our web environment and MySQL. Oracle and SAP Environment and all HPC environments. 10 years No issues Very stable i don´t find any problem…
 

Top Industries

By visitors reading reviews
Computer Software Company
11%
Manufacturing Company
8%
Comms Service Provider
8%
Educational Organization
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business30
Midsize Enterprise22
Large Enterprise28
By reviewers
Company SizeCount
Small Business5
Large Enterprise4
 

Questions from the Community

Which would you choose - RHEL (Red Hat Enterprise Linux) or CentOS?
Red Hat Enterprise Linux is fantastic. It is an inexpensive solution that has excellent security, performance, and stability, and also lots of features. I specifically like that the solution has fe...
What is your experience regarding pricing and costs for CentOS?
I am not entirely sure about the license I purchased for my local machine, but I assume it is the community version, while for the AWS one, I do not entirely remember the pricing.
What needs improvement with CentOS?
I do not find anything that can be improved in CentOS. I am a huge fan of it, and there is hardly anything that Linux in general does not already provide. I think CentOS is the best and closest thi...
What is your experience regarding pricing and costs for PostgreSQL on Ubuntu?
For the Software as a Service version, we were using PostgreSQL on Ubuntu and paid some amount. It was not a very large amount for PostgreSQL on Ubuntu. We were on the lowest tier, so it was around...
What needs improvement with PostgreSQL on Ubuntu?
From an improvement perspective, the UI of PostgreSQL on Ubuntu can be somewhat better because from my experience, it is outdated compared to current UI generations, and the reliability without cha...
What is your primary use case for PostgreSQL on Ubuntu?
The main use case for PostgreSQL on Ubuntu is storing the database and serving as our primary database for storing the credentials of users and other information, including candidate data and enter...
 

Also Known As

CentOS 7 (x86_64) - with Updates HVM
No data available
 

Overview

Information not available
Find out what your peers are saying about CentOS vs. PostgreSQL on Ubuntu and other solutions. Updated: March 2026.
884,797 professionals have used our research since 2012.