PostgreSQL Reviews

In my current company, we use a wide array of databases, like, Cassandra, Elasticsearch, MongoDB, and Postgres. But here, We specifically use Postgres for transactional purposes.

Since, NoSQL database does not have any, like, transactional-based things. It is called asset property. Since SQL databases possess these asset properties, we primarily rely on SQL, particularly Postgres, due to its superior indexing and performance advantages given our scale.

Compared to MySQL, Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful. Indexing is better in Postgre due to the algorithm it uses, such as B-tree indexing. 

Moreover, Postgres has a specific data type called JSONB, which stores JSON in binary format, resulting in optimized performance.

We have to set up event API, which takes a lot of events from the user. For us, Postgres DB wasn't performant enough to use, so we had a bottleneck there. We use Cassandra, which drastically improves but isn’t a drawback of Postgres. It is common with most SQL databases.

I have been working with Postgre for the past year and a half. 

Since we are using Postgre for maintenance purposes, we haven't encountered any issues thus far.

I rate the solution’ stability a ten out of ten.

When it comes to an open-source SQL database, Postgres is highly scalable. You can easily implement partial configurations and streaming replication factors. Postgres offers most of the features.

It depends on how they configure things. So if everything is set up well, they should perform great.

I rate the solution’ scalability a nine out of ten.

We use managed database. Since our Tech team is small, consisting of only four people, we have to work on mobile applications, web applications, and the backend. We have to save some developers' time. We usually choose to use managed database services. Managed services are quite easy as they allow us to set up the databases with just a few clicks quickly.

The pricing for managed databases will be much higher than self-managed ones. That's something I'm sure about. When it comes to accurate pricing information, I always prefer their pricing tables.

Postgres is a very performance-based database. It is an all-in-one tool. You can use it as an SQL database or as a NoSQL database. They do have a data type called JSONB. You can use some part of it in a hybrid NoSQL database or as a key-value-based DB. They do have a good number of plugins. So if they have to extend the capabilities, they have a wide variety of plugins. Depending upon use cases, you can use them. For example, to do some cron jobs, you have a plugin called pg_cron, and you can use PostGIS for geospatial applications. PostGIS is a very awesome thing to work with.

Overall, I rate the solution a nine out of ten.

We have a use case for the solution which was related to a website that we developed for a Spanish energy line transmission company. The company used to face a lot of legal issues in Brazil. We had created a SaaS product that helped them to monitor the Brazilian legal parameters. The company had used the product only for two years and then discontinued it.

The company also faced many internal problems where they had to urge the lawyers to get used to the SaaS products. The lawyers wanted to input information into another system and this is where we used PostgreSQL.

PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way.

In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end.

As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands.

I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET.

I would rate the solution a nine out of ten. PostgreSQL is an open-source enterprise-grade product and is available free of cost. The tool doesn’t have a big company behind it. The solution is very well documented and you can find a lot of information from the community. The solution is a good product compared to MySQL. People have been moving away from MySQL ever since it became an Oracle product.

PostgreSQL can handle heavy loads. I follow some of the most important DBA professionals in the industry and they are using this product. This tool is a rock-solid product and the most advanced relational database software that is open source.

Some open-source solutions have a restriction on the license but there are no problems when commercial applications use the solution. You cannot use a commercial product with open-source solutions that have license restrictions.

We are using it as a database to store information.

Postgres SQL is quite a good database.

The performance is good.

I have noticed that user and access management should be improved. Connection pooling should be improved. We rely on connection pooling.

Monitoring is incompatible. It is open source. To advance, you must access the internet and download and test various other tools, or develop your own tools. With Microsoft server, it is one single platform that provides you with everything, but with Postgre you have to install or check different tools to integrate with it. That's the annoyance, but it's still the way open source technology works.

I would like to see better management in PostgreSQL.

PostgreSQL is easy to scale.

We have a medium-sized company.

We don't have technical support. It is community-based. We get assistance through Github.

We have been working with Microsoft SQL.

The main difference between SQL and Postgre is that Postgre is open source. It's completely free.

It's very simple to set up.

Postgre is open source. It is almost completely free.

The community version of Postgre is basically free.

We are utilizing the database's active native security features. As a result, we currently have no need for any external security tools. We had, but we worked around it.

