PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases.
| Product | Market Share (%) |
|---|---|
| PostgreSQL | 17.1% |
| Firebird SQL | 16.5% |
| MySQL | 9.4% |
| Other | 57.0% |
| Title | Rating | Mindshare | Recommending | |
|---|---|---|---|---|
| MySQL | 4.1 | 9.4% | 91% | 150 interviewsAdd to research |
| Firebird SQL | 3.9 | 16.5% | 86% | 15 interviewsAdd to research |
The most valuable features of PostgreSQL include its robustness, scalability, and reliability. Users appreciate its ability to handle large amounts of data efficiently and its support for complex queries and transactions.
Additionally, PostgreSQL's extensibility and flexibility are highly regarded, allowing users to customize and optimize their database according to their specific needs. Community support and frequent updates are also mentioned as valuable aspects, ensuring the ongoing improvement and stability of the software.
PostgreSQL could benefit from enhancements in terms of performance optimization, user interface simplification, and documentation clarity. Users have expressed a desire for faster query execution and improved indexing capabilities to enhance overall database performance.
Additionally, some users have found the user interface to be complex and suggested streamlining it for a more intuitive experience. Lastly, users have requested more comprehensive and user-friendly documentation to aid in understanding and utilizing PostgreSQL effectively.
PostgreSQL has proven to be a valuable investment. Users have reported positive returns and benefits from utilizing PostgreSQL in their operations.
PostgreSQL offers competitive pricing options with reasonable setup costs. Users appreciate the flexibility in licensing options available for PostgreSQL.
The primary use case of PostgreSQL is for managing and storing data in various applications and systems. It is commonly used for web development, data analysis, and building scalable and reliable databases.
Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. It is also praised for its support of advanced features such as indexing, replication, and transaction management.
PostgreSQL's customer service and support have been highly praised. Users have expressed satisfaction with the prompt and helpful assistance provided by the PostgreSQL team.
The support team is described as knowledgeable, responsive, and efficient. Users appreciate the level of expertise and guidance offered.
The initial setup and deployment of PostgreSQL seem to be relatively easy and straightforward. Users mention that it takes about ten minutes to complete the setup process, and they can set up the databases with just a few clicks.
The installation is described as straightforward and simple, with only a few parameters to go through. Some users mention that the initial setup took less than one day or just a few minutes.
PostgreSQL is highly regarded for its ability to handle increasing demands and accommodate growth effectively. Users have praised its scalability, highlighting its capability to handle large amounts of data and support high-performance applications. The solution has been described as robust, reliable, and capable of scaling seamlessly to meet evolving business needs.
PostgreSQL is highly regarded for its reliability and consistency. Users have expressed satisfaction with its stability, indicating that it is dependable and secure.
| Company Size | Count |
|---|---|
| Small Business | 57 |
| Midsize Enterprise | 22 |
| Large Enterprise | 38 |
| Company Size | Count |
|---|---|
| Small Business | 286 |
| Midsize Enterprise | 146 |
| Large Enterprise | 528 |
It offers advanced features like indexing, replication, and transaction management. Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. Its robustness, scalability, and support for complex queries make it highly valuable.
Additionally, PostgreSQL's extensibility, flexibility, community support, and frequent updates contribute to its ongoing improvement and stability.
1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
| Author info | Rating | Review Summary |
|---|---|---|
| Senior Assosiate Consultant at Applied Materials | 3.5 | I use PostgreSQL for large OLAP workloads and unstructured data, valuing its real-time data capture for performance optimization. Sometimes, view-related issues arise, but overall, PostgreSQL is advisable over MySQL for big or unstructured data. |
| Software Architect at Tetherfi | 5.0 | I use PostgreSQL in my company for relational and transactional data storage essential for our microservices, valuing its simplicity and open-source nature. However, it needs improvements in managing bulk data and could benefit from AI capabilities. |
| Vice President Business at Techmagnate: Digital Marketing Agency | 4.0 | We use PostgreSQL for querying data warehouses and building reports due to its fast query and transaction speed. However, network issues can slow it down, and it doesn't allow multiple users to access locked tables simultaneously, which needs improvement. |
| Senior Analyst Applications, Projects and Processes at ADVA Optical Networking Israel LTD. | 4.5 | We use PostgreSQL in our company for test systems because it is powerful and easy to manage, offering numerous features. However, we believe its performance could be improved. We haven't considered or used any alternative solutions or deployment providers. |
| HEAD OF ENGINEERING at a insurance company with 201-500 employees | 3.5 | We use PostgreSQL as a backend database for secure data analysis with BI tools, appreciating its speed when memory is ample. However, it needs better integration capabilities and a stronger knowledge base compared to the more versatile MySQL. |
| Founding Director at Cyberdyne Solutions | 3.5 | I use PostgreSQL to store tables because it is stable and performs well, though its stability could be improved. The solution is cost-effective, fulfilling its purpose without expenses. I considered MongoDB, but it operates differently with document-oriented storage. |
| Software Engineer at Medflix | 4.5 | In my company, we use PostgreSQL for transactional purposes due to its indexing and performance advantages over NoSQL databases. It supports features like JSONB aggregators but struggles with performance during heavy event processing, a common SQL database issue. |
| Data Quality Engineer at Nidec Corporation | 4.0 | We frequently use PostgreSQL for operations monitoring in our manufacturing company, finding it valuable. However, we face challenges with its datetime datatype. We have not used or considered other solutions, and we don't use a cloud provider for deployment. |
