PostgreSQL Archived Reviews (More than two years old)

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

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

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

I am working with other databases, and not exclusively with PostgreSQL. A lot of other RDBMS require you to pay large amounts of money so I would say that you need to carefully plan your projects… more»

What other advice do I have?

There are some features missing compared to other RDBMS. The community is always expanding and more and more people use PostgreSQL every day. There are many forums where you can get information from… more»

Which other solutions did I evaluate?

I have tried and worked on other solutions such as Oracle and MySQL. I would say that the combination of PostgreSQL's features, plus the reliability and performance it offers in combination with the… more»
Tomaž Borštnar
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… more»

What needs improvement?

It needs more parallelism for big tables. This is already in PostgreSQL 9.6 beta so things are looking promising.

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

We previously used MySQL. PostgreSQL tries to solve things in the correct way for all platforms, all file systems, and all users. In the end, this means you get a better working and more stable system. They try to stay away from hacks and… more»

What other advice do I have?

Explore this new world. PostgreSQL has taken a quantum leap over the last 20 years, and now it seriously threatens more established database vendors.
Find out what your peers are saying about PostgreSQL, Firebird, MariaDB and others in Open Source Databases. Updated: October 2019.
372,124 professionals have used our research since 2012.
Real User
BI Expert at a consultancy with 501-1,000 employees
Oct 13 2016

What is most valuable?

GIS function. Geography is a very important function/dimension for our f. Postgres helps analyse that easily.

How has it helped 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.

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

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

It's free as it's open source.

What other advice do I have?

Go ahead with the product which has the best use case for your organization. Cost is never an issue.

Which other solutions did I evaluate?

For me all SQL tools/products are similar, except for a few important differences like GIS functions in PostgreSQL, and programming abilities in Oracle PL/SQL, etc.
Real User
Front-End Developer at a financial services firm with 501-1,000 employees
Sep 24 2016

What is most valuable?

PostgreSQL provides a lot of valuable documentation and there's widespread usage of it.

How has it helped my organization?

I use it for personal projects. It's been really easy to learn and it's been useful since ramping up it use.

What needs improvement?

Although there's documentation out there, it needs even better documentation. Another thing that would be helpful are examples of usage of it with JavaScript.

What other advice do I have?

Compare and contrast various database optimizations based on your needs. And when you come across issues, don't reinvent the wheel -- someone has probably had a similar problem to your own.
Real User
Director of Operations / Senior Software Engineer at a software R&D company with 51-200 employees
Sep 06 2016

What is most valuable?

PostgreSQL does a great job with scalability and performance. Since we are using Django/Python – it works great with PostgreSQL as well. The current features that really help us are Full-Text Search… more»

How has it helped my organization?

By using PostgreSQL, it was easy to get all the developers configured and running. With using it as our back-end for data storage, our company isn’t worried about data loss or data integrity… more»

What needs improvement?

The only thing I would really want/need to improve is pgAdmin3. pgAdmin3 is a nice tool for SQL Admin and Queries. But, I wish it would allow multiple queries to be run and displayed in the output… more»

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

Pricing/licensing is the reason we went with PostgreSQL. As a startup, every dollar counts and PostgreSQL has enabled to us to have an enterprise solution at a fraction of the cost of Oracle and… more»

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

We had used Microsoft SQL Server in our previous company. But, the licensing terms kept getting more and more onerous. We started looking at PostgreSQL from the reviews and recommendations, especially… more»

What other advice do I have?

PostgreSQL is an amazing product. Very easy to implement and there are many libraries to make it easy to use PostgreSQL as a back-end database solution, no matter what coding language you are using.

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.

BUYER'S GUIDE
Download our free Open Source Databases Report and find out what your peers are saying about PostgreSQL, Firebird, MariaDB, and more!
Sign Up with Email