PostgreSQL Reviews

The solution is quite a good database for light applications for sure. This is how we are using it - as a front-end application and the canned database of PostgreSQL. The use case is comparable to Oracle, with quite a wide range of usage.

It's easy to install in Oracle and it's quite good to use for the canned database for content applications.

The solution is quite a good database.

Their pricing is very good.

The solution is very easy to use.

It's quite scalable.

The stability is good.

The installation is simple. 

I don't work with the solution often enough to really know if there are any missing elements. For me, for how I use it, it works fine.

We're only really using two to five percent of the functionality available.

While there's no perfect solution, we aren't using too much of the functionality to really be able to comment on what might be missing.

If it was free to use, it would be the perfect solution.

We're currently using the solution. We've used it at least over the past year.

The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.

The scalability is very good. If a company needs to expand it, it can do so with ease.

We have around 2,000 people using the solution currently. It might even be a bit more.

We also use Oracle Database. I would say the two are quite comparable.

The installation is not overly complex. You just install it and start using it. It's simple. We are using AWS for both instances so it's simple and easy. That said, I was not personally involved in the installation process.

How many people you require for the implementation depends on the implementation itself. It can be one person or it can be five. It's difficult to say. In our case, we have only one person looking after all instances.

It's not an expensive solution.

I can't recall the exact version number of the solution. We're planning to move to the latest version.

The solution is installed in the cloud, however, it's a software as a service, provided by AWS.

I'd rate the solution at an eight out of ten. It's very comparable to Oracle.

While it does depend on the use case, for the most part, I would recommend the solution to other companies and users.

We use the solution to conduct surveys and consider this approach to be one which is cheaper for us. 

The solution is quite stable. This said, it's more prestigious to use MySQL, although we haven't made comparisons for safety and reliability.

The performance is too low, although we haven't tested for this. 

The interface climate could be better. There are many third party ones that we can use so it would be nice to see more support with the database diagrams.

We've been using PostgreSQL for certain small projects for the past three years.

The solution is quite stable for our use. 

We haven't tested scalability.

I cannot say for sure if we have plans to increase usage, as we have yet to run a test. 

While we do benefit from technical support, this is not something that we have required. 

The initial setup wasn't difficult. I'd say it was quite straightforward.

The installation took less than an hour. 

The need for our customers to pay for licences is contingent on their projects and budgets. It varies. 

We are not consultants to PotrgresSQL. We are usually consulted when it comes to using Microsoft MySQL Server, since we consider it to be quite robust and to have all the necessary support from Microsoft.

Fewer than 10 percent of our customers make use of PostgresSQL.

I would recommend the solution to others when when there is a desire to have projects and cost is a concern.

I would rate PostgresSQL as an eight out of ten, although this owes itself to personal preference and not to low performance. 

Typically, our team runs the database and then the applications, on Postgres. However, I'm not part of the development process.

The solution is quite stable and very reliable.

On the cloud side of the product, the solution scales quite well.

The initial setup is quick and easy.

I don't work directly on development, however, I haven't heard of any complaints from the development team in general. I can't speak to any features that may be missing. Our team seems quite satisfied with it overall.

It would be great if the solution offered even more integration capabilities.

We've been using the solution for the past two or three years at this point.

The stability, overall, has been good. I have not heard of issues with bugs or glitches. I cannot recall it crashing or freezing. Its performance has been reliable.

The product can scale well. However, this is mostly the case on the cloud, which more easily can scale as there are no physical limitations to hold a company back. If a company needs to scale using this solution, it can do so with relative ease, specifically if they use a cloud deployment.

We only have about ten to 15 or so users on the solution right now. On the products we produce there may be more, however, that varies. There could be a hundred or so users.

We have plans to continue to use the solution going forward.

We don't really use technical support too often. We have our own team that we can turn to, and they can handle most, if not all, issues.

We've used a few other products previously. We're also using MongoDB, or at least, we will be, in an application that we've just started.

The initial setup is not complex at all. I would describe it as straightforward and rather simple. 

The deployment is quick as well. It might have taken us about 45 minutes to an hour or so to get everything up and running. It's great.

We have a technical team or two or three people that can manage the deployment and maintenance. You don't need a big team.

We handled the implementation process ourselves. We didn't need the assistance of any consultants or integrators. It was pretty straightforward, and therefore we didn't need the extra help.

The product is a direct service, and it is free to use. There isn't a licensing fee.

We are simply a customer and end-user. We don't have a business relationship with PostgreSQL.

The solution is deployed both on the cloud and on-premises. We use more than one deployment model.

I can't recall the exact version number we are using, however, it's my understanding that it is not necessarily the latest version.

I'd recommend this product to other organizations. It's worked well for us so far.

In general, I would rate the solution at an eight out of ten.

I have used it in the past for some web applications and back-end databases. In my current organization, we are using Microsoft SQL Server.

It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin.

It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers.

It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful.

It can also have good reporting capabilities.

I have been using this solution for a couple of years.

