PostgreSQL Other Advice
Chethan Rao S
Software Engineer at Medflix
Postgres is a very performance-based database. It is an all-in-one tool. You can use it as an SQL database or as a NoSQL database. They do have a data type called JSONB. You can use some part of it in a hybrid NoSQL database or as a key-value-based DB. They do have a good number of plugins. So if they have to extend the capabilities, they have a wide variety of plugins. Depending upon use cases, you can use them. For example, to do some cron jobs, you have a plugin called pg_cron, and you can use PostGIS for geospatial applications. PostGIS is a very awesome thing to work with.
Overall, I rate the solution a nine out of ten.
View full review »KS
Kerstin Stefani
Senior Analyst Applications, Projects and Processes at ADVA Optical Networking Israel LTD.
I started with PostgreSQL version 8, and currently, I have version 15. I would recommend PostgreSQL to other users.
Overall, I rate PostgreSQL a nine out of ten.
Ahmed-Ramy
CEO at TMentors
We are just customers or end-users.
I'd rate the solution at a seven out of ten. It is something in the middle between MySQL and SQL Server.
View full review »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.
768,740 professionals have used our research since 2012.
Moises Nájar
Executive Director at Extware Consulting
Albert Lacerda
Managing partner at Dynamis Informatica
I would rate the solution a nine out of ten. PostgreSQL is an open-source enterprise-grade product and is available free of cost. The tool doesn’t have a big company behind it. The solution is very well documented and you can find a lot of information from the community. The solution is a good product compared to MySQL. People have been moving away from MySQL ever since it became an Oracle product.
PostgreSQL can handle heavy loads. I follow some of the most important DBA professionals in the industry and they are using this product. This tool is a rock-solid product and the most advanced relational database software that is open source.
Some open-source solutions have a restriction on the license but there are no problems when commercial applications use the solution. You cannot use a commercial product with open-source solutions that have license restrictions.
View full review »RK
reviewer2097999
Geologist at a government with 10,001+ employees
We do not use the product for web application development. The management decided to use the product. I recommend the tool to others. If the data format is okay, we will face no problem using the tool. Overall, I rate the solution a nine out of ten.
View full review »SE
Saman Raf
Software developer at MTNIrancell
If you need a relational database, the product is a good fit. However, it is complicated to scale for large data. I rate PostgreSQL a nine out of ten.
View full review »NP
reviewer1599825
System Architect at a university with 1,001-5,000 employees
I rate PostgreSQL eight out of 10.
PB
reviewer1161609
System Architect at a computer software company with 10,001+ employees
I would recommend this solution to others who are considering using it.
I would rate PostgreSQL a nine out of ten.
View full review »
Hazel P.
Data Quality Engineer at Nidec Corporation
Overall, I rate PostgreSQL an eight out of ten.
View full review »
Ashif Shaikh
Senior Database Administrator at a tech services company with 501-1,000 employees
The advice would be to go with a managed Postgre. If you're going to install Postgre in the cloud, for example, it's better to go with a managed Postgre rather than handling everything on our own.
I would rate PostgreSQL a nine out of ten.
View full review »DE
reviewer1089354
System/Security Engineer at a tech services company with 10,001+ employees
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.
View full review »
it_user442602
Sr. Database Engineer at a non-tech company with 5,001-10,000 employees
If you can, do it!
View full review »AM
Ariful Mondal
Global Data Architecture and Data Science Director at FH
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.
View full review »
Faustine Chisasa
System Administrator at TZ Telecom Ltd.
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.
View full review »
Hardik Parashar
Associate Data Engineer at Digit Insurance
We are just a customer of Postgre.
Since the data volume has increased rapidly, we are concerned Postgre won't be suitable for our long-term requirements. We're currently looking for an all-in-one option.
I'd advise users that are not looking for speed or do not have huge amounts of data to try this solution.
I'd rate the solution at an eight out of ten.
View full review »NK
NaveenKumar21
Senior IT Manager at Excelra
We are simply a customer and end-user. We don't have a business relationship with PostgreSQL.
The solution is deployed both on the cloud and on-premises. We use more than one deployment model.
I can't recall the exact version number we are using, however, it's my understanding that it is not necessarily the latest version.
I'd recommend this product to other organizations. It's worked well for us so far.
In general, I would rate the solution at an eight out of ten.
View full review »KA
reviewer1425756
Chief technical officer at a healthcare company with 51-200 employees
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.
View full review »MR
reviewer1442025
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
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.
View full review »PG
reviewer1593588
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
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.
View full review »KÇ
Kaan Çelik
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
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.
View full review »MS
reviewer1428423
Head of Technical Support at a real estate/law firm with 51-200 employees
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.
View full review »SJ
reviewer936300
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
I rate PostgreSQL an eight out of ten.
View full review »SP
reviewer1644435
IT Systems Administrator at a transportation company with 51-200 employees
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.
View full review »DI
Dimitris Iracleous
Lead Technical Instructor at codehub
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.
MA
Maurice Aelion
Senior DBA & IT Consultant at MA Consulting
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.
View full review »it_user457323
Senior Database Engineer at a consumer goods company with 1,001-5,000 employees
There are some features missing compared to other RDBMS. The community is always expanding and more and more people use PostgreSQL every day. There are many forums where you can get information from and there are many different ways to contribute.
View full review »it_user456468
Senior DB Engineer at a university with 1,001-5,000 employees
Besides the simple fact of being an open product that can be used at virtually no cost, the quality of the code base is extremely good. The development process is transparent and the documentation is, with its 3000+ pages in the pdf format for version 9.5, exhaustive and complete. The community is very active and open to suggestions.
View full review »it_user457146
Co-Founder, CTO at a computer software company with 51-200 employees
PostgreSQL is the world's most advanced and performant SQL database available. It essentially beats out MySQL, Oracle, SQL Server, and often MongoDB on virtually every use case.
View full review »it_user212523
TIBCO Middleware Architect & System Administrator at a tech services company with 1,001-5,000 employees
PostgreSQL is a great product, very mature and is evolving into other areas beyond SQL, in this times of connected devices and big data analytics, PostgreSQL can still be considered one of the key components and works very well with others. Being reliable is still one of the best ways to get a good ROI.
View full review »EK
reviewer1601793
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
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.
View full review »HP
hugodpereira
Computer engineering student at a educational organization with 501-1,000 employees
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.
View full review »JT
Jason Tumusiime
Software Developer at a healthcare company with 1-10 employees
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.
View full review »it_user494835
Founder and CEO at Shreeyansh Technologies | The Database Company
I strongly recommend this product, with no recurring licensing liabilities with community support and with optional commercial support available. Shreeyansh Technologies provides various quality database services in 24X7 model to support our global customers.
View full review »it_user86943
Senior Developer with 501-1,000 employees
It's go good reliability and is very compliant with standards. If you are installing relational DB you likely know how to use one. If you're not familiar with RDBMS's make sure you look into and use the features of the DB like views etc. They all serve a purpose and will improve your development if leveraged properly.Huge feature set.
View full review »it_user234651
Senior Software Engineer, Technical Lead at a tech services company with 51-200 employees
This is a very good product, and I'm very pleased, especially with the latest versions. I haven't found the perfect database yet, but definitively PostgreSQL is a candidate to consider, especially if you take into account that comes for free and is open source.
I had many debates about PostgreSQL and I've never seen yet someone getting to know it and complaining about it. It simply helps and works, but you have to be good at it. Going for commercial solutions might bring serious costs and a feeling of confidence, but this database is not only for try or start, it's reliable and well done.
RU
reviewer1524594
Senior Solutions Architect at a manufacturing company with 51-200 employees
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.
View full review »KV
Karel Van Der Walt
Data Architect at ACPAS Loan Management Software
I would 100% recommend this solution to others. I would rate PostgreSQL a nine out of ten.
View full review »DZ
Daniel Alejandro Zuleta Zahr
Developer at a tech services company with 11-50 employees
At basic levels the database won’t do much difference, focus first in learning how to build queries properly, create index, etc.
An image of our product achieved with Full Text Search.
it_user130935
President with 51-200 employees
PostgreSQL is a great SQL database, powerful, flexible, but it is not something to be considered over other things. The most important issue for a database, if what back end do your mission critical front ends support. With PostgreSQL we found next to nothing we would not do with other open source applications.
View full review »it_user464529
CEO at a tech services company with 51-200 employees
I would recommend PostgreSQL to anyone who wants to save costs and deploy a reliable enterprise class database server.
View full review »it_user457224
Partner - PostgreSQL support manager at a tech company with 51-200 employees
Ask the community. I believe any committed PostgreSQL user will be happy to help and provide advice.
FA
Florent ADODO
IT Assistant at Hotel 2 Fevrier
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.
View full review »it_user493518
Director of Operations / Senior Software Engineer at a computer software company with 51-200 employees
PostgreSQL is an amazing product. Very easy to implement and there are many libraries to make it easy to use PostgreSQL as a back-end database solution, no matter what coding language you are using.
View full review »it_user457197
Senior PostgreSQL Database Adminstrator at a financial services firm with 51-200 employees
PostgreSQL is an enterprise capable database very similar to many commercial offerings, but be prepared to either pay for consulting or a long period or experimentation to get the configuration proper.
View full review »it_user67833
Software Engineer at a tech vendor with 11-50 employees
It's a great database engine that is easy to use, powerful, and scalable.
View full review »it_user434985
Sr. Database Architect at a tech vendor with 501-1,000 employees
If you don’t have experience with PostgreSQL, I recommend to attend some of the local PostgreSQL user group meetups and/or conferences to learn how it is being used. If you need help discussing about the solution, you can reach to any of the Postgres consulting services company.
View full review »it_user254172
Senior Consultant / Manager Technical Operations at a tech consulting company with 501-1,000 employees
- Positive - 100% free as it's open source
- Negative - it's hard to find expertise
If you are planning to migrate an existing environment, please go through with the full UAT cycle at data, connectivity, objects and apps level.
View full review »SS
reviewer938901
Software Engineer at a computer software company with 10,001+ employees
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.
View full review »DM
Danilo Martins
Developer at a comms service provider with 51-200 employees
PostgreSQL has extensive and comprehensive documentation. Chances are that you'll find your answers there for 99% of the cases. For those answers you don't find, you can always go to StackOverflow. If you're not a DBA or a programmer, I'd suggest hiring external help, as with all the cases with databases (RDBMS or not).
View full review »it_user140712
Consultant at a tech consulting company
Explore this new world. PostgreSQL has taken a quantum leap over the last 20 years, and now it seriously threatens more established database vendors.
View full review »
Ruben Conti
Owner at Intersoftware sas
I rate PostgreSQL eight out of 10. I would definitely recommend it.
View full review »PA
reviewer1598691
Project Manager at a comms service provider with 201-500 employees
I would recommend PostgreSQL to others who are interested in using this solution.
I would rate PostgresSQL a seven out of ten.
View full review »LW
reviewer1481757
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
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.
View full review »it_user249057
Software Engineer at a tech services company with 51-200 employees
Try it out! Sometimes, due to the high degree of configurability and extensibility, you might see some issues arise, but it's not that difficult to figure out what's happening. You will definitely be amazed by the SQL features and extensibility.
View full review »RS
reviewer1734405
Head Channel and Capacity at a computer software company with 201-500 employees
it_user457251
Data Architect at Blue Treble Solutions
Always hire an expert to advise you on production database deployment. Similar to security, mistakes in this area have the potential to seriously impact your business. Postgres is free, but it can be difficult to hire experienced PostgreSQL people. There is a silver lining to that, as if you can find someone with five to 10 years experience then odds are very good and very dedicated to their craft and aren't interested in just punching a clock. You can certainly find those types of people for other products, but relatively speaking they're much rarer.
View full review »it_user441456
Senior Database DevOps Engineer at a tech services company with 1,001-5,000 employees
Get a dedicated, PostgreSQL-focused resource, it's hard to convert DBAs with background in other denominations.
View full review »it_user268557
Chief Data Officer at a university with 5,001-10,000 employees
It is a superb database. What keeps it from being 10/10 is a lack of analytics specific optimizations.
View full review »it_user252288
Software architect at a tech services company with 51-200 employees
My advice is to read documentation thoroughly and don't be afraid to look into source code. A great source is https://momjian.us/main/presentations/overview.html
View full review »it_user127413
Director GIS/Analytics/IT at a non-profit with 501-1,000 employees
So far we have not had any issues with this database are we are using this in development and production systems.
View full review »it_user306153
Senior Programmer at a tech services company with 51-200 employees
It does what it's supposed to do, as simple as that. We don't regret any choosing this solution.
View full review »it_user298746
NOC Manager with 51-200 employees
Ensure its a good fit for the application you are using and integration you may have planned. Review all documentation prior to moving forward and always test the new versions before just cutting over.
View full review »it_user241635
DevOps Engineer at a transportation company with 51-200 employees
Just read the comparisons between different database engines, and read some documentation so you can exploit most of the powerful tools and functions it has.
View full review »it_user184266
Database Expert at a tech services company with 51-200 employees
I'd say go for it. It is stable, and easy to use but you should get an understanding of it to implement backup strategy.
View full review »
Sundaresan Subramanyan
Founder and Managing Director at Analytic Brains Technologies Private Limited
We recommend PostgreSQL for our customers who want an open-source solution.
I would rate this solution an eight out of ten.
View full review »RP
reviewer1362969
IT Specialist at a government with 1,001-5,000 employees
I would recommend this solution to others.
I rate PostgreSQL an eight out of ten.
View full review »it_user437376
PostgreSQL Database Administrator at a tech services company with 51-200 employees
PostgreSQL is an amazing product, very stable, predictable and reliable with rich set of features.
View full review »it_user315483
Programador - Analista at a program development consultancy with 501-1,000 employees
Currently this is one of the best solutions on the market. It is a tool without cost, powerful, easy to learn and with a large active community.
View full review »it_user308454
Sysadmin at a tech services company with 51-200 employees
Be patient! Like most open source tools, this requires commitment and a little knowledge.
* pg_hba.conf
* A fragment from postgresql.conf
* How to access to database-server using psql client, and create a database
Create a user/role and be owner for a database. We can list all databases with "\l".
it_user360699
Platform Developer at a tech vendor with 51-200 employees
The last few versions work great out of the box without much config changes. Don't be afraid to try it.
View full review »it_user448368
DBA / ETL Developer / Consultant at a marketing services firm with 1,001-5,000 employees
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.
View full review »it_user246798
Director of Client Integration at a financial services firm with 51-200 employees
The challenge with this product would be finding the IT resource that can implement the product.
View full review »NB
NikolayBachvarov
Software Architect at AIOPS group
I would rate this solution as seven out of ten.
View full review »VR
reviewer1519272
Full Stack Developer at a tech services company with 10,001+ employees
I rate PostgreSQL a seven out of ten.
View full review »it_user457314
Sr. Oracle and PostgreSQL DBA at a consumer goods company with 1,001-5,000 employees
Do continuous testing and research on new features as they have an excellence performance response.
View full review »it_user210627
Computer Science Teacher at a educational organization with 501-1,000 employees
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.
View full review »it_user234753
Team Lead ETL at a tech services company with 51-200 employees
If you are thinking of using PostgreSQL, all database names, table names and column names should be in small letters. PostgreSQL requires every capital letter to be quoted which makes life difficult for developer.
View full review »it_user250818
Owner with 51-200 employees
We have no regrets and are satisfied with it. I would advise you to go ahead and implement it.
View full review »
KopanoRamaphoi
Consultant at Rpc Data
I recommend this solution for small organizations.
I rate PostgreSQL a seven out of ten.
View full review »JP
reviewer1490673
Principal Engineer at a manufacturing company with 201-500 employees
I would rate PostgreSQL an eight out of ten.
View full review »RM
reviewer1353249
Director at a tech services company with 1-10 employees
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.
View full review »it_user514974
CTO at a tech vendor with 51-200 employees
Explore all the features.
View full review »it_user495012
Chief Data Architect at a tech company with 51-200 employees
Get some expert help; I cannot stress this enough. We often walk into DB setups and architectures that are a wreck because the team "knew enough to be dangerous". Even more often, we see database isolation, meaning the DB is not connected to the enterprise data architecture. That mistake leads to expensive problems down the road.
It's an open-source, license-free product that can go head to head with the likes of Oracle & DB2 and hold its own in terms of features and performance, in many cases beating the competition.
View full review »it_user262230
Front-End Developer at a financial services firm with 501-1,000 employees
Compare and contrast various database optimizations based on your needs. And when you come across issues, don't reinvent the wheel -- someone has probably had a similar problem to your own.
View full review »it_user268431
Specialist of Information Security at a transportation company with 1,001-5,000 employees
PostgreSQL is a perfect database to be used by small to mid-sized companies. Many years ago when I worked with medium companies I would have given it a 10/10 but as the database community has grown, it has decreased.
View full review »it_user330576
Senior Software Engineer at a tech services company with 1,001-5,000 employees
It's the best in my opinion because have now found what I need to enable me to quickly deploy into my production environment. Go to a professional and ask for your needs, maybe you will surprise with a variety of solutions that you never thought existed.
View full review »it_user389811
Co-Founder, Technical Manager, Consultant at a hospitality company with 51-200 employees
Read the documentation.
View full review »DR
Diego Rosales
Implementation Engineer at aldaris spa
I would rate PostgreSQL a ten out of ten.
View full review »it_user219786
Founding Partner at a tech vendor with 1-10 employees
PostgreSQL is one of the most stable data sources out there, and it offers you the most advance and modern functions on SQL so you can do more with less.
View full review »it_user312354
Software Architect and Senior Technology Consultant at a tech services company with 51-200 employees
It is a good free RDBMS. It's stable, scalable and reliable.
View full review »it_user209280
Senior Developer at a tech services company with 1,001-5,000 employees
Well worth the effort! I've been using it in my professional capacity without a single incident.
View full review »it_user389220
CEO - Software Engineer at a tech services company with 51-200 employees
Analyze very carefully the hardware requirements.
View full review »it_user373887
Senior Software Engineer at a tech services company with 51-200 employees
I'd recommend reading Greg Smith's PostgreSQL High Performance.
View full review »it_user5931
Developer at a university with 51-200 employees
I cannot stress how highly I recommend PostgreSQL to my fellow programmers. The features and functionalities are beyond the abilities of other free database platforms and are comparable to the proprietary ones. Some advanced features may also be seen to the license databases but you’ll amaze how advance PostgreSQL may become in the future but in zero cost.
View full review »
it_user439254
Expert Web Developer at a tech vendor with 501-1,000 employees
I think this is the only decent solution for a relational database in web development.
View full review »it_user494907
Big Data Consultant at a tech services company with 1,001-5,000 employees
So far, it’s the best database I have ever used.
View full review »it_user145641
Business Analyst at a transportation company with 1,001-5,000 employees
I suggest to anyone give it a shot. It'll make your business grow.
View full review »
it_user89940
Database Expert with 201-500 employees
Employ a DBA to work together with the developers.
View full review »
it_user1227
Tech Support Staff at a tech company with 51-200 employees
PostgreSQL is one of the best open source DB storage application which supports only one backend storage engine. PostgreSQL is well known for the number of features it supports and the standards followed. PostgreSQL is pretty slow when dealing with queries like COUNT(*) and many of the queries like 'INSERT IGNORE', which inserts if a row doesn't exist, and 'REPLACE' which replaces the current row. It is also limited to 32 columns per index. If you are looking for a speed, then you have to look for other DB engines available e.g. MySQL.
View full review »
it_user183585
BI Expert at a consultancy with 501-1,000 employees
Go ahead with the product which has the best use case for your organization. Cost is never an issue.
View full review »it_user12048
Digital Development Engineer at a comms service provider with 1,001-5,000 employees
Because we use it in many information systems (Financial, Human Resources, Inventory Management) in several large companies with significant data flow, we have not had problems. It was effective as a product.
Read the product documentation well and know the configuration parameters because just one incorrect parameter can affect the entire database.
it_user10449
Developer Advocate (PaaS Dust Spreader) at a tech vendor with 5,001-10,000 employees
Get a good book so you can get exposed to all the great functionality in PostgreSQL. I would highly recommend looking at the postgresql.conf configuration settings when you are ready to go into production.
View full review »it_user417285
Senior Production Support Engineer at a tech company with 501-1,000 employees
Use it, to change the default database, it's a good option.
View full review »it_user1077
Developer at a tech company with 51-200 employees
Great Documentation, active community support, excellent management & development tools and availability on various platforms makes PostgreSQL a good data base management system.
View full review »
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.
768,740 professionals have used our research since 2012.
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: April 2024
Popular Comparisons
MySQL
MariaDB
Firebird SQL
EDB Postgres Advanced Server
SQLite
Faiss
Percona Server
Chroma
YugabyteDB
OpenSearch
LanceDB
Oracle MySQL Cloud Service
Weaviate
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More:
- Primary Use Case
- Valuable Features
- Room for Improvement
- Customer Service and Support
- Initial Setup
- ROI
- Pricing
- Other Advice
- What is the best GUI tool for development and management of a PostgreSQL database?
- How does Firebird SQL compare with PostgreSQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
- Why is Open Source Databases important for companies?
