PostgreSQL An Open-Source Powerhouse.
December 03, 2025

PostgreSQL An Open-Source Powerhouse.

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

We are using a PostgreSQL database for multiple Java-based applications. Due to its ease of installation and maintenance, it's been our first choice. PostgreSQL database is an open source DB that has helped us in saving licensing costs. Due to its flexibility for customization, our developers can use it for specific business needs.

Pros

  • Helping us saving in IT budget as its open-source.
  • Customisation flexibility.
  • Useful in migrating legacy databases to PostgreSQL.

Cons

  • Need improvement in adding feature like zero downtime for major upgrades.
  • Too many parameters are available to set in the database, which can confuse the database engineers.
  • Frequent blocking locks occur during certain DDL operations.
  • Saved a lot in licensing cost.
  • Easy to deploy and maintain, thus saving on human resources.
  • Support almost all types of applications, which makes it possible to have a unique database selection across the organization.
Since it's open source, we don't have to invest in licensing costs. It provides flexibility of customization, making it easy for developers to write custom functions and data types as needed for the application. It supports both OLTP and OLAP workload, making it suitable for most of the business applications.
Being open source, PostgreSQL offers the highest performance among its peers. It has a strong support community where we can find solutions to most of the queries. It's suited for GIS (Geospatial) based applications, making it unique from its peers. There are fewer databases that provide the flexibility of customization, and PostgreSQL is one of them.

Do you think PostgreSQL delivers good value for the price?

Yes

Are you happy with PostgreSQL's feature set?

Yes

Did PostgreSQL live up to sales and marketing promises?

Yes

Did implementation of PostgreSQL go as expected?

Yes

Would you buy PostgreSQL again?

Yes

PostgreSQL is well-suited for applications that need to be deployed quickly and where we want to save the licensing costs. It is also suitable for applications that need unique data handling requirements, as it provides flexibility of customization. However, it's not suitable for the workloads that require horizontal scaling.

Comments

More Reviews of PostgreSQL

  1. Home
  2. Open-Source Database Software
  3. PostgreSQL Reviews
  4. User Review of PostgreSQL