PostgreSQL Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
Tomas Dalebjörk
Real User
Information Technology Technician at a tech vendor with 51-200 employees
Feb 14 2018

What is most valuable?

* Robust backup and recovery integration. * Follows ANSI SQL. * opensource * easy to integrate with applications and high level programming languages such as; python, ruby, java, C, perl, php...

How has it helped my organization?

We are considering migrating to this platform due to its robust backup and recovery solution, among many other features.

What needs improvement?

* Possibility to use query routers on sharded clusters. * Remove the limitations of how many changes one can have on the databases before it requires to reset all blocks, which are very painful.

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

Use backup software that integrates with the solution. We selected "DB Protection for PostgreSQL", which has some nice features to perform block level incremental forever using IBM Spectrum Protect.

If you previously used a different solution, which one did you use and why did you switch?

We switch to this solution due to its stability and that it is open source.

Which other solutions did I evaluate?

Yes, we reviewed MongoDB, MariaDB, and MySQL.

Articles

User Assessments By Topic About PostgreSQL

PostgreSQL Questions

What is PostgreSQL?

PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.

Some technical details of interest about PostgreSQL include:

  • Its MVCC (Multi-inversion concurrency control) allows fluid changes to be made to the system without cumbersome roadblocks, while maintaining the optimal level of ACID.
  • Replication, built-in binary replication is available from the 9.0 version and later.
  • It offers a wide range of indexing capabilities, including B-tree and hash indexes, as well as GIN and GiST (generalized inverted indexes and generalized search trees).
  • It uses procedural languages that make it easier for developers to expand the database.
PostgreSQL customers

Hundreds of companies have used PostgreSQL, including the University of Alabama, Birmingham, Berkman Center for Internet & Society at Harvard University, Champion Products, the United Nations Industrial Development Organization, the U.S. Agency for Disease Control and Prevention, and IMDB.com.

Read Archived Reviews
Sign Up with Email