Try our new research platform with insights from 80,000+ expert users
Software Architect at a tech services company with 5,001-10,000 employees
Real User
Top 5Leaderboard
Dec 7, 2021
Stable and scalable but needs better integration
Pros and Cons
  • "Initial setup is simple."
  • "Integration with other platforms could be improved."

What is most valuable?

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. 

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

Buyer's Guide
PostgreSQL
December 2025
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,986 professionals have used our research since 2012.

What do I think about the scalability of the solution?

This is a scalable solution.

How was the initial setup?

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

What other advice do I have?

I would rate this solution as seven out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Senior DBA & IT Consultant at a tech services company with 201-500 employees
Real User
Oct 15, 2021
A stable open-source relational database management system
Pros and Cons
  • "I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
  • "The price could be better."

What is our primary use case?

Any relational databases that you have in Oracle, you can move to PostgreSQL. This is what we have been doing at the moment. 

What is most valuable?

I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable.

What needs improvement?

The price could be better.

For how long have I used the solution?

I have been using PostgreSQL for a few years.

What do I think about the stability of the solution?

PostgreSQL is quite stable.

Which solution did I use previously and why did I switch?

We used Oracle before switching to PostgreSQL.

How was the initial setup?

The initial setup and installation didn't take a lot of time. It usually takes about a couple of hours.

What about the implementation team?

I implemented this solution by myself.

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

It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it.

What other advice do I have?

I would recommend it as a choice for people that want to move from Oracle to another database, which is relatively free. 

On a scale from one to ten, I would give PostgreSQL an eight.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
PostgreSQL
December 2025
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,986 professionals have used our research since 2012.
Ruben Conti - PeerSpot reviewer
Owner at a tech services company with 11-50 employees
Real User
Top 5
Oct 10, 2021
Available, stable and reliable
Pros and Cons
  • "PostgreSQL is stable. It's available, stable, and reliable."
  • "There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."

What is our primary use case?

We use PostgreSQL as a database for our ERP system.

What needs improvement?

There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time. We haven't tried the latest version, but they're supposed to add some of the most important things.

For how long have I used the solution?

I've been using PostgreSQL for nearly 20 years.

What do I think about the stability of the solution?

PostgreSQL is stable. It's available, stable, and reliable.

How was the initial setup?

Installing PostgreSQL is not so easy, and the installation takes about one day.

What other advice do I have?

I rate PostgreSQL eight out of 10. I would definitely recommend it.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1593588 - PeerSpot reviewer
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
Real User
Aug 29, 2021
A stable solution with an easy setup for media management
Pros and Cons
  • "The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."
  • "A better graphic user-interface would be nice to see."

What is our primary use case?

We use the solution for media purposes. We manage the sites of one of the largest sports business papers and multiple TV channels. So, we develop the websites.

What is most valuable?

We are increasingly using their support for JSON, which we find to be very complete, something I made use of in the past. The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions. One can change the database structure transactionally. This is one of the few databases that allows this. I like it. 

The solution is comparable in sophistication with that of Oracle. Each product has a few things less and more than the other. We also like that the solution is open source. We have good performance with a small footprint. It's rather nice. It's very robust.

What needs improvement?

The solution could be improved through an upgrade to the latest version. 

A better graphic user-interface would be nice to see. 

There is nothing I particularly dislike about the solution. The data propagation in master-slave configurations would be a good example. This is one of the features that I understood the least, yet we have it working and use it to propagate from the content management system database to the multiple publishing databases. 

This said, I would like this propagation feature to be simplified for new users and to come with better explanation. However, I will refrain from giving criticism on this point, as I do not know if they already handled this in the last version. Overall, I have only praise for the solution.

I cannot point to anything in particular that we are missing out on at the moment. What comes to mind are features that I have yet to try, although I don't  have any wish lists for PostgreSQL at the moment. I don't know how it stacks up when it comes to the importing and exporting of data. For databases involving this, we just make use of Redshift, which is verified from PostgreSQL and developed by Amazon. 

