PostgreSQL Information Reviews & Insights

Score8.4 out of 10

336 Reviews and Ratings

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

18 Reviews

Information

Best Relational and Open Source Database

Rating: 9 out of 10

Incentivized

November 7, 2022

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.

vijay bhopalwani

Software Engineer L3 in Engineering at ReliableSoft Technologies Pvt. Ltd. - India (Computer Software, 51-200 employees)

Vetted Review

2 years of experience

View profile

postgreSQL, a great choice from startup to enterprise

Rating: 8 out of 10

Incentivized

July 7, 2022

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.

Verified User

Engineer in Information Technology (Computer Software company, 1-10 employees)

Vetted Review

3 years of experience

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

Rating: 8 out of 10

Incentivized

December 31, 2021

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.

Aurpa Fiza

Software Application Developer in Customer Service at Mapple Ltd. (Computer Software, 11-50 employees)

Vetted Review

2 years of experience

View profile

Best open source relational database you can have

Rating: 10 out of 10

Incentivized

May 24, 2021

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.

Verified User

Employee in Information Technology (Computer Software company, 1-10 employees)

Vetted Review

7 years of experience

PostgreSQL as Solution base database solution

Rating: 9 out of 10

Incentivized

April 20, 2021

Use Cases and Deployment Scope

We use PostgreSQL as our solutions database, we looked for a full featured database server that will be both reliable, with high performance and supported on our Linux CentOS based platforms. We preferred Open Source solutions as we did not want to increase our solution price.
Highnet Systems' SNS++ Notification Management solution is sold on license on premise solution, as such the customer need platform (Hardware or virtual server), Operating System, Database Server, WEB Server and finality our software. by selecting Open Source platforms we are able to provide our customer with great enterprise level solution at very small cost.
PostgreSQL give us great performance supporting organizations with millions of alerts per day, with complex alert handling solutions. We started using PostgreSQL more than 15 years ago and it is still great solution, with wide industry support, easy management and development tools and because we provide our solutions to big organizations it helps to relay on platform like PostgreSQL that is constantly developed to face both new demands, environments and security risks.

Pros

Well designed database solutions.
Good support for development environments.
Constantly developed.
Wide availability in the industry.

Cons

Management platform not as good as I expected.
Does not have schema versioning.

Likelihood to Recommend

Being an Open Source solution PostgreSQL is great choice for solutions that needs database and do not want to relay on customer database solutions.
PostgreSQL can easily integrated with many platforms we access the database from both our solution engines and the UI.
It is well known and appreciated so relaying on it as our system database can be easily accepted by our customers.
PostgreSQL continues development and support allows us to provide secure and reliable solution acceptable by customer security teams and advisors.

Arik Ben-Dov

Founder & CEO in Research & Development at Highnet Systems (Computer Software, 1-10 employees)

Vetted Review

15 years of experience

NoSQL workloads shine on PostgreSQL

Rating: 10 out of 10

Incentivized

April 8, 2021

Use Cases and Deployment Scope

PostgreSQL is used across a wide number of systems. Ranging from customer-facing primary data storage of traditional relational data to using it more like a NoSQL data store with the JSON & JSONB data types. Analytical workloads in some parts of the business are serviced by PostgreSQL as well.

Pros

Permissive licensing
JSONB data types allow for migration from NoSQL data stores that haven't scaled as well as would have like when providing consistency guarantees.
Various index types to support full text search.
Extensions & customization of the database.
Geo-spatial support with routing support.

Cons

Default tuning isn't optimized for modern hardware
No native support for multi-master setups
Scaling out with partitions across multiple servers can create transaction issues in some scenarios

Likelihood to Recommend

PostgreSQL is generally well suited to basically any database workload one can think of.

JSONB data types are great for dealing with various use cases that come up to avoid an EAV pattern.
Custom data types can be supported.
Various extensions can really add a lot of excellent features.
Logical replication in later versions supports per table replication.

Paul De Audney

Senior Staff Engineer in Engineering at SafetyCulture Pty Ltd (Computer Software, 201-500 employees)

Vetted Review

18 years of experience

View profile

Postgres review

Rating: 10 out of 10

Incentivized

April 1, 2021

Use Cases and Deployment Scope

