Wij helpen bedrijven al 18 jaar
betere software te kiezen

Over PostgreSQL

Gratis open source post-relationeel databasesysteem. Toonaangevende keuze door ontwikkelaars en DBA's wereldwijd. Robuust, veilig, hoge prestaties.

Meer informatie over PostgreSQL

Pluspunten:

The price vs others other there ie, MSSQL is a lot better. It is able to capture and process data very quickly.

Minpunten:

If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize.

Beoordelingen van PostgreSQL

Gemiddelde score

Gebruiksgemak
4,3
Klantenservice
4,1
Functies
4,6
Prijs-kwaliteitverhouding
4,7

Waarschijnlijkheid van aanbeveling

9,0/ 10

PostgreSQL heeft een totaalscore van 4,6 van 5 sterren op basis van 412 gebruikersreviews op Capterra.

Heb je PostgreSQL eerder gebruikt?

Deel je ervaringen met andere softwarekopers.

Reviews filteren (412)

Samuel Isaí
Samuel Isaí
Full stack developer in Mexico
Geverifieerde LinkedIn-gebruiker
Computersoftware, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Sql managment for everyone

5,0 2 maanden geleden Nieuw

Opmerkingen: I have used postgresql to create difficult subqueries, the implementation is easy and scalability is a game changer.

Pluspunten:

subqueries and json native compatibility is a game changer

Minpunten:

It uses more resources than other Sql Managers and it´s difficult to undertant the unique features when I started using it.

Arjun
Arjun
Founder in VS
Geverifieerde LinkedIn-gebruiker
Computersoftware, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

The Reliable Workhorse with Infinite Flexibility

5,0 2 jaar geleden

Opmerkingen: Nothing short of exceptional. It covers all the bases with its reliability and performance, and its flexibility is unmatched. I've found it difficult to recommend any other database unless you have specific requirements, such as a document store or a graph database. Postgres fills in all the gaps and has become my go-to choice for any project that requires a rock-solid, flexible relational database.

Pluspunten:

does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project.

Minpunten:

No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right.

Ana
Ana
Security Architecture Discipline leader in Spanje
Geverifieerde LinkedIn-gebruiker
Bankwezen, 10.000+ werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Relational database with less capability

3,0 3 jaar geleden

Opmerkingen: It is used when a commercial partner vendor introduces a commercial system and creates a small-scale system. If you connect multiple units, it is easy to use with a response that can support the operation without installing a dedicated server machine. When using packaged software in a large-scale system, there may be restrictions on the number of data elements and the number of servers connected, but we were able to reduce installation and operation costs. I was able to keep the cost of the database low and spend money on packaged software options.

Pluspunten:

Since it was developed to comply with SQL standards, there are no problems migrating from other RDBMS. I think the popularity of MySQL as an RDBMS is split in two, but PostgreSQL does not have the following MySQL keylogging problem, so it can be said that it is an RDBMS with little custom. We recommend PostgreSQL as the first choice for RDBMS unless otherwise specified because it works stably and can support real operations. When a small business is a customer's system project, the RDBMS license fee is often too high to pay. In such cases, customers will be happy to propose PostgreSQL, which is stable, reliable, and free to use. Unless it is a situation that requires a paid database, I think PostgreSQL is sufficient. It is not inferior to the function.

Minpunten:

When you are looking for something you want to look up in a manual, it is often difficult to find it and, in the end, you often consult blog articles written by experts instead of the manual. I want the structure of the manual to be easy to understand.

Leslie
Student in VS
Informatietechnologie en -diensten, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

Reliable and Helpful

5,0 3 maanden geleden

Opmerkingen: Really helpful, easy to jump into and start practicing with.

Pluspunten:

Multiple different ways to view and find data.

Minpunten:

The diagram feature isn't as customizable as I would prefer.

Lindokuhle
Developer in Zuid-Afrika
Informatietechnologie en -diensten, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

My Go-To RDBMS

5,0 vorig jaar

Pluspunten:

It is fast, reliable and scalable; the perfect RDBMS in my humble opinion.

Minpunten:

The learning curve, but even that wasn't actually so bad.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Duurzaamheid en milieu, 11-50 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Eerder overwogen alternatieven:

PostgreSQL Review

5,0 vorig jaar

Opmerkingen: I highly recommend PostgreSQL, i have been using it at work and at the university

Pluspunten:

First, it is open source and wildly used database, it is customizable and scalable

Minpunten:

It does not contain a customer service because it is open source but of course you can find ur answers on the internet and platforms

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Eerder overwogen alternatieven:

PostgreSQL for Database

