PostgreSQL Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Liliana Rodríguez
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... 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... more»

What needs improvement?

I have noticed that it consumes a lot of resources. I would improve this aspect.

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

I recommend everyone to get into the PostgreSQL world, with no licensing costs. PostgreSQL uses a flexible and business-friendly license because... more»

Which solutions did we use previously?

I have used other solutions for over 20 years and the problem of licensing has been our biggest drawback because of the costs and dependence we... more»
Danilo Martins
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... more»

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... more»

What needs improvement?

There's always room for improvement. Better SELECT performance is something that PostgreSQL could really benefit from. Replication should also... more»

Which solutions did we use previously?

Up to that point, we used MySQL. The decision to change came with a new version being written from scratch, and PostgreSQL being better suited... more»

What other advice do I have?

PostgreSQL has extensive and comprehensive documentation. Chances are that you'll find your answers there for 99% of the cases. For those... more»
Find out what your peers are saying about MySQL vs. PostgreSQL and others in Open Source Databases.
300,473 professionals have used our research since 2012.
it_user494835
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 *... 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... more»

What other advice do I have?

I strongly recommend this product, with no recurring licensing liabilities with community support and with optional commercial support available. Shreeyansh Technologies provides... more»
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... more»

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... more»

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... more»

Which solutions did we use previously?

We switch to this solution due to its stability and that it is open source.
it_user439254
Real User
Expert Web Developer at a tech vendor with 501-1,000 employees
Jul 21 2017

What is most valuable?

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... more»

What needs 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... more»

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

As far as I know, there are no problems with the license for free use.

Which solutions did we use previously?

I used MySQL. I switched because at that time, because some things were complicated with MySQL. For example: scaling, sparse data JSON, and... more»

What other advice do I have?

I think this is the only decent solution for a relational database in web development.
it_user514974
Real User
CTO at a tech vendor with 51-200 employees
Jul 30 2017

What is most valuable?

The new JSON data type that allows to use some NoSQL-like functionality. This is great because brings some of the most valuable features of... more»

How has it helped my organization?

We use it as main database for our SaaS product.

What needs improvement?

Scalability; Although PostgreSQL is known for handling very well large amounts of workload, NoSQL databases performs better when scaling. NoSQL... more»

Which solutions did we use previously?

We had several performance issues with MySQL.

What other advice do I have?

Explore all the features.

Articles

User Assessments By Topic About PostgreSQL

Find out what your peers are saying about MySQL vs. PostgreSQL and others in Open Source Databases.
300,473 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