PostgreSQL Reviews

This solution is very good and efficient in joining big tables. It also provides a lot of options that, from a developer's point of view, can be utilized in a project. 

In the next release, I would like to see better integration with other platforms.

I've been using this solution for about three and a half years.

This solution is stable - I'm not aware of any performance issues.

This is a scalable solution.

The initial setup is simple - you are only required to download the installation files, which takes just a few minutes.

I would rate this solution as seven out of ten.

Private Cloud

Amazon Web Services (AWS)

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 NoSQL databases to relational databases. You can have a column with JSON datatype and then query that JSON inside your regular SQL queries. 

So basically, you are mixing together the relational and NoSQL world in just one database, one powerful solution. 

We use it as main database for our SaaS product.

Scalability;

Although PostgreSQL is known for handling very well large amounts of workload, NoSQL databases performs better when scaling. NoSQL databases were built with scalability in mind, so it´s a natural advantage. 

PostgreSQL must keep improving their scalability and ability to work in HA (high availability).

I've used this solution for four years. 

No. 

See answer to 'Room for Improvement' question. 

We had several performance issues with MySQL.

Yes, MySQL.

Explore all the features.

• Confidentiality
• Integrity
• Availability
• Bug free

I like to work with a piece of software that is bug free and doesn't required to be launched in order that users will find a couple of bugs in the coming weeks and that the company has to fix it.

It helped me to find an easy and inexpensive solution for databases

It would be interesting to have a cloud based database instead of having to install it on any single machine.

I've used it for approximately one to two years.

I've had no issues deploying it.

The stability was an issue, because when coding under Eclipse with Java, some errors occurred while trying to connect to the database, so troubleshooting may be difficult, since you don't know if it's a Java coding issue or a PostgreSQL translation issue.

There have been no issues scaling it.

I never used any customer service or technical support during that time. I used to find alternatives to my issues.

Since Oracle was expensive for a company business an inexpensive way was to focus on PostgreSQL.

The initial setup was straightforward, just activating various modules was more complex.

We did it in-house.

I saved money instead of using the Oracle solution, which might be more secure than PostgreSQL in various ways.

You need to find a lot of time in order to find all functionality and get used to the PostgreSQL syntax Be patient, look for various forums and do learning by doing.

The reason why I started with PostgreSQL database was the (geo)spatial support. GIS software, such as Quantum GIS (QGIS) or PostGIS, is a good example of where you are able to use this feature. Nowadays, the solution is on a competitive level to other commercial software solutions, especially for small companies.

PostgreSQL (geo)spatial support is stable, and you can add, remove, and edit all standardized GIS features. Thanks to projects such as EDB, Bitnami etc., PostgreSQL can be used by people on pure user level, without deep knowledge of OS administration, programming.

There is room to improve some user friendly properties such as input and output tools, some people may find interesting to implement MERGE as a SQL command. I am looking forward to trying UPSERT and would like to test some analytic functions definitely.

I've been using v9.4 for a half year. I also have experience with previous versions of PostgreSQL. Currently we have PostgreSQL 9.4.7 on Fedora Server 23 and PostgreSQL 9.4.5 packaged by EnterpriseDB (EDB) on Windows 10 Pro.

I had trouble with the reinstallation of EDB. If I have a previous version on my Windows PC, I have to take some steps to clean the registries and folders, then everything is OK.

Customer Service:

If you are interested in you can find answers for troubleshooting. Many companies, I have mentioned above, are there for service and support. I didn’t find any big bug in the latest stable release over the last few months.

Technical Support:

If you are interested in you can find answers for troubleshooting. Many companies, I have mentioned above, are there for service and support. I didn’t find any big bug in the latest stable release over the last few months.

I recommend Linux installation, but it is also possible to use Windows. With PostgreSQL you don't have to pay much money which is a good advantage. You have to take into account that you will spent some time finding out how to implement something or what is the right tool you have to use.

PostgreSQL is a long-lasting investment for people who like computers and don’t want to spent much money for database layer implementation.

Backend: 64-bit large objects, Cascading streaming replication, Serializable Snapshot Isolation; Performance:GIN Index performance and size improvements; Security: SSPI authentication via GSSAPI; list goes on...

Automation, accurateness and concistency of enterprize processes

Comercial & Supply Chain

9 years

No

No

No

Customer Service: 9Technical Support: 9

MySQL: scalability; Oracle: cost-benefit

Easy and straightforward

in-house

36%

Oracle and MSSQLServer

I suggest to anyone give it a shot. It'll make your business grow.

The solution has many valuable features such as it easy to use and the interface is intuitive.

Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install.

In a future release, the installation agent should take less time to create all the databases, especially the small Oracle databases that I was using.

I have been using the solution for a couple of months.

I have found the solution to be stable.

I have not fully tested the scalability but it has been good enough for what I have been using it for.

I did not experience any technical issues to call the support about.

The installation was easy even though it took approximately four hours. The time accumulated from downloading automatic packages from the VM tunnel. You have to download the whole package on your machine.

The solution requires a license.

I recommend this solution for small organizations.

I rate PostgreSQL a seven out of ten.

On-premises

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

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

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.

I've used it for six months.

There were no issues with the deployment.

We have had no issues with the stability.

We had no issues scaling it for our needs.

I haven't had to contact technical support. There's been no reason to do so.

It was straightforward and well integrated into Rails applications across open source world.

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.

It allows people to use whatever multiple procedural language they are trained in, such as Java, Python, Pearl, or C and it is not limited to PL/SQL or PGSQL. Also, I love the PostGIS extension and I do not know of any other product like this.

I can integrate solutions quicker than with other RDBMS'. At the same time, I am able to keep an RDBMS' integrity, robustness, and High Availability which is the most important thing for all my production environments.

It is lacking some GUI admin tools and it would be nice if more could be developed by the community.

I've been using it for years.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.

It's the best in my opinion because have now found what I need to enable me to quickly deploy into my production environment. Go to a professional and ask for your needs, maybe you will surprise with a variety of solutions that you never thought existed.