TrustRadius: an HG Insights company
PostgreSQL Logo

PostgreSQL Reviews and Ratings

Rating: 8.7 out of 10
Score
8.7 out of 10

Community insights

TrustRadius Insights for PostgreSQL are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

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.

Reviews

53 Reviews

Best Relational and Open Source Database

Rating: 9 out of 10

Use Cases and Deployment Scope

PostgreSQL is an Open Source Database that is used for mainly Relational database Systems. We are mainly using this database because of the microservice structure. And in microservices, we have a lot of databases and also it's open source so that is good for our organization. And it's an object-relational database the performance of the database is pretty good.

Pros

  • Well documentation and it's free
  • JSON Support
  • It can handle large database
  • Real time data
  • Security is very good
  • Good Interface and easy to work

Cons

  • Scrolling is not good if you change something on screen you have to reset the screen
  • Handling JSON type is not great
  • data comparison is not good.

Likelihood to Recommend

Using PostgreSQL is a Very great experience it's very simple to use and PostgreSQL easily handles large datasets. and if you looking for a relational database management system PostgreSQL is great because the cost is very low compared to other databases. And the large queries speedily run and if you are stuck somewhere the documentation is great.

postgreSQL, a great choice from startup to enterprise

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use postgreSQL in instances where we need an isolated database to support a microservice architecture, or an isolated system. It allows us to leverage a simple and inexpensive database option where a larger scale enterprise configuration would be over engineering. We commonly use it for build automation systems in our organization.

Pros

  • Easy to set up
  • Simple to configure
  • Clean and effective UI

Cons

  • I would appreciate the ability to get performance tuning recommendations

Likelihood to Recommend

For a quick configuration of a database for an isolated system, PostgreSQL is a great choice. We use it as an external Database to support our build server systems. it is lightweight enough to be installed on the same system as the build server and provides a more robust storage system.

Vetted Review
PostgreSQL
3 years of experience

"PostgreSQL is the most sophisticated and adaptable database software available."

Rating: 8 out of 10

Use Cases and Deployment Scope

PostgreSQL is the most advanced and versatile DB system available and is well documented. It’s cool, and there is a lot of diversity among the people who help with it. PostgreSQL has a project (phAdmin) that allows us to carry out tasks using a friendly graphical user interface, making it an incredible database manager. It has a command-line interface for Linux and Windows that is simple to use. In addition, Golang and Python and their frameworks, such as Django for Python, can be integrated. A comprehensive documentation website makes learning about all of its features easy.

Pros

  • It works well with external data sources and runs on platforms with stable performance.
  • Clients can rest assured that their personal information will be safe and secure.
  • Many forums discuss setup and usage, and most are free.
  • Adding tooling applications to a computer is unlimited.
  • PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.

Cons

  • Increasing horizontal scaling is complex, but PostgreSQL may have a solution for all replicas to accept operations.
  • No column re-ordering and better data compression are required.
  • PostgreSQL is often criticized for being slow and unsuitable for large-scale enterprise applications.

Likelihood to Recommend

PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.

Don't be afraid on adopting it. PostgreSQL delivers more features than most of the paid databases from big brands.

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Currently, we are using PostgreSQL to support some DevOps operations, mainly related to monitoring (as a Zabbix database server) and configuration management (it is the database used by our Puppet/PuppetDB environment). We use it as a regular deployment as well as a Database as a service (on AWS RDS).

Pros

  • Handle large amounts of data.
  • It is scalable (for reading purposes).
  • It is compatible with so many languages as the language for triggers and stored procedures.

Cons

  • PostgreSQL could have a solution to accept operations on all replicas.
  • Could improve its "full vacuum schema" in order to be less painful for applications.
  • Could have an in-memory table type instead of having to create a partition on an in-memory file system.

Likelihood to Recommend

I simply can't see any reason to use another object-relational database (other than licensing of compatibility with legacy applications) instead of PostgreSQL. I can surely affirm PostgreSQL is the most powerful, scalable, and reliable open-source object-relational database ever. Being able to handle a huge amount of data safely, PostgreSQL will offer you a final result many other paid options can't.

PostgreSQL you don't want to stop using it

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

In our department PostgreSQL is used as the main database that supports our transactional systems, reaching a consensus for the use of a single database throughout the organization requires a joint effort that leads to a feasibility study and implementation that determine the best way forward to unify the use of a single database platform.

Pros

  • The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
  • The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
  • The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
  • The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.

Cons

  • PostgreSQL installation must be homogeneous across all supported operating systems
  • It would be helpful to have an index of compatible tools, plugins or complementary applications within itself to increase productivity.
  • Regarding the administration of PostgreSQL itself, it would be very helpful to have a dashboard that will show us the insecurities of security, stability and operability in order to have an overview of PostgreSQL behavior.

Likelihood to Recommend

PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.

Best open source relational database you can have

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

PostgreSQL is one of the databases we use for our systems and products. Most of our IT systems run on PostgreSQL, such as issue tracker and wiki. We also use PostgreSQL to store analytic data which would then be fed to analytic and reporting tools to generate graphs and dashboards.