For how long have I used the solution?

I have been using PostgreSQL for a couple of years.

What do I think about the stability of the solution?

The solution is very stable. We have databases that have been running for years.

What do I think about the scalability of the solution?

We have scaled the solution just to three slave machines, but it works well when it comes to master and slave. 

How are customer service and technical support?

Mostly, support consists of the community and there are several consultancies, should the need arise, although we have never had use of these. There have been no issues on this end. Community support has always been sufficient for us. 

How was the initial setup?

On a single machine, the initial setup is extremely easy. I also find configuration to be very simple. It is similar to MySQL in that a person must know what he wants when it comes to setting up the solution, in which certain features would come into play. Setting it up in a different way will involve the use of multiple search engines. 

With the solution, one installs it and whatever he tunes is optional. Of course, he would have to play with the configurations if he wishes to have specific personality, such as cluster configurations, or tuning for very demanding performance. Overall, for small things or development, one need only install it, start it and it's done. 

While the length of the deployment varies with the configuration, a simple one will take a couple of minutes. 

What other advice do I have?

We deploy the solution both on-premises and on AWS. 

I had my doubts about the functionality before joining this company, as it seemed very complex. It turns out that the solution is actually very simple to set up and we have it working all the time without any problems. It survives the network partitions, so we like this very much. 

My advice is that a person just try it and use it. For me, it beats out JSON and is superior to MongoDB. It works in a completely different way. But, overall, I would rather use PostgreSQL when it comes to starting and manipulating JSON and it boasts superior integrity and performance. Of course, there are specific things that MongoDB does differently. A person's mileage may vary, depending on what he wishes to accomplish. 

I rate PostgreSQL as a nine out of ten and I choose to knock it down a point only because it could use a better graphic user-interface. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ravi-Upadhyay - PeerSpot reviewer
Founder at a tech services company with 1,001-5,000 employees
Real User
Top 20
Jul 13, 2021
Familiar to other solutions, stable, but not use-friendly
Pros and Cons
  • "The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
  • "PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution."

What is our primary use case?

We use this solution for the back-end database.

What is most valuable?

The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution.

What needs improvement?

PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution. 

For how long have I used the solution?

I have been using PostgreSQL within the past 12 months.

What do I think about the stability of the solution?

I have found the solution stable.

What do I think about the scalability of the solution?

The solution is scalable but it could improve.

We have approximately 10 users using this solution in my organization.

How are customer service and technical support?

We are using the open-source version for eight years. We have to rely on our own skillset to manage it.

How was the initial setup?

The installation is easy.

What about the implementation team?

We did the implementation ourselves but it is always recommended to use an expert.

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

This solution can offer a cheaper choice for customers since it is open-source.

Which other solutions did I evaluate?

I have evaluated SQL Server.

What other advice do I have?

If you have a startup company with a normal production environment then this PostgreSQL should be fine. However, if there is a professional environment where there will be some support requirements and mission-critical applications, then they should choose an alternative, such as SQL Server.

I would recommend this solution to others.

I rate PostgreSQLa seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1428423 - PeerSpot reviewer
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Jul 10, 2021
Free to use, stable, and quick to set up
Pros and Cons
  • "The product is very similar to the SQL Server."
  • "I'm not really able to customize it."

What is our primary use case?

We use it for processing files mostly. It integrates basically with the SQL Server. On the server-side it uses the SQL Server, then from the files that are generated from SQL Server we do have an application running using Microsoft, and we attach it to a Postgres server. We do is for the backups there from time to time.

What is most valuable?

Overall, the solution is very good. 

The solution is free to use.

It is easy to use and quite stable. It's as robust as Oracle, however, SQL Server is easier to use I think.

The product is very similar to the SQL Server. 

The installation is quite fast.

What needs improvement?

If you look at overall PostgreSQL, it could be easier to use.

I'm not yet able to use all of the features on the product at this time. 

