it_user448368 - PeerSpot reviewer
DBA / ETL Developer / Consultant at a marketing services firm with 1,001-5,000 employees
Real User
It has the same features as paid-for databases such as Oracle and SyBase.

What is most valuable?

It has the same features as paid-for databases such as Oracle and SyBase.

How has it helped my organization?

It's saved us money as it's free.

What needs improvement?

Eliminate the transaction wraparound possibility. If transaction wraparound occurs it can be a major problem.

For how long have I used the solution?

I've used it for two years.

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

What was my experience with deployment of the solution?

There were no issues deploying it for us.

What do I think about the stability of the solution?

We've experienced no issues with performance.

What do I think about the scalability of the solution?

There have been no issues scaling it for our needs.

How are customer service and support?

There is none available as it's a community driven solution.

How was the initial setup?

It's simple to get it up and running.

What about the implementation team?

We did it in-house.

Which other solutions did I evaluate?

We tested a big portion of our online API product using SoapUI and it was very fast and efficient.

What other advice do I have?

Use this product for simple needs if you do not have PostgreSQL expertise. If you have PostgreSQL expertise you can run your business off PostgreSQL.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Technical Lead with 1,001-5,000 employees
Real User
It improves the query performance a lot. Sometimes it hangs and then we need to stop and start the services again.

What is most valuable?

PostgreSQL gives you much more flexibility because it's open source.

How has it helped my organization?

It improves the query performance a lot and helped in some real time and analytic reporting

What needs improvement?

Sometimes it hangs and then we need to stop and start the services again

For how long have I used the solution?

I've used it for three years.

What was my experience with deployment of the solution?

We've had no issues with the deployment.

What do I think about the stability of the solution?

There have been no stability issues.

What do I think about the scalability of the solution?

We have had no issues scaling it.

How are customer service and technical support?

Customer Service:

7.5/10

Technical Support:

7.5/10

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

No other solution was used.

How was the initial setup?

It was straightforward.

What about the implementation team?

We used a vendor team.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
PostgreSQL
April 2024
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
771,063 professionals have used our research since 2012.
PeerSpot user
Director of Client Integration at a financial services firm with 51-200 employees
Vendor
The query syntax and functions are well documented and easy to use.​

What is most valuable?

The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use.

How has it helped my organization?

PostgreSQL is a powerful and open source database, which is central all data processing.

What needs improvement?

We'd like to be able to start using JSON objects for easy code representation. This feature is available in v10.4.

For how long have I used the solution?

I've been using it for eight years.

What was my experience with deployment of the solution?

We've had no issues with the deployment.

What do I think about the stability of the solution?

There have been no stability issues.

What do I think about the scalability of the solution?

It's been able to scale for our needs.

How are customer service and technical support?

I use online documentation, which met my needs.

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

We were using version 8 before, and also an earlier Oracle instance. We chose the product because it is powerful, well documented, and open source.

How was the initial setup?

I did not set up the actual installation. I did set up the schema, tables, foreign keys, etc. That was straightforward in that it was well documented.

What about the implementation team?

In house. You do need someone that knows PostgreSQL or that can spend time learning about the product.

What was our ROI?

It's open source. ROI is a matter of time.

What other advice do I have?

The challenge with this product would be finding the IT resource that can implement the product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user457314 - PeerSpot reviewer
Sr. Oracle and PostgreSQL DBA at a consumer goods company with 1,001-5,000 employees
Vendor
The basic features are sufficient to fulfill our needs.

What is most valuable?

Open source products represent no cost to the organization and the basic features are sufficient to fulfill our needs.

How has it helped my organization?

  • Cost savings
  • Easy spin off for new environments

What needs improvement?

The only feature where I can see an area of improvement is with the partitioning. As soon as you implement partitioning, all your relationships are no longer supported since the PK-FK relationship is no longer supported and you need to look for options or database changes to supported with secondary tables, database rules or triggers.

For how long have I used the solution?

I've used this solution for two years. We also use the EnterpriseDB version of PostgreSQL.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

We had no issues with the performance.