I have used Postgres across 3-4 different companies as the main application database for half a dozen web applications.

Pros

General database functionality
Json and hash storage types
Reliability

Cons

Continue advancement with json/hash storage and key-value store solutions

Likelihood to Recommend

Great solution for a relational database. It also continues to support and add functionality for json/hash/key-value storage.

Josh Kramer

Senior Software Engineer in Research & Development at Octiv (Computer Software, 51-200 employees)

Vetted Review

4 years of experience

View profile

PostgreSQL is fast, cheap and easy (and fully featured!)

Rating: 10 out of 10

Incentivized

January 16, 2020

Use Cases and Deployment Scope

It is our primary database engine utilized in the capture, storage, and processing of all company data. We were facing massive licensing fees and large deployment times in order to deploy Microsoft SQL Server at scale. We opted instead to deploy PostgreSQL in replicated pairs (50+ and growing) in a matter of minutes! We were delighted with the ease of use and replication abilities, not to mention the amazing performance.

Pros

Transaction Speed
Customized Tuning

Cons

Active/Active High Availability
PGTune could be more extensive

Likelihood to Recommend

It is excellent when full transactional SQL is required and reducing costs is a factor. It is also excellent where replication is required.

Verified User

Engineer in Engineering (Telecommunications company, 501-1000 employees)

Vetted Review

7 years of experience

PostgreSQL - Data Warehousing Technology

Rating: 8 out of 10

Incentivized

August 2, 2019

Use Cases and Deployment Scope

PostgreSQL is being used as the main data warehousing system by our organization for various analytics functions. It is being used across our whole organization both internally and externally to generate reports and other dashboards products. The business problems it addresses is the need to run complex analytics queries without having too much time be burned up by running the query on MySQL.

Pros

Data warehousing
Analytics
Slony replication

Cons

Query language consistency
In-memory caching is needed
Better query optimization

Likelihood to Recommend

PostgreSQL is the best solution out there for data warehousing for relational data if that is what you need in your various analytics and dashboarding projects. It doesn't work that well as a transactional database, for that you'd probably want to stick with MySQL. The other flavors of PostgreSQL that are optimized may work better again, depending on your specific data types and workflows.

Verified User

Consultant in Information Technology (Internet company, 51-200 employees)

Vetted Review

2 years of experience

PostgreSQL is making a comeback!

Rating: 10 out of 10

Incentivized

January 18, 2019

Use Cases and Deployment Scope

After using Microsoft's SQL Server for many years for our application's back end data storage, we made the switch to PostgreSQL for all new application development. For our use case, PostgreSQL has the same feature set SQL Server has and comparable performance. We needed a way to have multiple server clusters for redundancy and licensing costs of SQL Server were starting to get prohibitive. PostgreSQL gives us a stable and more cost-effective solution for data storage.

Pros

Redundancy and clustering can be handled in multiple different ways, offering complete control over specific use cases.
GIS extension for spatial data.
Full SQL compliance.
A little lighter on resources than SQL Server.

Cons

The documentation can be sometimes lacking, however, there are lots of online resources for troubleshooting.
The tooling could be better. If you're used to SQL Server Management Studio and all the 3rd party add-ons, moving to PostgreSQL can be hard to get used to at first.
If you are on a version older than 11, you cannot use Transactions in Stored Procedures. While this isn't an issue moving forward, not all cloud providers support version 11 yet.

Likelihood to Recommend

PostgreSQL is great for all types of data storage needs. Even if you have a use case for minor document storage, it can handle it. As with most things, you use the right tool for the job, anywhere you would use MySQL or SQL Server, you can just swap in PostgreSQL. However, if you are needing a NoSQL or schema-less storage model, look elsewhere.

Aaron Smith

Senior Software Developer in Information Technology at TimeTrak Systems, Inc. (Computer Software, 11-50 employees)

Vetted Review

1 year of experience

View profile

Loading Reviews List....

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

Rating: 8 out of 10

Incentivized

December 31, 2021

Use Cases and Deployment Scope

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

Aurpa Fiza

Software Application Developer in Customer Service at Mapple Ltd. (Computer Software, 11-50 employees)

Vetted Review

2 years of experience

View profile