No more typing reviews! Try our Samantha, our new voice AI agent.
Software Engineer at Government of India
Real User
Top 5Leaderboard
Apr 17, 2025
Handles high-demand database operations efficiently and offers significant cost savings
Pros and Cons
  • "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."
  • "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."

    What is our primary use case?

    We use PostgreSQL on Ubuntu for storing our data related to high court cases.

    What is most valuable?

    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. Its concurrency and connection handling are very efficient, especially since we have around 1,000 users.

    What needs improvement?

    We have not faced any errors, and for our purposes, PostgreSQL on Ubuntu is working perfectly. However, integrating AI features for analytical data generation might be beneficial as our processes are increasingly dependent on AI tools.

    For how long have I used the solution?

    We have been using PostgreSQL since 2018.
    Buyer's Guide
    PostgreSQL on Ubuntu
    March 2026
    Learn what your peers think about PostgreSQL on Ubuntu. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
    885,728 professionals have used our research since 2012.

    What do I think about the stability of the solution?

    I have found PostgreSQL on Ubuntu to be a very stable product.

    What do I think about the scalability of the solution?

    PostgreSQL on Ubuntu is very scalable with no restrictions.

    How are customer service and support?

    We have not utilized customer support, as we generally obtain information from publicly available sources.

    How was the initial setup?

    The initial setup is quite easy to install, with the documentation being very well-organized. We do it ourselves without needing external technical assistance.

    What about the implementation team?

    We handle the installation ourselves.

    What was our ROI?

    We find the solution able to make savings of around 10% to 20%, depending on the solution being used.

    What's my experience with pricing, setup cost, and licensing?

    PostgreSQL on Ubuntu is free of cost. We are not purchasing anything additional.

    What other advice do I have?

    I would rate PostgreSQL on Ubuntu as a ten out of ten. The only suggestion for improvement is to add AI features.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Consultant at a tech vendor with 10,001+ employees
    Real User
    Top 5Leaderboard
    Dec 25, 2025
    Advanced queries have powered feature engineering and ensured reliable data analysis
    Pros and Cons
    • "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."
    • "PostgreSQL on Ubuntu can be improved because it is a bit slower than other solutions I have used."

    What is our primary use case?

    My main use case for PostgreSQL on Ubuntu is to query the database and the tables.

    A quick specific example of a task where I used PostgreSQL on Ubuntu to query the database or tables is that I query the tables with SQL code, and it is very smart. I do feature engineering directly in SQL.

    What is most valuable?

    The best features PostgreSQL on Ubuntu offers include advanced queries. Its extensions are very smart, such as PostGIS. It is very smart and flexible.

    The advanced query feature has helped me because I can use CTE and window functions, subqueries, and complex subqueries, providing great flexibility.

    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. It is very robust and ideal for production projects.

    What needs improvement?

    PostgreSQL on Ubuntu can be improved because it is a bit slower than other solutions I have used. I would also appreciate the ability to use the EXPLAIN ANALYZE tool.

    What do I think about the stability of the solution?

    PostgreSQL on Ubuntu is stable.

    What do I think about the scalability of the solution?

    PostgreSQL on Ubuntu's scalability is good.

    How are customer service and support?

    I have not had any experience with customer support.

    How would you rate customer service and support?

    Which solution did I use previously and why did I switch?

    Before PostgreSQL on Ubuntu, I previously used MySQL, but it is inferior in comparison.

    What was our ROI?

    I have seen a return on investment with PostgreSQL on Ubuntu through time saving.

    Which other solutions did I evaluate?

    Before choosing PostgreSQL on Ubuntu, I evaluated MySQL as another option.

    What other advice do I have?

    Since using PostgreSQL on Ubuntu, I have seen specific outcomes such as being very solid with no loss of data, which saves time.

    My advice to others looking into using PostgreSQL on Ubuntu is to use it to improve coding and to improve skills in feature engineering and in coding with window functions or data ingestion with JSON or the integration with Python, R, and Jupyter Notebook. I have given this review a rating of 8.

    Which deployment model are you using for this solution?

    On-premises

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Other
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    Last updated: Dec 25, 2025
    Flag as inappropriate
    PeerSpot user
    Buyer's Guide
    Download our free PostgreSQL on Ubuntu Report and get advice and tips from experienced pros sharing their opinions.
    Updated: March 2026
    Buyer's Guide
    Download our free PostgreSQL on Ubuntu Report and get advice and tips from experienced pros sharing their opinions.