5,0 vorig jaar

Pluspunten:

PostgreSQL is one of the most popular choice for Database now and it becomes more popular as many people and companies starting to use it. PostgreSQL has great features and performances, so I'd like to recommend PostgreSQL to those who needs a reliable RDBMS.

Minpunten:

One thing that i dislike from PostgreSQL is it's hard to setup and install PostgreSQL at the beginning. Especially the syntax and command that PostgreSQL use.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computersoftware, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Reliable and performant RDBMS

5,0 vorig jaar

Pluspunten:

Much better performance and consistency vs other RDBMS, eg MySQL. It doesn't hide the complexity beyond being a DBA, which is kind of a double edged sword.

Minpunten:

Manual intervention needed for version upgrades, but nothing terrible.

Joseph
Joseph
Senior Engineer in Kenia
Geverifieerde LinkedIn-gebruiker
Civiele techniek, 51-200 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Agrxis Review on PostgreSQL

5,0 2 jaar geleden

Opmerkingen: I can state with confidence that PostgreSQL has exceeded my expectations as a database management system based on my whole experience with it. I strongly rely on PostgreSQL as a data-driven professional to store, retrieve, and analyze massive volumes of data. PostgreSQL's adaptability and scalability have been crucial in meeting our expanding data demands. The knowledge that our important information is safe thanks to the secure data storage capabilities gives us piece of mind. Additionally, we have avoided possible data loss situations thanks to the backup and recovery tools. One of PostgreSQL's unique advantages is its support for several programming languages, which has enabled us to collaborate easily with other development frameworks. The query performance was identified and optimized with the use of the performance analysis tools, resulting in effective data retrieval. The ability to import and export data has also made it simple to move data between platforms. Overall, PostgreSQL has exceeded my expectations, and I heartily endorse it to anybody looking for a solid and dependable database management system.

Pluspunten:

In my experience with PostgreSQL, its adaptability and dependability as a database management system were its strongest points. I like PostgreSQL's broad range of features and capabilities as a data specialist. In order to satisfy the various data requirements of our firm, it has been essential to be able to manage enormous datasets, conduct sophisticated queries, and support advanced data types. The versatility it offers with its support for several programming languages, which enables us to smoothly incorporate PostgreSQL into our current tech stack, is something I personally enjoy. The performance analysis tools have been crucial in improving query execution and system performance as a whole.

Minpunten:

My least favorite aspect about PostgreSQL was the steep learning curve and complexity involved in setting it up and configuring it. I haven't used database management systems for very long, so navigating PostgreSQL's installation and configuration options proved to be a challenge. I had to spend more time and effort learning the many PostgreSQL-specific concepts and settings.

Serhat
Serhat
Senior Software Developer in Turkije
Geverifieerde LinkedIn-gebruiker
Bankwezen, 10.000+ werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

High Performance

5,0 2 jaar geleden

Pluspunten:

One of my favorite features is that PostgreSQL can be learned quickly and easily because there are many resources, it has high performance, it can easily handle very large data operations and high instantaneous transaction loads.

Minpunten:

There is no feature that I do not like. I've done everything I want so far. I am satisfied.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computersoftware, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

The right database for 95% of use cases

5,0 5 jaar geleden

Opmerkingen: Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search.

Pluspunten:

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data. - Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time. - The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned). - Newer versions even has support for advanced use cases such as arrays and JSON objects. - The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

Minpunten:

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Powerful database

5,0 4 jaar geleden

Opmerkingen: Excellent database engine with a lof of features and great overall performance. It has a very huge community so you could get help very easily. I'd recommend to use it.

Pluspunten:

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

Minpunten:

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Bankwezen, 10.000+ werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

PostgreSQL is the best open source database

5,0 5 jaar geleden

Opmerkingen: I used another database for a large Brazilian bank. It was not a free database. The migration was excellent.

Pluspunten:

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Minpunten:

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

Vin
Development Manager in Australië
Informatietechnologie en -diensten, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

Fully tried and tested.

5,0 3 jaar geleden

Opmerkingen: Really well supported by the open source community.

Pluspunten:

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Minpunten:

Cloud pricing tend to be more expensive vs mysql option.

Pranav
Senior Consultant Development in India
Computersoftware, 5.001-10.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Best choice for Relation Databases

5,0 2 jaar geleden

Pluspunten:

It provides additional data types than traditional MySQL database. Easy deployment and faster write operation with massive dataset really makes it best choice among the open source RDBMS.

Minpunten:

No major cons, I faced as of now for PostgreSQL

