PostgreSQL Reviews

The solution is primarily used to develop the databases for your application. I used it personally for a college assignment.

The solution is open-source and therefore free to use.

You can do the same actions as you can with the SQL Server.

It's a standard reliable database management system.

The solution comes with an option to work in dark mode, which I appreciate.

The interface could be much better. Maybe it took a little bit longer to understand the menu options and so on. On top of that, it's a web interface. It makes it uninteresting to look at. It's not so appealing as the options that Microsoft offers. It's a separate program that works separately and you don't mess with the browser. It works okay, you can do what you need to do, however, it's not, in my opinion, so professional-looking. That said, it's open-source so I can understand that they prefer to do it like that.

The installation process could be better organized.

The stability could be better. they release new versions all the time and they aren't quite as stable as we'd like them to be.

We've only used the solution for a few months. We used it for two projects. It was basically used across two semesters. We have used it in the past year.

The solution is not as stable in comparison to Microsoft SQL Server. I had some issues with a version, and I had to re-install it last year. Now, however, it's working fine. That said, they are always launching new updates and they seem to release them too early as they are not so stable.

I'm not sure if I will continue to use the solution. I used it for an assignment, and that's it. 

I did not contact technical support. I've never reached out to them directly. Therefore, I can't speak to how helpful or responsive they are.

I've also worked with Microsoft SQL, and I find the product to be much more stable.

The initial setup could be a bit better. They have some improvements to do especially with regards to the additional tools they propose. That part is just a little bit messy. Other than that, I thought it was very easy to install it. It's not overly complex.

I was able to handle the implementation myself. I did not need the help of a consultant or integrator. 

The solution doesn't cost anything to use. It's open-source.

I'd rate the solution at an eight out of ten. I'm mostly happy with its capabilities.

I wouldn't necessarily recommend this product for beginners. 

There are many valuable features, but the most valuable to me are Windows functions, Python scripting, and the fact it has a good PGSQL language.

It provides standardization on the database and related skills.

Parallelization and some connection to analytics is needed.

We had no deployment issues.

The product is quite stable.

It has the ability to scale up into products like Redshift.

The online manual is superb.

It's very easy, and you only need to familiarize yourself with its file structure. Sometimes you need to write your own plugin, so sometimes it is better to have it implemented by a vendor.

It's free as it's open source.

It is a superb database. What keeps it from being 10/10 is a lack of analytics specific optimizations.

• Stability
• Standard SQL for ease of development with pre-existing knowledge

Postgres is for our systems a very solid database, easy to use in development and easy also to manage in production environment, and that's valuable because in the end it cuts a lot of costs (also during the upgrading processes).

The Postgres team is already doing an amazing job in putting in features to ease the life of developers and sys admins, such as JSON support and database replication.

A feature that is still a work in progress and it would be nice to have would be native master-master replication, we don't have a need for it right now but it's something that should be addressed in the future.

I've used it for five years.

There have been no issues with the deployment.

We have had no stability issues.

It has been able to scale it for our needs.

I've had no need to use any.

I've had no need to use any.

I used MySQL and Oracle previously, PostgreSQL is open source and fully ACID and SQL standard

It was easy.

We deployed it in-house.

It's a great database engine that is easy to use, powerful, and scalable.

It is an open source solution and that is a database engine very powerful. Besides it is highly configurable. I prefer PostgreSQL over MySQL or MariaDB because you can create several databases with many schemas and create roles like owners, and not only grants over tables, or procedures. On the other hand its very easy and intuitive to administrate the connections by hosts, databases, and roles.

PostgreSQL is a powerful dateserver although not like Oracle. So we can make many developments in a cheaper way with high availability. Besides, its very useful tool for debugging with a soft learning curve.

It needs to be able to cluster. We have implemented the high availability with a master-slave mode and one host in only read mode. This is the worst feature of this product and the quality sign of Oracle.

I have been using PostgreSQL server for three years.

The upgrade from v8.4 to v9.3 was a little hard, but this was executed finally well.

We had no issues with the stability.

We've had no issues with scaling it for our needs.

I've not had to contact them.

I use MySQL, MariaDB, and Oracle. I chose PostgreSQL or others depending of the project. For Java implementations I prefer PostgreSQL, and for PHP development, I prefer MySQL or MariaDB,

In my opinion the initial setup is easier than MySQL because it is more intuitive, but you must to edit a couple of config files, and become more aware of the entire infrastructure.

It's open source code, so you get it for free and need to contribute to debugging errors and improving the code.

Be patient! Like most open source tools, this requires commitment and a little knowledge.

* pg_hba.conf

* A fragment from postgresql.conf

* How to access to database-server using psql client, and create a database

Create a user/role and be owner for a database. We can list all databases with "\l".

By far indexes is the most useful and robust feature. Also, the query optimization engine is simply great. It is very complete, clear and useful documentation, forums and diverse information channels.