The advice would be to go with a managed Postgre. If you're going to install Postgre in the cloud, for example, it's better to go with a managed Postgre rather than handling everything on our own.

I would rate PostgreSQL a nine out of ten.

This solution is very good for getting data. It is very useful for reporting purposes. We also use one of the tools of IBM Cognos for reporting purposes.

For small-scale setups, the solution is stable.

The solution is open-source and free to use.

Currently, we are working with Postgre's economy, and we are not able to implement real-time solutions with our existing architecture. There's a general lack of real-time data from Postgre.

The solution isn't as stable for larger data sets. 

The scalability is limited.

We'd like the solution to be faster. 

I've been working with Postgre for the last two years. However, the organization that I was working with from the beginning has been using this. This was open-source and they've been working with it since 2017.

The product is stable only for working on relatively small data. It's not ideal for large amounts of data. Our business has grown rapidly. We have more customers and our data has grown very rapidly. We need to manage performance and tuning and may need a grander product. The performance could be better.

We're struggling with scalability. It's one of the issues we're facing right now.

This is hosted by this AWS. We generally raise tickets to them whenever we're in need of assistance.

For example, if we're doing any replication or any of that thing, we just raise tickets, and it gets resolved through them.

The support has been pretty good.

I was not involved in the actual deployment of the solution and therefore cannot speak to how difficult or simple the process was.

Currently, I've been given the role to do some research and switch to a different database.

The solution is open-source. We don't need to have a license in order to use it. 

We're currently looking for a more modern solution to replace Postgre. I'm aware of AWS Redshift, Query, and Nextly. These are major players in the market.

We are just a customer of Postgre.

Since the data volume has increased rapidly, we are concerned Postgre won't be suitable for our long-term requirements. We're currently looking for an all-in-one option.

I'd advise users that are not looking for speed or do not have huge amounts of data to try this solution. 

I'd rate the solution at an eight out of ten.

I am using PostgreSQL to develop a general ledger system. The solution is on-premise right now, but it's going to be on the cloud soon.

PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person.

Each of these entities has some things that are common, such as name and registration for an identity for the ISR in the US and in Mexico's it is called the SAT. We have to have different characteristics for each of them. In PostgreSQL, I can easily create a field for this moral person, with a different set of fields. It allowed me to have some plasticity on each entity that I am describing. People that are working inside the company, have some requisites that are different from one position to another. This plasticity allows me to move it for every person that is inside the company. PostgreSQL allows me to do all of this will ease. This feature is called H store, it is wonderful. 

I'm using the replication that they have inside, in case one company may wish to have the solution on-premise, they can have the replication feature that is already embedded and it's free. You don't have to pay again for that solution.

PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic.

I have been using PostgreSQL for approximately six years.

The solution is stable.

PostgreSQL is scalable.

I have not used the support from PostgreSQL. I have not had any large problems.

I have found all the information I need online in many of the communities they have.

I was previously using Microsoft SQL Server and MySQL.

With MySQL, I had once a terrible problem with a group that was only giving me the first record of a group. I had to implement it through other means for the solution to give me the result that I was required.

The initial setup of PostgreSQL was very simple. I am using Ubuntu and you only have to go to the synaptic and download the package and it's already stable. It can be down in a matter of minutes, it's wonderful.

I would recommend this solution to others.

I rate PostgreSQL a ten out of ten.

We use it for inventory control.

We are able to use it on many servers and incur no cost impact, whereas Oracle charges you by the number of cores that are on each individual server, whether you use those cores or not.

The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres.

It is a great product, and it just works. 

They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great.

I have been using this solution for three years.

It is better than Oracle. It is a great product.

It scales horizontally, so it is great. You can do whatever you want with it. We probably have 10,000 users. In terms of their role, they buy products, put them in the inventory, and distribute them.

It is being used quite heavily. The idea is to get rid of Oracle and replace Oracle with Postgres.

It doesn't have any support because it is open source. They provide you with the documentation that's free, and you get everything except help. You're on your own, which is okay. I and one other person came up to speed on this, and we're basically the subject matter experts (SMEs).

EnterpriseDB (EDB) is a company that provides technical support, but we decided not to do that.

We used Oracle. We're currently in the process of migrating from Oracle to Postgres, and we're doing it because of cost.

Postgres is a superior product, and it is free. Oracle's support is really terrible, so you're not really getting any support from Oracle.