Brunei
Brunei
Développeur Full Stack in Frankrijk
Geverifieerde LinkedIn-gebruiker
Computersoftware, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

PostgresSQL Review

5,0 2 jaar geleden

Pluspunten:

PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution.

Minpunten:

PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out.

Ryan
Ryan
Marketing Analytics Engineer in VS
Geverifieerde LinkedIn-gebruiker
Marketing en reclame, 501-1.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

PostgreSQL is an industry standard for data science

5,0 2 jaar geleden

Pluspunten:

I like that it is easy to learn, that there are lots of good tutorials, and lots of opportunities to practice. I use PostgreSQL almost daily in my job as a data scientist

Minpunten:

There are some weird minute differences between the different versions of SQL.

Pinki
Pinki
Technical Consultant in India
Geverifieerde LinkedIn-gebruiker
Computersoftware, 51-200 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Best RDBMS for microservice structure

4,0 2 jaar geleden

Opmerkingen: Its been very good experience to use postgres. Very easy and very effective to manage data. As we have microservice architecture so need lots of database of individual services and with postgres we reduces cost of licensing.

Pluspunten:

This is very easy to use and manages. Easy to handle JSON data type and having lots of data type available. Table partitions available for increasing performance.

Minpunten:

Creating store procedure are still very complex and not good as compare to sql server.

Solomon
Web Developer in Nigeria
Computersoftware, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

PostgreSQL is lighter than Mysql, but it can be a little difficult to set up.

4,0 2 jaar geleden

Opmerkingen: PostgreSQL is a powerful and reliable relational database management system, however, its setup and configuration can be complex, and it may not perform optimally in certain high-speed or large-scale data processing scenarios. Despite this, it offers advanced data management and security features, and it supports data replication and backup/recovery

Pluspunten:

PostgreSQL is a powerful and reliable open-source relational database management system. It offers advanced data management and security features, such as table partitioning, data encryption, and role-based access control. Additionally, it has powerful SQL query language that enables complex and efficient data retrieval, and it supports data transformation through the use of SQL functions and stored procedures. It also supports data replication and backup/recovery. Overall, I highly recommend PostgreSQL for anyone in need of a robust and secure relational database management system

Minpunten:

PostgreSQL can be a bit complex to set up and configure, especially when compared to other databases. Additionally, it may not be the best option for certain high-speed or large-scale data processing scenarios. Its performance can also be affected by poor query design and a lack of proper indexing.

Limuel
Limuel
Senior Data Analyst in Filipijnen
Geverifieerde LinkedIn-gebruiker
Marketing en reclame, 501-1.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Very user-friendly and supports a wide range of query formats

5,0 2 jaar geleden

Pluspunten:

It supports a wide range of query syntax and is the most user-friendly software.

Minpunten:

There are way too many reserved keywords. Because of reserved keyword restrictions, we are unable to choose meaningful column names with this many keywords.

Alec
Solutions Architect in VS
Vervoer/over de weg/per spoor, 51-200 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Best Open Source Enterprise Grade Database

5,0 2 jaar geleden

Pluspunten:

how easy it is to use, install, and deploy on any OS. Enterprise grade open source software!

Minpunten:

There are no major cons that I can think of.

Carlos Hugo Martin
Consultor in Peru
Informatietechnologie en -diensten, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

Experience with PostgreSQL

5,0 3 jaar geleden

Opmerkingen: We have used the database for the implementation of reporters in most cases, seeking to remove the load from the main database.

Pluspunten:

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

Minpunten:

There are functionalities that with third-party products can obtain better results.

Mark
Mark
Vice President of Information Technology in VS
Geverifieerde LinkedIn-gebruiker
Marktonderzoek, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

Solid database that won't break the bank and won't let you down

5,0 4 jaar geleden

Opmerkingen: We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero!

Pluspunten:

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

Minpunten:

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computersoftware, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

PostgreSQL Review

5,0 2 jaar geleden

Opmerkingen: I have used Postgres in many projects, it is generally preferred that it is open source. It is also very successful in data consistency. Since it is compatible with many programming languages, it is easier to integrate with another tool or to use when you switch to a different language compared to other RDBMS.

Pluspunten:

Being open source is a huge plus. It is quite reliable in terms of data consistency.

Minpunten:

Memory usage is bad compared to other RDBMS.

Malik
Malik
Data Analyst in VS
Geverifieerde LinkedIn-gebruiker
Research, 10.000+ werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

PostgreSQL

5,0 3 jaar geleden

Pluspunten:

It is a good Software for those who need SQL.

Minpunten:

It can sometimes take a while to compile and have errors like all programming softwares.