Pros

  • Supports and runs on most popular operating systems and environments.
  • Most cloud vendors support PostgreSQL.
  • Solid and reliable, PostgreSQL has been around for a very long time.
  • Has a huge online community that can help you with any questions and challenges.
  • Open source, so cost of initial ownership is much lower than Oracle, MS SQL Server.

Cons

  • Horizontal scaling can be difficult.
  • Has support for JSON type, but needs more work if compared to something like MongoDB.

Likelihood to Recommend

PostgreSQL is a phenomenal product that can satisfy most relational data needs. If you are in an environment where cost is a factor, or you are just starting with a project and needs to get up and running quickly, then PostgreSQL should be your go-to choice. It is robust, reliable, and has all the features you would need from a SQL compliant database, without all the additional baggage that comes with other more heavyweight alternatives.

Vetted Review
PostgreSQL
7 years of experience

Postgres - tons of people use it for a reason!!

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

We use Postgres for a variety of applications, from high availability/high traffic API services to simpler CRUD style single-page applications. It fulfills a need for a low-cost relational data store that has been tested and proven to work. Its use of common SQL is known by many engineers so the learning curve is very low.

Pros

  • Ability to handle very large datasets, 100's of GB
  • Great tooling, great selection of mature tools to pick from
  • Available in most cloud platforms
  • Easy to install and maintain
  • Low learning curve for engineers

Cons

  • I don't really have any big complaints, it's popular because it's good!

Likelihood to Recommend

<div>Postgres is well suited for a variety of applications, especially where relational data is involved. Its low cost and its widespread use makes it an ideal choice when looking for a relational database. It's fast reading and writing, so it can be used in low latency applications like APIs. It works well in CRUD style applications as well.</div><div>

</div><div>I would not be my 1st choice for big data applications, querying extremely large data in Postgres can be slow.

</div>

Vetted Review
PostgreSQL
4 years of experience

PostgreSQL is awesome opensource database with NoSQL support

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Postgre[SQL] is awesome, as it ha[s] lots of distinct things in itself. It is [a] highly extensible object relation database. We are using this for our current applications like Virtual Class and StudyShot purposes. We are storing larger pools of servers for virtual class purposes, which uses Postgre[SQL] as backend server. These applications are organization-wide products. Overall, Postgre[SQL] is superb in larger queries, where it is solving our day-to-day business problems in complex programs. Its performance and security both are satisfactory. Postgre[SQL] have features to extend which is a very good [quality].

It [is] platform independent, so we need not to worry about [having a] specific environment. Very good support for replication also relieves us from [the] data lost burden. Its cost for owning and maintaining [in] comparison to SQL server is low so it [suits us well].

Pros

  • Built in Json support which usually takes less space and eliminates us from re-parsing again in application and can be indexed
  • Support for large size data is awesome. Currently for loggings of analytics data we use it
  • Postgre[SQL] is more secure which we have experienced. MySQL got corrupted but it retained our data.
  • Its extension support is awesome. Through its inbuilt concurrent, we get faster results

Cons

  • Its management is not easy as expected
  • Data compression needs to be more better
  • Clustering and replication need to be improved
  • For JSON datatype, queries need to be better

Likelihood to Recommend

Postgre[SQL] is well suited for various application and scenarios. Looking to its various distinct features, it is good for applications where a large data size is needed, and Analysis programs. In our case, we specifically utilized software for these too. Apart from this we saw that its distinct JSON support, custom data size, object oriented approach are too good.

Professional and Free

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

PostgreSQL open source relational data management system takes on a task behind a critical and important application running in our information systems infrastructure. Although we did not like the use of a separate model database for this application because it was different and critical at first, we are very pleased at the moment, it was unnecessary to hesitate.

Pros

  • Offering high performance.
  • It's free.
  • It is an institutional solution. And its use in very large and important national projects.
  • Good at security.

Cons

  • No compression
  • No machine learning included

Likelihood to Recommend

Looking at many criteria such as the number of transactions, data type diversity, data size and application types to run in the front and concurrent use, PostgreSQL relational database is very suitable for medium and large projects. There are simpler applications for small projects.

Vetted Review
PostgreSQL
2 years of experience

A solid solution for data teams

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

We've used PostgreSQL for years as a tool for our data team. We use MongoDB for operational data, but we pipe MongoDB data into Postgres. If we need a chart for an investor deck or someone has a non-trivial data question, our data team queries Postgres.

Pros

  • BI tool integration - Periscope/Sisense, Looker, etc.
  • SQL is a common skill, and Postgres' dialect strikes a good balance between stability and usability
  • JSON support

Cons

  • Running PostgreSQL locally is a nightmare
  • Hosted solutions like Amazon RDS are hard to use
  • Did I mention how difficult it is to run Postgres locally?

Likelihood to Recommend

I wouldn't use Postgres for a production application, but I would recommend it if you're looking for a decent data store that anyone with SQL skills can use via BI tools.