No more typing reviews! Try our Samantha, our new voice AI agent.

LAMP Stack CentOS vs PostgreSQL on Ubuntu comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

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

LAMP Stack CentOS
Ranking in Operating Systems (OS) for Business
24th
Average Rating
8.2
Reviews Sentiment
3.5
Number of Reviews
10
Ranking in other categories
No ranking in other categories
PostgreSQL on Ubuntu
Ranking in Operating Systems (OS) for Business
15th
Average Rating
8.6
Reviews Sentiment
6.6
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2026, in the Operating Systems (OS) for Business category, the mindshare of LAMP Stack CentOS is 0.3%. The mindshare of PostgreSQL on Ubuntu is 1.0%, up from 0.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Operating Systems (OS) for Business Mindshare Distribution
ProductMindshare (%)
PostgreSQL on Ubuntu1.0%
LAMP Stack CentOS0.3%
Other98.7%
Operating Systems (OS) for Business
 

Featured Reviews

MK
Senior System Specialist at a transportation company with 51-200 employees
Bundled web stack has simplified secure payment workflows but still needs smoother upgrades
Regarding how LAMP Stack CentOS can be improved, I would add a few points. Over the two decades of optimizations, the relational integrity that MariaDB and MySQL handle for complex data relationships and transactional integrity is perfect. The cost efficiency is also excellent. LAMP Stack CentOS's scalability is good so far, but there are some challenges as well. As we enter the agentic AI, achieving stability in LAMP Stack CentOS depends entirely on managing traditional web infrastructure. I manage the web infrastructure easily via LAMP Stack CentOS. However, when I try agentic AI, instability does not mean server uptime. I mean execution predictability and preventing logical failure. Therefore, AI in LAMP Stack CentOS becomes unstable and exhibits special behavior. LAMP Stack CentOS is stable in my experience; however, sometimes when more traffic comes and hits, it fluctuates. When we need to upgrade, there are some difficulties in LAMP Stack CentOS. Suppose I need to use MySQL 8 in my production environment but my LAMP Stack CentOS is outdated. At that time I need to upgrade the full stack to maintain it. If I use Apache, MySQL, and PHP separately, my DBA can normally upgrade MySQL, and my developer can upgrade PHP. However, when I use LAMP Stack CentOS, the whole team combination is needed, and then we can upgrade the full stack. This is the challenge so far.
MG
CEO at Grant Corporation
Consistent use of flexible data and solid transactions has reduced costs and simplified projects
PostgreSQL on Ubuntu could be improved with easier out-of-the-box configuration. The default settings for PostgreSQL on a fresh Ubuntu install are very conservative. Things such as shared buffers and work memory are too low for any real production workloads, and you have to know how to go in and tune it manually. A smart default configuration wizard during installation that detects hardware and suggests settings would save a lot of junior developers from performance headaches. That is important. Built-in connection pooling is another area; PostgreSQL does not handle large numbers of concurrent connections well natively. You end up needing to set up PG Bouncer separately, which is another tool to learn, configure, and maintain. Having a lightweight connection pooler built into the core installation would be a real quality-of-life improvement. Additionally, a better built-in monitoring UI would help. Primarily, if you are working with Ubuntu, you are largely working with PostgreSQL on the command line and installing third-party tools such as pgAdmin or Adminer. A lightweight built-in web dashboard for basic health monitoring would improve projects significantly. Finally, upgrades between major versions and smaller versions should be a lot easier as well. None of these are deal-breakers; they are just nice to have improvements.

Quotes from Members

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

Pros

"The best feature that LAMP Stack CentOS offers in my experience is that I am getting the bundle where Apache, MySQL, and PHP come together, it is easy to maintain, easy to provide support, and when I am using LAMP Stack CentOS, I need minimum resources."
"LAMP Stack CentOS builds client trust that we can get our projects live in no time and builds credibility for the organization."
"LAMP Stack CentOS has positively impacted my organization significantly, especially for a client with an e-commerce platform selling bikes and cars, because easy deployment allows me to implement small changes within minutes and resolving log issues is straightforward, which means my clients are pleased with the simplicity and effectiveness of the tool."
"LAMP Stack CentOS has positively impacted my organization by allowing me to better serve clients with PHP in a smooth way, so I don't need to request anything else from my clients to run their applications."
"The best features LAMP Stack CentOS offers in my experience are its better supportability compared to Debian, Ubuntu Mint, and Oracle support is much better."
"LAMP Stack CentOS has positively impacted my organization in multiple ways, making life easier, particularly in terms of cost because all of this is open source and free, so the cost is very minimized."
"LAMP Stack CentOS has impacted my organization positively as it was the main stack for the development and hosting of the developed solutions for some of the companies."
"LAMP Stack CentOS has positively impacted my organization by providing a standard, zero-license, licensing-free gateway into the Red Hat enterprise ecosystem."
"PostgreSQL on Ubuntu has positively impacted my organization by allowing us to overcome the performance issues we faced while running PostgreSQL on Ubuntu in a different environment, Windows-based, which was not as performant and required a lot more memory and CPU bandwidth than our eventual Ubuntu deployment."
"From my experience, one of the biggest advantages of PostgreSQL on Ubuntu is that it is an RDBMS that performs well based on stability, and it is quick to set up and accessible, not demanding multiple editors or support tools, making it preferable for small-end website requirements."
"In summary, PostgreSQL on Ubuntu represents something that is becoming rare in the software world, which is a mature, stable, genuinely free tool that does not have a commercial agenda pushing you toward a paid tier or a vendor locking strategy."
"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."
"If you are really looking into some data management systems that are much more lightweight as well as capable and higher in performance, you should definitely go with PostgreSQL on Ubuntu."
"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 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."
"The biggest benefit in PostgreSQL on Ubuntu for me is the open-source advantage, as it allows me to look into the code, understand the logic, mold my code according to it, and it will work perfectly rather than proprietary solutions where I am very much dependent on the vendor and have to wait for their next release to fix things."
 

