Try our new research platform with insights from 80,000+ expert users
reviewer1598691 - PeerSpot reviewer
Project Manager at a comms service provider with 201-500 employees
Real User
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.

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

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 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
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
PostgreSQL
May 2025
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.
PeerSpot user
IT Assistant at Hotel 2 Fevrier
Real User
Better integration is needed, but it is easy to install and use
Pros and Cons
  • "It is very simple to manage."
  • "It needs more integration."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

It needs more integration.

For how long have I used the solution?

I have been using this solution for two years.

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

I have not contacted technical support.

How was the initial setup?

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.

What about the implementation team?

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

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

We do not pay for licensing.

What other advice do I have?

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.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Good for database management, free to use, and easy to set up
Pros and Cons
  • "It's a standard reliable database management system."
  • "The interface could be much better."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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

How are customer service and technical support?

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.

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

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

How was the initial setup?

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.

What about the implementation team?

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

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

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

What other advice do I have?

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. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1519272 - PeerSpot reviewer
Full Stack Developer at a tech services company with 10,001+ employees
Real User
Many job creation types available but needs improved documentation
Pros and Cons
  • "We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
  • "The solution needs to improve the query, documentation, and JSON data functionality."

What is our primary use case?

I am using the solution for data analytics, mainly for ERP because we use Hadoop and Hadoop is a dependency of PostgreSQL through the platform.

What is most valuable?

We are able to create many different types of jobs and items with this solution making it one of the most valuable features.

What needs improvement?

The solution needs to improve the query, documentation, and JSON data functionality.

For how long have I used the solution?

I have been using the solution for two years.

How are customer service and technical support?

I think the technical support should improve for this solution.

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

I have previously used MySQL and am currently using it for other projects. MySQL is a little easier to use.

How was the initial setup?

The installation is more difficult to install than other solutions I have used.

What other advice do I have?

I rate PostgreSQL a seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
KopanoRamaphoi - PeerSpot reviewer
Consultant at Rpc Data
Real User
Intuitive interface, easy to use, but installation lengthy
Pros and Cons
  • "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."

What is most valuable?

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

What needs improvement?

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.

For how long have I used the solution?

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

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?

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

How are customer service and technical support?

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

How was the initial setup?

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.

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

The solution requires a license.

What other advice do I have?

I recommend this solution for small organizations.

I rate PostgreSQL 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
reviewer1490673 - PeerSpot reviewer
Principal Engineer at a manufacturing company with 201-500 employees
Vendor
A robust solution that does the job and completely meets our needs
Pros and Cons
  • "It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
  • "When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."

What is our primary use case?

We design it and put it as part of our system and sell the system to various airports. We've designed our own schemas, and we track events that are meaningful to airports so that they can create their reports, view statistics, and make meaningful decisions that make sense for them.

What is most valuable?

It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job.

What needs improvement?

When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties.

For how long have I used the solution?

I have been using this solution for 18 years.

How was the initial setup?

It is pretty straightforward.

What other advice do I have?

I would rate PostgreSQL an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1481757 - PeerSpot reviewer
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
Real User
Good performance and simple to use
Pros and Cons
  • "What I like is that it's quite powerful in terms of performance."
  • "I had some issues when I integrated with the Jupyter Notebook."

What is our primary use case?

We use it as an intermediary database for the collection of a variety of data points out of our data systems.

There are many departments that have different data, single points of truth. We asked them to give us different datasets, and we accumulated them in our Postgres-stored database.

It's an intermediary for a machine learning model.

How has it helped my organization?

I am more of a fan of doing things straight out of Python, but with the size of the data sets, we were forced to do it in SQL.

What is most valuable?

What I like is that it's quite powerful in terms of performance.

Part of the reason we use this solution is because of its simplicity and because it works. It does all of the basic things it's supposed to do and it's not anything fancy.

They are fulfilling their customer's needs. 

What needs improvement?

I had some issues when I integrated with the Jupyter Notebook. 

In the system administration, if you open the connection to the database with a notebook, there is no automatic closing of this connection. 

I would like to see seamless integration with other tools such as Jupyter Notebook. We use it with Anaconda.

Also, possibly more streamline integration with more programming languages. An API for some different languages such as MARGO and JavaScript could be interesting.

For how long have I used the solution?

I have been using PostgreSQL for one year.

What do I think about the stability of the solution?

I had an issue where we couldn't find the fault, and it happened on occasion at the end of the day. Some of my basic queries would stop running. 

I had some queries run for two days and some run for a day, then I would have to try it again the next day and it would complete in 20 seconds. Sometimes, it seemed to catch itself.

How are customer service and technical support?

I haven't had any contact with technical support from PostgresSQL. I do my research using Google.

How was the initial setup?

I did not initialize this database, but from what I understand it's very basic. It was simple to do.

What other advice do I have?

I would prefer programming languages to query languages. Scripting, for instance.

If you have a relational database then you want to use PostgresSQL. I would recommend this solution to others who are interested in using it.

It's suitable for everything we use. There was nothing exceptional from my perspective, but it did everything we needed it to do.

I would rate this solution 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