2020-11-06T07:13:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 0
  • 3

What advice do you have for others considering PostgreSQL?

If you were talking to someone whose organization is considering PostgreSQL, what would you say?

How would you rate it and why? Any other tips or advice?

26
PeerSpot user
26 Answers
SS
Software Engineer at DXC
Real User
Top 5Leaderboard
2022-02-16T09:06:03Z
Feb 16, 2022

PostgreSQL is for personal use, e.g. I've been using it for my applications. It's deployed on cloud. I'm not from the core database team, so whatever features are currently provided by this solution, I'm happy with them, e.g. PostgreSQL is fulfilling my needs. Our database administrators will be able to provide more information on areas for improvement for this solution, because they know all the ins and outs of the database. I'm using this for my application, and I have not faced any issues with it. I'm part of a global company, and in our team, we keep recommending PostgreSQL to our client, but increasing the usage of this solution depends on the client, e.g. the one who pays. We have more than 200,000 users of PostgreSQL. In my project, I don't need a technical team for the deployment and maintenance of this solution, e.g. I can do it myself, but for other projects, deployment and maintenance could be handled by database administrators. On a scale from one to ten, I'll rate PostgreSQL seven out of ten.

Search for a product comparison
Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting
Real User
Top 5
2022-01-25T17:22:46Z
Jan 25, 2022

I would recommend this solution to others. I rate PostgreSQL a ten out of ten.

DE
System/Security Engineer at a tech services company with 10,001+ employees
Real User
Top 5
2021-12-04T04:30:12Z
Dec 4, 2021

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.

RS
Head Channel and Capacity at a computer software company with 201-500 employees
Real User
Top 5
2021-12-02T11:09:25Z
Dec 2, 2021

I would recommend this solution to others. I rate PostgreSQL a nine out of ten.

NB
Senior Software Engineer at Endava
Real User
Top 5Leaderboard
2021-11-30T14:04:00Z
Nov 30, 2021

I would rate this solution as seven out of ten.

NP
System Architect at a university with 1,001-5,000 employees
Real User
2021-10-22T09:13:54Z
Oct 22, 2021

I rate PostgreSQL eight out of 10.

Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
653,757 professionals have used our research since 2012.
SJ
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
Real User
Top 5Leaderboard
2021-10-21T07:46:43Z
Oct 21, 2021

I rate PostgreSQL an eight out of ten.

Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas
Real User
Top 5
2021-10-05T20:41:00Z
Oct 5, 2021

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

SP
IT Systems Administrator at a transportation company with 51-200 employees
Real User
Top 5
2021-08-26T14:17:25Z
Aug 26, 2021

It is a very good RDBMS, and I'm quite happy with it. It does what it says, and it does it fairly well. I've seen some bits that are stronger in other products and some bits that are weaker in other products. My recommendation would depend on the requirements and the use cases. I would rate PostgreSQL a nine out of 10. It does its job adequately, and I am quite happy with what it does at the moment. You wouldn't hear a 10 from me for any database vendor at the moment.

PG
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
Real User
Top 20
2021-08-17T15:04:30Z
Aug 17, 2021

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.

MS
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Top 5
2021-07-09T11:23:41Z
Jul 9, 2021

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.

RP
IT Specialist at a government with 1,001-5,000 employees
Real User
Top 5
2021-06-18T05:31:41Z
Jun 18, 2021

I would recommend this solution to others. I rate PostgreSQL an eight out of ten.

Dimitris Iracleous - PeerSpot reviewer
Lead Technical Instructor at codehub
Real User
Top 5
2021-06-15T14:22:28Z
Jun 15, 2021

We are not consultants to PotrgresSQL. We are usually consulted when it comes to using Microsoft MySQL Server, since we consider it to be quite robust and to have all the necessary support from Microsoft. Fewer than 10 percent of our customers make use of PostgresSQL. I would recommend the solution to others when when there is a desire to have projects and cost is a concern. I would rate PostgresSQL as an eight out of ten, although this owes itself to personal preference and not to low performance.

hugodpereira - PeerSpot reviewer
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Top 5Leaderboard
2021-05-19T14:16:03Z
May 19, 2021

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.

KR
Information Technology Administrator at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
2021-04-10T07:23:40Z
Apr 10, 2021

I recommend this solution for small organizations. I rate PostgreSQL a seven out of ten.

Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH
Real User
ExpertModerator
2021-03-03T21:38:03Z
Mar 3, 2021

I would definitely recommend this solution. It is a very good database to have. It is also very good as compared to other tools. I would rate PostgreSQL a nine out of ten.

JP
Principal Engineer at a manufacturing company with 201-500 employees
Real User
2021-02-14T14:42:23Z
Feb 14, 2021

I would rate PostgreSQL an eight out of ten.

Faustine Chisasa - PeerSpot reviewer
Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms. Corporation
Real User
Top 5Leaderboard
2021-02-04T21:04:00Z
Feb 4, 2021

