PostgreSQL Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Real User
Senior Database Engineer at a Consumer Goods with 1,001-5,000 employees
Oct 26 2016

What is most valuable?

The reliability, performance, and extensive list of features are what I think matter the most in a production environment.

How has it helped my organization?

I have never been in an environment where PostgreSQL was not used. It was always used alongside other RDBMS solutions, depending on the specific requirements of each project. In this way, we were always sure that we would get the best out of it.

What needs improvement?

There are still things missing compared to other RDBMS, for example monitoring is a little behind as there not that many solutions out there. An equivalent of Oracle's RAC and/or flashback logs would be nice to have. There are a lot of steps... more»
Real User
Analista Funcional Líder at a government with 5,001-10,000 employees
Jul 13 2017

What is most valuable?

PostgreSQL is an open source database, so there is no associated licensing cost for the software and we always have a new version easily available. It runs on all major operating systems, although I have always used it on UNIX platforms. It... more»

How has it helped my organization?

I have worked at the Ministry of Economy in the IT area, for more than 20 years ago. Since then, the main developments have always used PostgreSQL for their robustness, reliability, stability, and conformity with the standard SQL.

What needs improvement?

I have noticed that it consumes a lot of resources. I would improve this aspect.
Find out what your peers are saying about MySQL vs PostgreSQL and others in Open Source Databases.
291,145 professionals have used our research since 2012.
Real User
Consultant at a tech consulting company
Oct 25 2016

What is most valuable?

Strong enforcement of data types, because it can catch many errors and mistakes and protects data. Standard conformance, because in the end you are not locked to single vendor.

How has it helped my organization?

We used MySQL for many tasks, because there were simply more documentation available, but while using it, we found many serious weaknesses with it like no data validation even for string length, no transactions, etc. PostgreSQL catches a lot... more»

What needs improvement?

It needs more parallelism for big tables. This is already in PostgreSQL 9.6 beta so things are looking promising.
Real User
Developer at a comms service provider with 51-200 employees
Mar 22 2017

What is most valuable?

* Free and open-source RDBMS, with a permissive license * ACID compliance * Multi-version concurrency control * Custom data types * Array data types * PL/Python stored procedures

How has it helped my organization?

Back in the day, MySQL had storage problems with InnoDB (everything in a single file), and we wanted ACID compliance. So we decided to use PostgreSQL for that, and it helped us achieve that goal. PostgreSQL's feature set was excellent for our... more»

What needs improvement?

There's always room for improvement. Better SELECT performance is something that PostgreSQL could really benefit from. Replication should also be made easier. PostgreSQL also lacks a good tool like MySQL Workbench. PgAdmin3 works, but it's... more»
Real User
Founder and CEO at Shreeyansh Technologies | The Database Company
Mar 22 2017

What is most valuable?

* Integration with various programming languages * Partial indexes * Online backups/recovery * Replication * Hot standby * Cascading replication * Partitioning * Performance

How has it helped my organization?

This is an open-source product with advanced features that support OLTP/OLAP applications with the following benefits that helps organizations grow: * No recurring licensing cost * Huge cost savings forever * No vendor lock in * One-time... more»

What needs improvement?

The product has room for improvement with horizontal scalability and multi-master replication options, where community work is already in progress. These features will greatly benefit customers by balancing the load between servers, resulting... more»
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.
Real User
BI Expert at a consultancy with 501-1,000 employees
Oct 13 2016

What do you think of PostgreSQL?

Valuable Features GIS function. Geography is a very important function/dimension for our f. Postgres helps analyse that easily. • Improvements to My Organization It provides access to data for analytics. It has a lot of free tools available for data access, and has easy integration with a lot of visualization tools such as QlikView and Tableau. • Room for Improvement They need to develop an easy way to do a cross-DB query and some basic report visuals and alert systems would make it awesome, if they are possible. • Use of Solution >2 years • Deployment Issues We had no deployment issues. • Stability Issues The product is quite stable. • Scalability Issues There's been no issues with scaling it for our needs. • Customer Service and Technical...
Real User
Expert Web Developer at a tech vendor with 501-1,000 employees
Jul 21 2017

What do you think of PostgreSQL?

Valuable Features It works great out-of-the-box and it opens up many opportunities in project development. I first install the regular version. I only configure complex things when they are needed. • Room for Improvement I think that the product fully meets the needs of modern development. If there is something missing in it, then it is probably a too narrow profile function. • Use of Solution I've used this solution for two years. • Stability Issues There were no issues with stability. • Scalability Issues There were no issues with scalability. • Customer Service and Technical Support I would rate the technical documentation as an eight out of 10. I never spoke with the support team. • Previous Solutions I used MySQL. I switched because at that time,...
See 2 More PostgreSQL Reviews

Articles

User Assessments By Topic About PostgreSQL

Find out what your peers are saying about MySQL vs PostgreSQL and others in Open Source Databases.
291,145 professionals have used our research since 2012.

PostgreSQL Questions

PostgreSQL Projects By Members

PostgreSQL Consultants

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.


Sign Up with Email