PostgreSQL has been in the market for a long time. It is quite stable.

It is scalable. In my past organization, its usage had increased a lot. I had implemented data management and many other things on PostgreSQL.

In terms of the number of users, we had hundreds of users who used this solution. For development, we had seven or eight developers. We also had technical support and application teams.

I have not interacted with the support of Postgres because when it is on the cloud, it is managed by the respective cloud provider's team.

We used to provide service to various clients, and we were also providing internal services. We used different solutions in parallel, such as Amazon Redshift, MySQL. MySQL is also free. I have also used Oracle and IBM Db2 in other organizations.

Its installation is simple and easy. If it is in the cloud, you have to go for a subscription. On a desktop, you can install it with normal Unix commands.

I have not done full server version installation myself. If we go for Azure Cloud, its API is available. It takes five minutes to get it up and running on the cloud version. For desktop deployment, you can complete your setup within half an hour. 

It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft. 

I would definitely recommend this solution. It is a very good database to have. It is also very good as compared to other tools.

I would rate PostgreSQL a nine out of ten. 

I have implemented costing models. I use it to capture item costs and then do calculations to compare costs.

The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. 

Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good.

PostgreSQL doesn't have a feature for temporal SQL, which is useful for selecting version(s) of a row. 

Specifically the syntax 

SELECT 

FROM <table> FOR SYSTEM_TIME AS OF ...

This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2. 

I have been using this solution for six to seven years.

It is stable.

For my use case, it was good enough. I didn't use cluster or other such things. In my previous organization, we had 10 and 20 users. In my current organization, we don't have any other users.

I haven't used the paid support. I always find information from open forums and technical guys on the web.

I was previously working in a research organization, which favored open source. I have also used Oracle, Sybase, Microsoft SQL Server, and Ingres databases.

Its installation is very easy and quick. I am running it on Linux. It took a few minutes to install it.

I do it myself. I have been doing it for a long time. For its deployment and maintenance, one DevOps person is sufficient.

It is free, but if you need support, you can go for the commercial version called EnterpriseDB. They provide paid support, and they can even do hosting for you if you want standby and support.

For our current use case, I'm evaluating PostgreSQL versus MariaDB. I am probably going to use MariaDB because I need the temporal SQL feature, which is not available in PostgreSQL.

I would 100% recommend this solution to others. I would rate PostgreSQL a nine out of ten.

The database is used for our customers' products. We also offer some products on our POC system, and our customer's POC systems post some data stored on PostgreSQL on the cloud. Our company's data doesn't store at PostgreSQL. We still have our system MS SQL and Oracle.

The solution is very easy to use. You don't have to be extremely knowledgeable or technical to take advantage of it.

The product is quite flexible. 

We find it to be one of the cheapest options on the market. It's not expensive to use. 

The pricing could be better.

We've used the solution for ten years at this point. It may even be longer.

The solution is quite stable. We haven't had any issues with it. We haven't experienced bugs or glitches. It's reliable.

The solution is scalable. We've made some upgrades on our system, and it was so easy to do for the actual upgrades. In terms of the database itself, we haven't really had any issues with it.

I don't have any experience with technical support. Other teams in our company end up handling that. I can't speak to their knowledgeability or responsiveness having never worked with them.

I don't recall us using a different product.

In terms of the initial setup, we generally use the cloud system. The cloud system is very easy to set up these days. If you choose some with pre-installment, you trigger the system, and it's pretty automatic. You don't need a lot of things configured. After that, after you start to use it, you can tune it as you like. We made some adjustments on the system - such as additional storage or additional RAM or other resources - and we were able to add those in very easily.

The production system we use for reporting is a read-only system. Due to this, if we use the production system for reporting or other kinds of big data, the system can be slow on the customer side. However, Postgres can still service all the tasks which we need.

We haven't needed too many people to handle deployment and maintenance. There's been around ten or so that have been on it.

The pricing is reasonable. Of course, our economy has been hurt a little due to COVID-19. The pandemic has affected a lot of us. It's been hard for the companies that sell services with a database cost. You really have to choose the lowest-priced options right now. Postgres offers a fair price on the market, currently. That said, it could be less expensive, especially right now.

We definitely plan to continue to use the solution in the future. It's been quite good for us.

That said, I'm not in the financial department and I don't know the exact cost of the solution.

We're just customers and end-users.

We generally use the last version, as we try to ensure all of our programs are the latest technology. Therefore, we generally use cloud platforms like Amazon or Microsoft, which is Azure. Whichever version is on the cloud, we generally use that version.

That said, some of it is on the cloud and some of it is on-premise. In Turkey, we have some legal requirements that require some data to be stored in our country. We have to store it locally. Therefore, we can't use the cloud completely.

I'd recommend the solution to other organizations.

I would rate the product at an eight out of ten.

The database for the accounting systems is our primary use case for this solution. Business software is 80% of my use case in the accounting software. It's a good tool for planning. I work with financial data and the data mining aspect is very important, as I need to access the data easily. The data is the most important thing. Sometimes the software developers forget this part because they just want to save the data on the database, but they don't know how to manipulate the data. The performance of the solution is dependant on how easily and quickly you can obtain access to the data.

