Try our new research platform with insights from 80,000+ expert users
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited
Real User
Open source solution that supports more than one SQL language and improves with each upgrade
Pros and Cons
  • "This is an open-source solution, operates at a high speed, and supports more than one SQL language."

    What is most valuable?

    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. 

    What needs improvement?

    This solution could be better integrated with other systems. 

    For how long have I used the solution?

    I have used this solution for four years. 

    What do I think about the stability of the solution?

    This is a stable solution. 

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

    What do I think about the scalability of the solution?

    This is a scalable solution.

    How are customer service and support?

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

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

    We previously used Microsoft SQL.

    How was the initial setup?

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

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

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

    What other advice do I have?

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

    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
    Projects Manager at Emery Investments
    Real User
    Stable, open-source solution that makes scaling a database affordable; could be more user-friendly
    Pros and Cons
    • "It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
    • "As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."

    What is our primary use case?

    Our primary use case for PostgreSQL is data storage. 

    What needs improvement?

    As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself. I would like to see it become more user-friendly. 

    For how long have I used the solution?

    I do not use PostgreSQL regularly but I have been running a project that has been utilizing it for six years. I head a tight-knit group that includes a front end developer, backend developers, and hardware people. They deal with PostgreSQL and I do not have hands-on experience with this solution. 

    What do I think about the stability of the solution?

    PostgreSQL is stable and easy to use. 

    What do I think about the scalability of the solution?

    It is very scalable and comes with a bonus: no licensing issues as you scale with your databases. 

    Currently, 15 people use PostgreSQL at our organization. 

    How are customer service and support?

    I am satisfied with PostgreSQL's technical support. 

    How was the initial setup?

    The initial deployment was fine. If you read through the steps, you should be OK. 

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

    The licensing is fine. It is not a paid database license. 

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Buyer's Guide
    PostgreSQL
    August 2025
    Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
    865,295 professionals have used our research since 2012.
    reviewer1734405 - PeerSpot reviewer
    Head Channel and Capacity at a computer software company with 201-500 employees
    Real User
    Stable, scalable, helpful community support
    Pros and Cons
    • "The solution is scalable, it is very good."
    • "PostgreSQL could improve by adding data warehousing tools."

    What is our primary use case?

    We deployed the Postgre database on CentOS, which is a version of Linux. We have experimented with our replication and other operations. It works perfectly well. We are using the open-source version and do not plan on using any enterprise database.

    What needs improvement?

    PostgreSQL could improve by adding data warehousing tools.

    For how long have I used the solution?

    I have been using PostgreSQL for approximately eight years.

    What do I think about the stability of the solution?

    PostgreSQL is stable.

    What do I think about the scalability of the solution?

    The solution is scalable, it is very good.

    We have approximately 100 users using this solution.

    How are customer service and support?

    There is a lot of community support online to help with many things, such as updates. The online support is very active.

    How was the initial setup?

    The installation is straightforward and simple, it took only half an hour.

    What about the implementation team?

    We did the implementation through an in-house IT engineer.

    We have a team of approximately five engineers that manage the solution.

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

    We are using the free version of PostgreSQL.

    What other advice do I have?

    I would recommend this solution to others.

    I rate PostgreSQL a nine out of ten.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Software Architect at AIOPS group
    Real User
    Top 5Leaderboard
    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.

    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
    Ruben Conti - PeerSpot reviewer
    Owner at Intersoftware sas
    Real User
    Top 10
    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
    reviewer1524594 - PeerSpot reviewer
    Senior Solutions Architect at a manufacturing company with 51-200 employees
    Real User
    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
    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
    reviewer1601793 - PeerSpot reviewer
    Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
    Real User
    Easy to use, simple to install, and quite stable
    Pros and Cons
    • "It's quite scalable."
    • "If it was free to use, it would be the perfect solution."

    What is our primary use case?

    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.

    What is most valuable?

    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. 

    What needs improvement?

    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.

    For how long have I used the solution?

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

    What do I think about the stability of the solution?

    The solution is 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?

    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.

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

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

    How was the initial setup?

    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.

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

    It's not an expensive solution.

    What other advice do I have?

    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.

    Which deployment model are you using for this solution?

    Public 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
    Buyer's Guide
    Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions.
    Updated: August 2025
    Buyer's Guide
    Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions.