PostgreSQL Reviews

Linux installation is recommended, though Windows is possible. PostgreSQL offers significant cost savings as it eliminates licensing fees and provides quick returns. Time is the primary investment for setup and maintenance, but users note high returns on developed applications, performance, maintenance, support, and reduced license costs. Organizations report immediate or very high return-on-investment and significant financial savings compared to other solutions. Users highlight the open-source nature as a key factor in realizing these benefits.

PostgreSQL is a free, open-source database popular among enterprise buyers seeking a cost-effective solution. It requires no licensing fees, making it an attractive choice over commercial systems like Oracle and Microsoft SQL Server. While there may be additional costs for third-party support, consultancy, and cloud deployment, expert setup and management ensure minimal financial impact. The investment primarily involves training and in-house expertise, offering significant savings, particularly for small to medium-sized businesses.

• "The tool is cheaply priced compared to other RDBMS providers in the market."
• "Our company pays for it. There are free versions available, but for advanced features, you obviously have to pay."
• "We use the open-source version of PostgreSQL and not the enterprise edition."

PostgreSQL is primarily used for data storage, inventory control, transactional processing, user authentication, and account management. It supports on-premises and cloud deployments, handles large datasets, and integrates with tools like Ruby on Rails and React. Organizations utilize it for ERP systems, financial data management, machine learning, databases, and relational data storage. It offers strong indexing, backup, and recovery features, making it suitable for real-time applications and mission-critical systems.

PostgreSQL's community provides a robust support network with accessible forums, rich documentation, and strong developer engagement. Many users rely on online resources for troubleshooting, while companies offer paid support. Though some mention documentation gaps, particularly for DevOps, feedback indicates high satisfaction with community responses. Users often solve issues using forums like Stack Overflow, avoiding the need for direct contact with support representatives. For those requiring assistance, third-party options are available.

Users find PostgreSQL's initial setup to be generally straightforward and easy, especially for basic configurations. However, some encounter challenges with advanced features and configurations due to documentation gaps or specific environment needs. Basic installations are quick, often completed in minutes to a few hours, but optimizing can require more time and expertise. Some users highlight ease on platforms like Docker and Windows, although others experience complexity with older systems or more intricate deployments.

PostgreSQL effectively supports scaling needs, generally handling user loads well. Many utilize scaling capabilities, experiencing ease, especially with cloud deployments or clustering techniques. Although some feature enhancements like sharding are awaited, configurations enable good performance. Despite occasional minor issues, scaling up typically remains hassle-free. It manages both horizontal and vertical scaling effectively, giving organizations adaptability. This flexibility often results in substantial satisfaction for most users, with room for more advanced scalability options.

Users have generally found PostgreSQL to be stable. While a few had issues with earlier versions, most encountered no significant problems. Stability is often reliant on proper configuration and skilled administration. Some mentioned performance slowdowns with large datasets or multiple users. Reports of bugs or crashes are rare, with many highlighting reliable operation over extended periods. Proper setup enhances its robust performance, making it dependable for many users.