I can use Unity Kinematic. It's not easy but you can create a multi-tenant database in Postgres and I think it's a must-have in software development. With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things. 

PostgreSQL is limited to 32 TB in maximum table size for version 9.6 and earlier. This can be problematic for large databases. We currently don't have the multi-tenant feature and we require that with the contract integrated reassurance. To create have one tenant or more tenants, I need to implement or develop a software solution to connect with the multi-tenant, and to connect each tenant. PostgreSQL is not great for software developers, but it is adequate. For developers, databases such as Firebase and MongoDB technology are better. With PostgreSQL, all you need the database for is to save your data. This function on its own is not enough. The database and applications can become very slow. To debug you need to make the database query display information on your device. Some developers are not experienced in developing databases. This is especially difficult for junior software developers, and they often need more experience to be able to deal with that aspect.

We have been using Postgres for about 10 years. 

It is a stable database.

Because PostgreSQL is limited in regards to the amount of data it can hold in a single table, you often think it might be better to change the technology. Other than that, it is a good solution for business.

Sometimes it is not simple to resolve issues, but the PostgreSQL community sometimes helps to find answers to questions.

I think it is difficult to setup. I amended my ID and Oracle advised me to change it, for it to work.

If you want one tenant, you can use MySQL. If you want a multi-tenant, I think Postgres is better. SQL on PostgreSQL is linked to Oracle. Oracle and Postgres is the same thing, the same language. You will not have a big change for the software developers to migrate from Oracle to Postgres. 

I would rate PostgreSQL 8 out of 10. 

Currently, I'm doing a lot of source applications with Ruby on Rails, React, and mobile applications. PostgreSQL is my preferred database over MySQL. It's open-source and licenses are free, so it is excellent. The SQL queries are almost the same as MySQL.

Clustering is the number one feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance. MySQL has to be licensed, but PostgreSQL does all the same things. I have deployed both. You benefit from the way you use it. 

It could be improved by using parallelization. We want distributed computing. Some databases handle huge volumes of data better, such as the NoSQL database, MongoDB which can handle 100 000, or a million people using the same data search. PostgreSQL is going to take longer to do this, but it is more structured, and unlike MongoDB data is less likely to be duplicated. Large volumes of data can be handled better in PostgreSQL if the queries are written well.

I have been using PostgreSQL for about 2 years. I used to use version 9, about two years ago but right now I'm using version 10 or 12. I know how to create database functions. I know how to create relationships between data like primary keys and foreign keys etc.

I think PostgreSQL is more stable than MySQL.

As an RDBMS, a relational database management system, it scales well.

I have mainly used the Stack Overflow site for support, which is not technical support in particular. I have never been in a situation whereby I'm stuck and I have to go and ask PostgreSQL support.

The difficulty of the initial setup depends on the application you are deploying the code to. It can be integrated with Docker to enable automation of this process. I put PostgreSQL in a Docker container and then I just collect it. It just works wherever I deploy it. It takes less than three minutes. I use a continuous integration process. The Docker orchestration engine such as Kubernetes or Docker Swarm can be used to integrate with it. I store the code in GitHub or GitLab and your code is always there. Depending on the technology you're using, some things change in your configuration.

I have deployed them to Oracle recently. I've also deployed it in the cloud. There's really nothing special about the cloud, as long as I use the PostgreSQL machine I can deploy it anywhere. I want to deploy it on the Google cloud platform, and Amazon Web Services as these are well known virtual machines.

When it comes to pros, I would put MySQL and PostgreSQL in the same class. let's say I'm trying to write to the database and then the power went off. It will still keep the data integral. I don't have duplicated data, and data integrity is intact. With NoSQL databases I have to duplicate queries in case something like this happens I don't know whether my data is going to be integral in cases like a failure situation. PostgreSQL has the rollback function which remains integral. I cannot build a search engine using PostgreSQL, because that would be a very expensive hit on resources. Alternatively, with the ElasticSearch utility, and the use of load balancing, it is very easy to use. Elasticsearch returns substantial results and works in the background. I cannot do that with MySQL or PostgreSQL databases as that's actually a very expensive use of resources.

My advice would be to use PostgreSQL instead of MySQL because of licensing issues. Another reason is that Oracle may remove MySQL soon or add substantial costs to using it It may even turn into something like MariaDB, and then you would need to know if MariaDB and MySQL work the same? PostgreSQL really works well. There are a lot of other databases around right now, but PostgreSQL is the most popular. It is not like a hammer and a nail situation whereby it is the only thing you have to use. If you need a relational database management system, go for PostgreSQL instead of MariaDB or MySQL, then use it side to side. Can also consider other engines out there, like other NoSQL engines, perhaps. 

I would give it an 8 out of 10. PostgreSQL is not suitable for all types of applications, hence why I gave it an 8 instead of a 10.