I'm not really able to customize it.

The integration could be easier. SQL Server has an easier integration process, for example, as a comparison.

With Postgres, you can run it in Windows Server, however, there are other things that you have to run.

The product is more for technical people. For example, SQL Server is for anybody. Even newer users can just pick it up and learn from it and mess with it and run it. You can't do that with PostgreSQL. It has more of a learning curve. YOu need more training and documentation.

For how long have I used the solution?

We've been using the solution for about five years. We've used it for a while, however, it is only on a few workstations.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

There are only a couple of users at this time as we restrict it only to local implementations. Per store, we do have certain applications that use it. 

How are customer service and technical support?

We haven't reached out to techncial support. As with Linux, if you want tech support then you have to pay a subscription for it. The free version is, with what we have here, working well and we haven't had problems.

I have only a couple of people helping me with regards to the tech support, internally. That's why we spend a lot of time focusing more on the SQL Server and the Microsoft products.

Which solution did I use previously and why did I switch?

We did not previously use other products. 

I've also used Oracle and Microsoft SQL. This product is free and more robust than Oracle, however, Microsoft SQL might be easier to use.

How was the initial setup?

The installation is pretty quick. It's not hard to set up. I wouldn't describe it as a complex process. 

We only have a couple of people on staff that can handle deployment and maintenance. 

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

The product is free. You don't have to pay a license fee. 

What other advice do I have?

The last one that we used is version 11 or something like that. I'm not sure if that's the latest version or not.

Postgres is similar to Linux. It's designed for people who would know what they want, who would have to set up what they need, and they would use it, and they know that it's straightforward, so that other people cannot just go in and mess with it.

I'd rate the product as a nine out of ten.

I'd recommend the solution to other users. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1598691 - PeerSpot reviewer
Project Manager at a comms service provider with 201-500 employees
Real User
Jun 20, 2021
Stable, easy to install and use, but the security needs improvement
Pros and Cons
  • "It is easy to use."
  • "It could be more secure."

What is our primary use case?

We use this solution as part of our backend to store data that is coming from the sensors. 

It is needed to save the meter data from the sensors.

What is most valuable?

It is easy to use.

What needs improvement?

It could be more secure.

For how long have I used the solution?

I have been working with PostgreSQL for approximately two years.

I am using the latest version.

What do I think about the stability of the solution?

PostgreSQL is a stable solution.

What do I think about the scalability of the solution?

We use this solution for organization's applications at the backend and it is not used directly by the end-users.

How are customer service and technical support?

I have not contacted technical support.

Which solution did I use previously and why did I switch?

It is a bit different from Oracle, with respect to security.

How was the initial setup?

The initial setup is straightforward.

It was a token installation, I can do it myself.

What other advice do I have?

I would recommend PostgreSQL to others who are interested in using this solution.

I would rate PostgresSQL a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1362969 - PeerSpot reviewer
IT Specialist at a government with 1,001-5,000 employees
Real User
Jun 19, 2021
Performs well, reliable, and scalable
Pros and Cons
  • "The most valuable feature is the performance."
  • "The solution could improve the integration."

What is our primary use case?

We use the solution for database management and storage.

What is most valuable?

The most valuable feature is the performance.

What needs improvement?

The solution could improve the integration.

For how long have I used the solution?

I have been using this solution for approximately four years.

What do I think about the stability of the solution?

I have found the solution to be stable.

What do I think about the scalability of the solution?

PostgreSQL is a scalable solution. However, it could be better.

How are customer service and technical support?

I have not needed to use the support.

How was the initial setup?

The installation is not simple, it is more difficult than DeviceSQL. We had a few issues during the installation.

What about the implementation team?

I did the implementation of this solution myself and it was more complex than MySQL.

Which other solutions did I evaluate?

I have evaluated MySQL and DeviceSQL.

What other advice do I have?

I would recommend this solution to others.

I rate PostgreSQL an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2025
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions.