En savoir plus sur PostgreSQL
Système de base de données post-relationnelle open source gratuit. Le choix de prédilection des développeurs et administrateurs de bases de données dans le monde entier. Robuste, sécurisé et hautement performant.
The price vs others other there ie, MSSQL is a lot better. It is able to capture and process data very quickly.
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.
Filtrer les avis (389)
Utilisation
Classer par
Filtrer les avis (389)

Janne
Alternatives envisagées :
One of the best overall databases in the market
Commentaires : For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.
Avantages :
PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.
Inconvénients :
Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.
Brunei
Alternatives envisagées :
PostgresSQL Review
Avantages :
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.
Inconvénients :
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.

Ana
Relational database with less capability
Commentaires : 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.
Avantages :
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.
Inconvénients :
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.
Ilker
IY_Postgre
Commentaires : It's a very good database application. I use it as a hobby
Avantages :
one of the most successful database applications I have used, its interface is easy and it is nice to open different pages in tab form. I also loved that it included a dark theme.
Inconvénients :
Although the code is correct, it says there is an error when the code is run, sometimes I waste time searching for this non-existent error.
Rishikumar
"PostgreSQL: A Robust and Reliable Database Solution"
Commentaires : Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database system with advanced features for data management and analysis. The active community and comprehensive documentation make it easy to get started and the software is well-suited for a wide range of applications.
Avantages :
PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create custom functions and operators. It also allows scalability, which makes it suitable for handling an increasing amount of data and users. Additionally, it supports ACID properties, which ensures data consistency and integrity in the database. Overall, PostgreSQL is an excellent choice for businesses looking for a powerful and flexible relational database management system, it offers great features that make it a great tool for most of use cases.
Inconvénients :
PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution.
Utilisateur vérifié
A Powerful and Reliable Open-Source Relational Database Management System
Commentaires : Overall, PostgreSQL is a powerful and reliable open-source relational database management system that offers a wide range of features and functionality. While it may be complex to set up and manage, the platform's extensive documentation and community make it an ideal choice for businesses and enterprises that require a powerful and scalable database system. If you're looking for a robust and reliable database system, PostgreSQL is definitely worth considering.
Avantages :
PostgreSQL is a powerful open-source relational database management system that I have used extensively for several projects. I must say that it is one of the best relational database systems available in the market.What I liked most about using PostgreSQL is its reliability and robustness. PostgreSQL is a rock-solid database system that is known for its stability and scalability. It offers a wide range of features, including support for advanced data types, multi-version concurrency control, and full-text search, to name a few. These features make it an ideal choice for businesses and enterprises that require a reliable and powerful database system.Another great feature of PostgreSQL is its extensibility. PostgreSQL supports a wide range of extensions and plugins that can be used to add new functionality to the database system. This makes it easy for developers to customize and extend the database system to meet their specific needs.
Inconvénients :
What I liked least about using PostgreSQL is that it can be complex to set up and manage. The database system has many advanced features, which may be overwhelming for beginners. However, PostgreSQL offers extensive documentation and a large community of developers, making it easy to find solutions to any issues that may arise.
Yann
Good tools for Databases Management
Avantages :
I like the fact that PostgreSQL is an open source relational database management system. This means that it is free to use and the source code is available for anyone to modify and customize. It also has a large community of developers and users who are willing to help out with any problems or questions that may arise. Additionally, PostgreSQL is extremely reliable and secure. It offers a wide array of features, including support for many languages, robust transaction processing capabilities, and scalability. It also offers a wide range of tools for managing, tuning, and monitoring databases.
Inconvénients :
It can be difficult to use and maintain. One of the biggest issues with PostgreSQL is that it is not as user friendly as other relational databases such as MySQL. It can be difficult for inexperienced users to learn and use the more complex features of PostgreSQL.
Hermione
Best Open Source DB
Commentaires : My overall experience with PostgreSQL has been positive. It's a powerful and reliable database that is easy to use and provides a lot of features. I've found it helpful in developing data-driven applications and sites that require a relational database. The SQL syntax is straightforward and it's easy to configure and maintain.
Avantages :
One of the main reasons I like Postgresql is its capability to store and manage large volumes of data securely and reliably. The SQL language is easy to understand and use, and it can be installed on both Windows and Linux systems with ease. Additionally, there are plenty of tutorials and documentation available, along with regular updates from postgresql.org. What's more, Postgresql is completely free to install and use, so there is no rental fee.
Inconvénients :
Installing and implementing the system can be a difficult challenge, requiring a strong understanding of Linux.

Pinki
Best RDBMS for microservice structure
Commentaires : 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.
Avantages :
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.
Inconvénients :
Creating store procedure are still very complex and not good as compare to sql server.
Federico
A great open source alternative.
Avantages :
The community is one of the main aspects that make postgreSQL so attractive, with its open source DBMS and the ability to participate.
Inconvénients :
While it's a great alternative and easy to use, it may not offer the fastest speed. If you need efficiency you may need to look somewhere else.

Diego
The database everyone should be using
Commentaires :
PostgreSQL is an incredibly powerful piece of software that should be the RDBMS in every software project instead of less powerful but more famous alternatives.
Personally it will be my choice for every future project.
Avantages :
PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with.
Inconvénients :
It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful.
Utilisateur vérifié
Powerful database
Commentaires : 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.
Avantages :
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.
Inconvénients :
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.
Abbas Yusufzai
Postgre SQL.. Best 2D spatial database tool for geologists.
Commentaires : It's a pretty reliable database manager that provides for excellent data management and a very comprehensive security implementation, as well as the installation of procedures that make data integrity easy to maintain.
Avantages :
One of the advantages of this manager is that it is simple to install and has a free license for various distributions and operating systems. It also allows you to configure the manager according to the team requirements. Other capabilities include the ability to run read-only queries while in recovery mode. pg-Admin, for example, is a graphical application that allows us to simply administer our database. It is a great resource distribution for complex queries, very adjustable, allowing it to be tailored to the needs of individuals who use it, Allows you to limit the number of incoming connections to avoid timeouts caused by developers.
Inconvénients :
Indexing is some times very slow. Also database syncing or importing and exporting database is some time a headache. Apart from that, I don't see any major shortcoming in it.

Danilo
Alternatives envisagées :
Best database ever!
Commentaires : Best database management system: plenty of plugins (data visualization, backup, performance, etc), easily expandable, incredibly powerful configuration options.
Avantages :
PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need.
Inconvénients :
I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear.
Sanchit
One of the best to manage DB connections
Avantages :
We have been using this software for a couple of years after we faced a lot of issues and freezes in MySQL. This is comparatively much much more smooth and handles multiple DB connections and inter-switching with no lags or hangs.
Inconvénients :
We were more accustomed to the MySQL interface so found a few minor UX improvements that can be done here but overall it's still good.
Utilisateur vérifié
Alternatives envisagées :
Nothing but praise for *the* SQL DBMS
Commentaires : We are running tens of Postgres databases and we have no reason to switch.
Avantages :
It's been reliable beyond all expectations. Put your data in Postgres, you know you'll find them when you need them.
Inconvénients :
VACUUMs are a big performance penalty, and the default auto-vacuum settings aren't always optimal for all use cases.

Nairoby
It's free!
Commentaires : In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it
Avantages :
- Free code database manager, which is not used for licensing. - Easy to install and configure in any operating system. - Ideal for relational databases. - It has a large community in which you can share doubts. - It is stable and reliable, scalable and secure with the correct user management. - Can work with small and large databases. - Handles the SQL language. - Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards. - Easily works as a cluster, can be configured as active-passive or active-active which improves performance - It allows to perform maintenance, recovery of databases. - I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems. - Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.
Inconvénients :
- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is. - For some, not having support online or with an official help center can be a big disadvantage. - It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

Maryury
Database Manager PostgreSQL
Commentaires :
In my experience using the software I really liked that it allows adding custom functions developed using different programming languages.
The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters.
I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error.
Avantages :
PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters. It also allows to activate triggers to execute in tables or views in special cases or eventualities. It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.). It allows the development of robust and efficient Databases
Inconvénients :
There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources
Rajesh
Alternatives envisagées :
Review Of PostgreSQL
Commentaires : Overall PostgreSQL best in Market. They have better support and help their customers.
Avantages :
The PostgreSQL is best and most powerful RDBMS software in opensource platform. This PostgreSQL better in Data Storage, Data Dedupilication and Data Replication.
Inconvénients :
The PostgreSQL need some of security loop holes .
Paolo
Best Open Source RDBMS by far
Commentaires : I am a web developer and geospatial analyst. I am using PostgreSQL daily to store spatial datasets using PostGIS, its powerful spatial extension
Avantages :
PostgreSQL has been on my tech stack since 2006. It is an impressive open source software, really reliable. I love its PostGIS spatial module, which enables powerful geospatial functions.
Inconvénients :
I like everything and I can't think of something which I don't like. This is by far the best open source RDBMS

Petr
Object-relational open source database
Commentaires : We use PostgreSQL mainly for heavy load projects because to high write performance due to its MVCC approach, it largely eliminates the need for locking, and that the database effectively meets ACID principles.
Avantages :
Supports functions where the results are suitable for use as with tables. We can define own aggregate and window functions on that. Includes built-in support for B + tree, hash, GiST, GiN and custom index types. Support access using a system known as Multi-Version Concurrency Control (MVCC). Native support for many data types including XML support for Xpath queries or UUID. User defined objects, posibility to create new types of almost all objects in the database.
Inconvénients :
Possible worse performance in read operation.

Sanskriti
Managing DB with PostgreSQL works fine.
Commentaires : PostgreSQL can process complex queries in relatively less time, and data can be accessed seemingly faster with non-key attributes. Since we deployed PostgreSQL at work we are delighted to see its flexibility and the better performance for our most common use cases.
Avantages :
Implementing the database in PostgreSQL is quick and efficient. PostgreSQL is much quicker with use-cases. Setting prototypes for development is relatively easier with PostgreSQL. It is a simply a relational database, and stores the data in tables, and supports complex transactions. Accessing data and attribute is faster in PostgreSQL especially when searching for an attribute that is not indexed. So it is great for sorting data in a relatively short period of time.
Inconvénients :
PostgreSQL is not flexible to JSON objects, even the nested documents or arrays are not handled with Postgres. It is slow when it comes to processing queries that use nested references, so we had to deal with more complexities at work.
Isak
Alternatives envisagées :
Open source relational database with lots of features
Avantages :
Open source. Offers a rich set of features and extensions. Available as fully managed database on most cloud platforms.
Inconvénients :
Some cases, often involving large sets of data, might require some advanced knowledge in order to run properly/performant.
Utilisateur vérifié
Alternatives envisagées :
Open source database with advance features
Commentaires : We have deployed 100 of PostgreSQL instances as the back-end for state owned LMS. Databases are well performing and never receive any complaints regarding performance after the GO-LIVE. We have deploy PostgreSQL for simple web application to the enterprise grade internet banking app.
Avantages :
+ Install is very easy + Support almost all platform + Data aggregation is fast + Good documentation from vendor and community + Highly stable + Secured
Inconvénients :
+ Working with JSON etc. is not easy comparable to other products + Poor data compression mechanisms + Bit resource hungry
Utilisateur vérifié
Best SQL for Analytics and in terms of speed.
Commentaires : By using PostgreSQL as backend database for our large applications which uses large amount of data then selling that applications to customers we are getting benefits.
Avantages :
PostgreSQL is the best I can say. Its performance is very fast in terms of getting data and inserting data. Means if we are inserting entries in bulk then it would do it in a good speed as compared to other databases. It is very good for Analytics and it has good tooling than other databases. It supported many other features like using of arrays which is not in MySql so I would say it is good database to use to make applications.
Inconvénients :
The big disadvantage is it takes more memory than other databases if you have many connections and replication is bit difficult in PostgreSQL which might get easy in future updates else it is a good software.