What do I think about the scalability of the solution?

It's been able to scale for our needs.

How are customer service and technical support?

We have no external services.

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

We haven't used any other open-source service, but we have engaged Enterprise DB for enhancing our monitoring but there was no need to do so.

How was the initial setup?

I wasn't in my current organisation when it was implemented.

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

We use the open source versions of PostgreSQL so there is no expense for licensing.

What other advice do I have?

Do continuous testing and research on new features as they have an excellence performance response.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Computer Science Teacher at a educational organization with 501-1,000 employees
Vendor
I've had no issues deploying it.

What is most valuable?

  • Confidentiality
  • Integrity
  • Availability
  • Bug free

I like to work with a piece of software that is bug free and doesn't required to be launched in order that users will find a couple of bugs in the coming weeks and that the company has to fix it.

How has it helped my organization?

It helped me to find an easy and inexpensive solution for databases

What needs improvement?

It would be interesting to have a cloud based database instead of having to install it on any single machine.

For how long have I used the solution?

I've used it for approximately one to two years.

What was my experience with deployment of the solution?

I've had no issues deploying it.

What do I think about the stability of the solution?

The stability was an issue, because when coding under Eclipse with Java, some errors occurred while trying to connect to the database, so troubleshooting may be difficult, since you don't know if it's a Java coding issue or a PostgreSQL translation issue.

What do I think about the scalability of the solution?

There have been no issues scaling it.

How are customer service and technical support?

I never used any customer service or technical support during that time. I used to find alternatives to my issues.

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

Since Oracle was expensive for a company business an inexpensive way was to focus on PostgreSQL.

How was the initial setup?

The initial setup was straightforward, just activating various modules was more complex.

What about the implementation team?

We did it in-house.

What was our ROI?

I saved money instead of using the Oracle solution, which might be more secure than PostgreSQL in various ways.

What other advice do I have?

You need to find a lot of time in order to find all functionality and get used to the PostgreSQL syntax Be patient, look for various forums and do learning by doing.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
DWH Analyst at a financial services firm with 1,001-5,000 employees
Vendor
It can be used by people on pure user level, without deep knowledge of OS administration, programming.

Valuable Features

The reason why I started with PostgreSQL database was the (geo)spatial support. GIS software, such as Quantum GIS (QGIS) or PostGIS, is a good example of where you are able to use this feature. Nowadays, the solution is on a competitive level to other commercial software solutions, especially for small companies.

Improvements to My Organization

PostgreSQL (geo)spatial support is stable, and you can add, remove, and edit all standardized GIS features. Thanks to projects such as EDB, Bitnami etc., PostgreSQL can be used by people on pure user level, without deep knowledge of OS administration, programming.

Room for Improvement

There is room to improve some user friendly properties such as input and output tools, some people may find interesting to implement MERGE as a SQL command. I am looking forward to trying UPSERT and would like to test some analytic functions definitely.

Use of Solution

I've been using v9.4 for a half year. I also have experience with previous versions of PostgreSQL. Currently we have PostgreSQL 9.4.7 on Fedora Server 23 and PostgreSQL 9.4.5 packaged by EnterpriseDB (EDB) on Windows 10 Pro.

Deployment Issues

I had trouble with the reinstallation of EDB. If I have a previous version on my Windows PC, I have to take some steps to clean the registries and folders, then everything is OK.

Customer Service and Technical Support

Customer Service:

If you are interested in you can find answers for troubleshooting. Many companies, I have mentioned above, are there for service and support. I didn’t find any big bug in the latest stable release over the last few months.

Technical Support:

If you are interested in you can find answers for troubleshooting. Many companies, I have mentioned above, are there for service and support. I didn’t find any big bug in the latest stable release over the last few months.

ROI

I recommend Linux installation, but it is also possible to use Windows. With PostgreSQL you don't have to pay much money which is a good advantage. You have to take into account that you will spent some time finding out how to implement something or what is the right tool you have to use.

Pricing, Setup Cost and Licensing

PostgreSQL is a long-lasting investment for people who like computers and don’t want to spent much money for database layer implementation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user