It was very straightforward and easy. It is very well documented.

We can deploy a server in about three or four hours. We use a primary and a standby server, so we have two servers in the cluster.

My partner and I read the books and then just did it. I am on the development side. They get the new products in, and I and this other person evaluate them and learn them. We probably have three people in operations who are handling Postgres on the production side.

It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs.

We evaluated EnterpriseDB (EDB) Postgres, which is a paid product, whereas Postgres is open source. We decided that it was better to go with a free product.

I would absolutely recommend this solution if you're concerned about cost. It seems easy and straightforward.

I would rate it a 10 out of 10. It is really great. It works amazingly well.

We deploy our databases in either a local cloud or AWS. For the locally deployed database, we have our own private cloud consisting of a couple of different data centers that we partner with. For everything else, we use Oracle or Microsoft SQL. On the Microsoft SQL side, that's not usually software as a service. It's generally done as a local installation on a virtual machine. If we're doing a deployment on an AWS environment, we use the AWS Postgres database. It's slightly different than doing the installation yourself. So if you're doing the PostgreSQL installation on a Linux environment, that's usually when we're using that directly from postgresql.org. 

It's an open-source database, so we can see the code used for that database. Also, we use it because it's lightweight, easy to deploy, and scalable for particular projects, especially if we're dealing with something that requires a Docker deployment.

I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did. 

I've used PostgreSQL off and on for different projects for probably about 20 years now.

Postgres' stability is wholly dependent on the skill and knowledge of the administrator who deployed it. Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution. It's reliable but requires more familiarity than you would necessarily need with a database like Oracle or Microsoft SQL out of the box.

The biggest shortcoming of Postgres and most open-source applications is support and documentation. There's usually a decent amount of technical documentation. That would be for someone that works exclusively within the database. But it would be helpful to have more documentation at the DevOps level so developers have a better idea of maintaining the database's performance without necessarily requiring a developer who specializes in that database. A lot of DevOps people are much more interested in writing their code for the databases to work. And sometimes, they end up devoting more time to database tuning than is necessary for an application developer. So documentation in that area would probably be best.

So back in late August, the developers released PostgreSQL 14, the most feature-rich deployment to date. And they did a reasonably decent write-up about the new and unique features. What I found most interesting is that you can use a straight-up Windows installer for the PostgreSQL database. And it includes all the components of the stack you need, so you don't necessarily need to know how to install its different parts. For example, suppose you're going to install it for Solaris, BSD, or Linux. So when you're installing in those three environments, it's usually packaged and requires secondary packages. And some of these packages are version dependent, so it can get complicated pretty quickly. If you are curious about how PostgreSQL databases run, I suggest you try it out on Windows first.

We use PostgreSQL alongside Microsoft and Oracle solutions. Postgre is suitable for scaling with specific projects. But while it scales very well, Postgre doesn't have the same recovery features as some larger-scale databases. For example, you can run Oracle Databases in a couple of different ways for easy recoverability should the primary database fail. First, you've got a rack for redundancy and load distribution. Second, Oracle has a feature called Data Guard that replicates the database in case it goes down. Data Guard allows you to run a completely different copy of the database that will take our main exports and keep it up to date. So if your primary database has a software or hardware failure, you can bring up the secondary database and re-task your applications to use that database. It's not as simple to do this with Postgres. 

I rate PostgreSQL eight out of 10. 

We use it in new team architectures, microservices architectures, and databases that are relatively small.

We also use it for table data, public web pages, some server applications that require data persistence, and some backend modules.

It's a useful solution, that can be widely used.

It is easy to use.

PostgreSQL has a large community.

The performance is good.

We don't have any use cases where we would use it in a large application as we do with Oracle. This is one limitation of this solution. We are unsure when it comes to deploying a large 24/7 application. 

It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved.

I have been using PostgreSQL for five years.

We use several different versions. It is determined by the application. For server applications, we use version 9, which is an older version, and for others, we use the most recent version.

PostgreSQL is a stable solution.

This solution is used by 10 people in our company.

It is supported by a third-party company.

I have never contacted technical support.

I am also using Oracle.

I have no experience with the deployment of this solution.

The licensing model is good.

I would recommend this solution to others who are considering using it.

I would rate PostgreSQL a nine out of ten.

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.

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.