For anybody who is considering this solution, my advice is that it is better to do enough research on the specific database engine requirements. I highly recommend PostgreSQL with TimescaleDB extension for time-series data.

Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software
Real User
Top 5
2021-01-23T14:46:33Z
Jan 23, 2021

I would 100% recommend this solution to others. I would rate PostgreSQL a nine out of ten.

LW
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
Real User
2021-01-13T22:09:33Z
Jan 13, 2021

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.

Kaan Çelik - PeerSpot reviewer
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
Real User
Top 5
2020-12-27T09:14:05Z
Dec 27, 2020

We're just customers and end-users. We generally use the last version, as we try to ensure all of our programs are the latest technology. Therefore, we generally use cloud platforms like Amazon or Microsoft, which is Azure. Whichever version is on the cloud, we generally use that version. That said, some of it is on the cloud and some of it is on-premise. In Turkey, we have some legal requirements that require some data to be stored in our country. We have to store it locally. Therefore, we can't use the cloud completely. I'd recommend the solution to other organizations. I would rate the product at an eight out of ten.

KA
Chief technical officer at a healthcare company with 51-200 employees
Real User
2020-12-12T18:23:00Z
Dec 12, 2020

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.

Jason Tumusiime - PeerSpot reviewer
Software Developer at a healthcare company with 1-10 employees
Real User
Top 20
2020-12-07T17:50:00Z
Dec 7, 2020

My advice would be to use PostgreSQL instead of MySQL because of licensing issues. Another reason is that Oracle may remove MySQL soon or add substantial costs to using it It may even turn into something like MariaDB, and then you would need to know if MariaDB and MySQL work the same? PostgreSQL really works well. There are a lot of other databases around right now, but PostgreSQL is the most popular. It is not like a hammer and a nail situation whereby it is the only thing you have to use. If you need a relational database management system, go for PostgreSQL instead of MariaDB or MySQL, then use it side to side. Can also consider other engines out there, like other NoSQL engines, perhaps. I would give it an 8 out of 10. PostgreSQL is not suitable for all types of applications, hence why I gave it an 8 instead of a 10.

RM
Director at a tech services company with 1-10 employees
Real User
Top 20
2020-11-26T08:52:22Z
Nov 26, 2020

I believe we are on version nine of the solution. It's one of the latest versions. I'd advise new users to maybe be aware of the syntax of the sentences of PostgreSQL due to the fact that it's a little different than SQL or Oracle. Overall, I'd rate the solution an eight out of ten. So far, we've been using it and we haven't had any problems.

MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Top 5
2020-11-25T20:46:48Z
Nov 25, 2020

Go ahead and implement it. It is a nice product, but keep a backup and try to use it for small to medium projects or companies. Some of the customers are demanding PostgreSQL nowadays, so we will keep on implementing it. I would rate PostgreSQL an eight out of ten.

Diego Rosales - PeerSpot reviewer
Implementation Engineer at aldaris spa
Real User
2020-11-06T07:13:00Z
Nov 6, 2020

I would rate PostgreSQL a ten out of ten.

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Dec 12, 2021
Which is better and why?
See 1 answer
Dovid Gelber - PeerSpot reviewer
Tech blogger
Dec 12, 2021
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit your database with great ease. This allows you to have the kind of database that you need on a case-by-case basis. Instead of being locked into an inflexible database format, you are in control and dictate exactly what format the database will take at any given time. You can easily manipulate it, which means that you will be able to use PostgreSQL in the way that will help your organization the most. PostgreSQL is also pretty easy to use. Its designers made it so that you don’t have to have an extensive technical education to use it. It is pretty intuitive and has excellent documentation to answer any employee questions. Furthermore, PostgreSQL also offers you a cheap solution whose hosting and maintenance can be handled totally in-house. PostgreSQL’s open-source nature makes it extremely cheap to implement. Resources that might have been spent on setting it up can now be saved and redirected to areas of greater need. Furthermore, the program has two different download options. It can either be downloaded and used on-site or it can be downloaded to the cloud. Both of these allow you to be totally independent. You can host it from your headquarters or access it from anywhere you choose. Firebird SQL offers you the ability to scan your database code and search it for many types of issues. It can also compile reports based on any of the problems that it may find. However, it lacks the flexibility that PostgreSQL offers. It cannot be customized in the same way, which leaves you with fewer options. Conclusion While Firebird SQL is a fairly competent product, we found PostgreSQL to be superior. PostgreSQL’s greater flexibility and dual download options make it the more robust solution.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Mar 2, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 18 answers
MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Nov 25, 2020
It is free. There is no license on it.
RM
Director at a tech services company with 1-10 employees
Nov 26, 2020
I'm not sure what the licensing costs for the solution are.
Related Solutions
Download Free Report
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
653,757 professionals have used our research since 2012.