Cons

"LAMP Stack CentOS could be improved in terms of configuration being a little easier."
"The biggest challenge is that the stack is very stable, but it can feel traditional compared to containerized or cloud-native platforms."
"For chat or live streaming, when we are using LAMP Stack CentOS, it does not provide us the full feature."
"LAMP Stack CentOS can be improved by tracking the CVEs and releasing fixes as fast as possible."
"The performance of LAMP Stack CentOS when handling high-traffic websites or demanding workloads might require us to set up some load balancing."
"I would like to see new functionalities or improvements in LAMP Stack CentOS because the packets are older than in other distros."
"The bigger area for improvement for LAMP Stack CentOS is overall ecosystem lifecycle predictability."
"LAMP Stack CentOS has not really impacted my organization positively."
"One of the main improvement points for PostgreSQL on Ubuntu would be that the team, even though it is an open source solution, could have more events and meetups promoted by PostgreSQL itself and by the PostgreSQL team, with companies and developers in the main commercial centers of the world."
"Regarding technical support for PostgreSQL on Ubuntu, there is a need for quick support services when the solution is not built well, and community support is usually helpful in addressing queries and finding solutions to various scenarios."
"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."
"PostgreSQL on Ubuntu's accuracy and reliability of output is pretty naive from my perspective."
"PostgreSQL on Ubuntu can be improved because it is a bit slower than other solutions I have used."
"PostgreSQL on Ubuntu can be improved by providing some inbuilt AI agent mode, as nowadays many applications are offering such features."
"The challenge, or the real learning curve, was in the permissions and configuration."
"Managing PostgreSQL on Ubuntu at the production level was a bottleneck, but overall, it was a good experience and I learned a lot."
report
Use our free recommendation engine to learn which Operating Systems (OS) for Business solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Construction Company
40%
Manufacturing Company
9%
Outsourcing Company
7%
Transportation Company
7%
Construction Company
23%
Financial Services Firm
11%
Comms Service Provider
10%
Outsourcing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise1
Large Enterprise5
By reviewers
Company SizeCount
Small Business10
Midsize Enterprise4
Large Enterprise11
 

Questions from the Community

What needs improvement with LAMP Stack CentOS?
I would like to see new functionalities or improvements in LAMP Stack CentOS because the packets are older than in other distros. All the packets may have a new version, but it's okay.
What is your primary use case for LAMP Stack CentOS?
I continue using LAMP Stack CentOS because I have a lot of websites and it is the main solution for my enterprise to support websites with WordPress and PrestaShop.
What advice do you have for others considering LAMP Stack CentOS?
LAMP Stack CentOS is a good product. Laravel has good support, and PHP modules have good community support for their use with LAMP Stack CentOS. Marketing for LAMP Stack CentOS is poor because I do...
What is your experience regarding pricing and costs for PostgreSQL on Ubuntu?
My experience with pricing, setup cost, and licensing for PostgreSQL on Ubuntu is that everything is good.
What needs improvement with PostgreSQL on Ubuntu?
PostgreSQL on Ubuntu can be improved by adding more diverse components and ad hoc features like data analysis and data analysis models on-premises. For example, creating Jupyter notebooks or analyz...
What is your primary use case for PostgreSQL on Ubuntu?
My main use case for PostgreSQL on Ubuntu is to store data, especially telemetry data and customer data. I had a client whose telemetry data was coming online on one of their on-premises devices. I...
 

Also Known As

LAMP Stack on CentOS
No data available
 

Overview

Find out what your peers are saying about LAMP Stack CentOS vs. PostgreSQL on Ubuntu and other solutions. Updated: September 2026.
915,341 professionals have used our research since 2012.