Most of the enterprise I have worked has been startups and small to medium software industry and data analysis. One of the most improvement it is not in the mean time but in the middle to long time. At first sight it seems to an overkill implement a product as PostgreSql for small projects; even managers and investors tend to put some resistance to it. Then, as soon as projects start scaling and data set increase in size, concurrency, consistency and data types, is were you think PostgreSQL was one of your "hit" on the project design, time give you lot of credits.

I think that data types that decrease the breach against NoSql Databases will be the next steps. I am not talking about changing to a pure NoSql DB but to some features that will face the big change in data analysis and maintenance that that DB are facing nowadays. Also tools for distributed replication and clusters should be more researched and improved; anyway nowadays there is some of them.

I have been using PostgreSql since University where I teached students some DB theory concepts. The course was focused on indexing and benchmarking. Also I use it on software industry, as a DB manager, designer and operator; common tools were PL/pgSQl, indexing and tuning; using about 3.0M per month DB tuples inserted and about 500tps on peak points. Finally I use it on personal projects, for small data sets (~1.000).

We have had no issues with the deployment.

I have faced just a few issues working with PostgreSql, one of them was specifically on Hash Index (see as example http://www.postgresql.org/docs/9.2/static/sql-createindex.html.

We have had no issues scaling it for our needs.

Most of the great value of PostgreSQL is the variety of technical support you can find Consulting, lots of forums, and big communities who have been using and documenting PostgreSQL for a long time. I have never faced a problem or question that couldn't be solved using these channels.

I have worked with MySQL and Oracle solutions. Against MySQL, performance is the big difference. PostgreSQL is far more robust and mature than MySQL, especially when you think about keys and indexes. Against other databases, such as Oracle, the easy installation steps of PostgreSQL is the best difference for me.

I have faced a few issues while installing it and configuring it; most of them related to incompatibility while using old Ubuntu Linux versions.

I have always implemented it in-house, and as all solutions for everything on vast areas, is highly recommended read guides on how to install it.

ROI is by far fair enough for startups and enterprise projects that are expecting a big grow in the mean time.

PostgreSQL license is a fair enough for small to medium size business solutions.

Just read the comparisons between different database engines, and read some documentation so you can exploit most of the powerful tools and functions it has.

The most valuable features are a good feature set, understandable, and good tuning features. It is, also in our experience, the best open source GIS enabled database, with good support from other open-source tools.

The product has easy installation procedures for the OSes we are working with and gives also a good possibility to tune the database for the given usage.

The database is used to set-up customers projects and is our standard database which we use.

One of the features it needs is a tighter integration with business intelligence software, so that the optimisation of the requests can be handled natively in the database. These features are on the roadmap, and are already partially released in the latest version.

We have been using this database for about 18 years.

We have had no issues with the implementation. Most of the issues we have encountered in external installation where due to misconfiguration.

There have been no issues with the stability. Most of the issues we have encountered in external installation where due to misconfiguration.

We had no issues scaling it for our needs. Most of the issues we have encountered in external installation where due to misconfiguration.

We have up until now not needed additional customer or technical support, these can be purchased by supporting companies.

We have been using Oracle software, and in some cases MS SQL server. The price difference between the used products and PostgreSQL was one of the issues. The second was the ease of installation and the availability on different platforms.

The initial setup is easy to perform, but the tuning is a bit more complex. The installation support on Linux flavours is excellent and has native installation packages.

Implementation and installation was carried out in house.

The pricing of the database is open-source and our investment in the product is based on training.

This is an open-source solution, operates at a high speed, and supports more than one SQL language.

It integrates with different platforms, the upgrades are quite fast and the solution keeps getting better. 

This solution could be better integrated with other systems. 

I have used this solution for four years. 

This is a stable solution. 

This is a scalable solution.

We have not needed much help from the customer service team. When we have had questions, we have found the answers on Google. 

We previously used Microsoft SQL.

The initial setup is straightforward and took less than one day. 

This is an open-source solution and there is no need to pay for a license.

We recommend PostgreSQL for our customers who want an open-source solution.

I would rate this solution an eight out of ten. 

We use it to convert the databases. We also use it to make a request from my PMS with the Oracle-based server through the third-party interface.

We use this solution for the interface between our property management system and the cloud-based system. It works from both sides.

It is very simple to manage.

It is easy to use.

My main concern is that I can use it to connect with the interface. It is simple, it's good.

It needs more integration.

I have been using this solution for two years.

I have not explored the scalability of this solution yet.

I will continue to use this solution but I don't have any plans to increase our usage.

I have not contacted technical support.

The initial setup is straightforward. It was easy to install.

It took only one day to install, and two to three days to connect with the database.

We have a team of three, two admins, and one engineer to maintain the solution.

We had help from a company from Norway, one from South Africa, and one other from Dubai.

We do not pay for licensing.

Depending on the type of work the user wants to do with the interface I would recommend this solution or not.

I would rate PostgreSQL a five out of ten.