This is used by the IT department only, …
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of PostgreSQL, and make your voice heard!
- Tech Details
SQL function supports, far outweighs compared to MySQL and MariaDB. PG Extensions allow for flexibiltity and scalability. Allows other vendors to create extensions like Citus, PostGIS, TImescale to expand pg into norms not though possible. As a document store, depending on how storing the data, can work better than mongo. However, depending on use case, is where PG might be better than mongo.
built in ETL tools sadly PG doesn't work compared to SQL Server and Oracle. however, w/ extensions flexibility is there.
For example for the most important and largest database, we use SQL Server since we trust SQL Server and we might need dedicated support if things go wrong. Or if we are using third-party software that's only compatible with MySQL we are using MySQL, other than that we always use PostgreSQL by default.
We are Linux based solutions and for many of our customers one server instance (physical or virtual) is enough to handle their alerts management needs selecting MS-SQL will require additional Microsoft based server in the solution.
MySQL was the 2nd choice we had as an Open Source database solution, I believe PostgreSQL provide better performance for the type of processing that we need.
The data consistency guarantees.
The multiple transaction isolation levels support.
The performance tuning options available.
The query performance analysis capabilities.
The long history of continual improvements made to the database.
The very strong and supportive opensource community around PostgreSQL.
- MS SQL Server Express
Elasticsearch: we use Elasticsearch to store free-form customer data, but that's a different use-case. Sometimes you'll want to use both, like us.