Based on 6 verified reviews published in the last 18 months
Reviewers frequently cite experience with a range of other database management systems when considering alternatives or complementary solutions to PostgreSQL. The most commonly mentioned alternative is Microsoft SQL Server, cited by 4 of 6 reviewers, indicating a significant overlap in user experience with this proprietary database. Other notable relational database systems that reviewers have used or evaluated include Oracle Database, MariaDB Platform, and SQLite, each mentioned by 2 of 6 reviewers. This suggests that users often work within a multi-database environment or have experience migrating between different platforms. The mentions generally reflect a broad familiarity with various database technologies rather than explicit comparisons of features or performance against PostgreSQL, given the nature of the inquiry about prior usage.
Microsoft SQL Server is the most frequently cited alternative database system that reviewers have experience with, ment…
Microsoft SQL Server is the most frequently cited alternative database system that reviewers have experience with, mentioned by 4 of 6 reviewers. This indicates a common background among users who have worked with various relational database platforms, often in enterprise environments. Reviewers typically list it as another system they have used or evaluated in their professional capacity.
Reviewers also frequently mention Oracle Database as another system they have used or evaluated, with 2 of 6 reviewers…
Reviewers also frequently mention Oracle Database as another system they have used or evaluated, with 2 of 6 reviewers citing it. This highlights a common exposure to established, large-scale database solutions among the user base. The mentions suggest that users often navigate environments with a mix of database technologies.
MariaDB Platform is another database system that reviewers have experience with, noted by 2 of 6 reviewers. Its mention…
MariaDB Platform is another database system that reviewers have experience with, noted by 2 of 6 reviewers. Its mention suggests that users are familiar with open-source relational database alternatives, often considering them alongside or in place of other solutions. This indicates a diverse background in database technologies.
SQLite is also mentioned by 2 of 6 reviewers as a database they have used or evaluated. This indicates familiarity with…
SQLite is also mentioned by 2 of 6 reviewers as a database they have used or evaluated. This indicates familiarity with lightweight, embedded database solutions, often used for different scales or types of applications compared to larger server-based systems. Reviewers' experience with SQLite suggests a broad understanding of database use cases.
PostgreSQL consistently demonstrates a positive return on investment, primarily driven by significant cost savings. Reviewers frequently highlight the elimination of licensing fees as a major financial benefit, with 5 out of 6 reviewers specifically noting this advantage. Beyond direct cost reductions, the platform also contributes to business objectives through improved performance, reduced maintenance requirements, and enhanced flexibility, all of which indirectly contribute to greater efficiency and resource optimization. The combination of these factors allows organizations to operate within more cost-effective budgets while maintaining high operational standards, making it a compelling choice for database solutions.
A predominant factor contributing to PostgreSQL's positive ROI is its open-source nature, which eliminates software lic…
A predominant factor contributing to PostgreSQL's positive ROI is its open-source nature, which eliminates software licensing costs. This allows organizations to realize substantial financial savings, with one reviewer noting a 100-fold reduction in annual disk space costs compared to a proprietary alternative, enabling operation within a cost-effective budget.
PostgreSQL significantly enhances operational efficiency through improved query performance and streamlined development…
PostgreSQL significantly enhances operational efficiency through improved query performance and streamlined development processes. Reviewers noted that correct usage, including indexing and specific functions, can lead to queries running 100 times faster, while its adherence to standards and clear documentation help developers solve problems more quickly.
The platform contributes to ROI by minimizing the time and effort required for database administration. Two reviewers s…
The platform contributes to ROI by minimizing the time and effort required for database administration. Two reviewers specifically highlighted that utilizing managed PostgreSQL services can reduce maintenance work to nearly zero, freeing up valuable resources for other tasks.
PostgreSQL's adherence to standards and broad compatibility provide significant operational flexibility. This enables i…
PostgreSQL's adherence to standards and broad compatibility provide significant operational flexibility. This enables it to support almost all types of applications, allowing organizations to standardize on a single database solution across their entire infrastructure and improving developer efficiency due to its well-documented and predictable behavior.
Analysis of feedback from six reviewers indicates a diverse set of software tools are regularly used alongside PostgreSQL, spanning database management, cloud storage, and Apache ecosystem technologies. Two of six reviewers mentioned using DBeaver for database management, highlighting its presence in their daily workflows. Similarly, cloud storage solutions, including offerings from IBM and Azure, along with Snowflake, were cited by two reviewers as part of their infrastructure. The Apache software suite also featured prominently, with two reviewers referencing tools such as Apache Subversion, Airflow, and Spark. While reviewers identified specific tools they integrate into their operations, the provided feedback primarily focused on listing these technologies without offering explicit endorsements or criticisms regarding their performance or utility. This suggests that these tools are established components of their technical stacks, though further qualitative data would be needed to assess user satisfaction or recommendation likelihood.
Reviewers indicated the use of specific database management tools in their operations. DBeaver was mentioned by two of…
Reviewers indicated the use of specific database management tools in their operations. DBeaver was mentioned by two of six reviewers as a regularly utilized application, suggesting its role in managing database environments. The feedback primarily identified the tool without detailing specific experiences or opinions regarding its functionality.
Cloud storage solutions are integrated into the workflows of some reviewers. Two reviewers cited various platforms, inc…
Cloud storage solutions are integrated into the workflows of some reviewers. Two reviewers cited various platforms, including IBM Cloud Object Storage, IBM Cloud Block Storage, Azure Blob Storage, and Snowflake, indicating a reliance on external storage services. The mentions focused on identifying the platforms in use rather than providing qualitative feedback on their performance or user experience.
Several Apache software products are regularly employed by reviewers. Two of six reviewers specifically noted using Apa…
Several Apache software products are regularly employed by reviewers. Two of six reviewers specifically noted using Apache Subversion, Apache Airflow, and Apache Spark, which points to their adoption for version control, workflow orchestration, and data processing tasks, respectively. The feedback highlighted the presence of these tools in their technical stacks, without offering detailed commentary on their effectiveness or user satisfaction.
PostgreSQL is frequently adopted by organizations for its robust reliability and security features, with half of the reviewers highlighting its consistent performance and secure nature over time. This foundational stability is often complemented by its open-source model, which 2 of 6 reviewers specifically noted contributes to significant cost savings by eliminating licensing fees. Beyond cost efficiency, PostgreSQL is valued for its adaptability, with 2 reviewers appreciating its flexibility for customization, enabling developers to tailor the database to specific business needs and embrace versatile deployment options. While performance and scalability are cited as key business problems addressed by PostgreSQL by some, a notable mixed sentiment emerged, with one reviewer indicating occasional performance challenges requiring analysis. This suggests that while the product generally meets performance requirements, optimization efforts may be necessary in certain use cases.
Reviewers consistently commend PostgreSQL for its dependable operation and strong security posture, with three of six r…
Reviewers consistently commend PostgreSQL for its dependable operation and strong security posture, with three of six reviewers emphasizing its long-term stability. The product is seen as a secure choice, especially when leveraging managed services that provide reliable backups and autoscaling.
A significant benefit highlighted by 2 of 6 reviewers is the cost-effectiveness of PostgreSQL. Its open-source nature a…
A significant benefit highlighted by 2 of 6 reviewers is the cost-effectiveness of PostgreSQL. Its open-source nature allows organizations to avoid licensing costs, providing essential features without compromising on budget management.
Reviewers hold mixed views on PostgreSQL's performance and scalability. While some identify it as a solution for perfor…
Reviewers hold mixed views on PostgreSQL's performance and scalability. While some identify it as a solution for performance and scalability challenges, one reviewer noted experiencing occasional performance issues that require ongoing analysis. This suggests that while the product is capable, specific implementations might necessitate optimization.
PostgreSQL is highly valued for its adaptability, with 2 of 6 reviewers praising its flexibility and customization opti…
PostgreSQL is highly valued for its adaptability, with 2 of 6 reviewers praising its flexibility and customization options. This allows developers to tailor the database to unique business requirements and supports versatile deployment strategies, such as shifting from containerized environments to more native setups.
Reviewers identified several areas where PostgreSQL could be improved, primarily focusing on operational complexities and performance optimization. The most frequently cited concerns, each noted by 3 of 6 reviewers, relate to the challenges associated with installation and upgrades, as well as the need for enhanced performance analysis tools. Specifically, reviewers highlighted difficulties in performing major version upgrades without straightforward zero-downtime options and the struggle to optimize high-latency queries. Less frequently, but still significant, 2 of 6 reviewers pointed to the complexity arising from a multitude of configuration parameters and the intricate nature of horizontal write sharding. Additionally, operational challenges, such as frequent blocking locks during DDL operations and the need to manage workloads that exceed capacity, were also raised by 2 of 6 reviewers. The desire for more integrated query functionality, including additional out-of-the-box SQL functions and improved indexing capabilities, was also mentioned by 2 of 6 reviewers.
Reviewers frequently noted that the process of installing extensions can be challenging without superuser access, parti…
Reviewers frequently noted that the process of installing extensions can be challenging without superuser access, particularly in hyperscaler environments. A significant pain point, mentioned by 3 of 6 reviewers, is the lack of a straightforward path for major version upgrades, with a specific call for improvements to enable zero-downtime upgrades.
Optimizing query performance was a recurring concern for 3 of 6 reviewers, who expressed a need for clearer indications…
Optimizing query performance was a recurring concern for 3 of 6 reviewers, who expressed a need for clearer indications regarding query plans to facilitate better optimization. Reviewers also identified general performance problem analysis as an area requiring improvement, noting that some queries exhibit high latency.
The extensive number of available configuration parameters was cited by 2 of 6 reviewers as a source of confusion for d…
The extensive number of available configuration parameters was cited by 2 of 6 reviewers as a source of confusion for database engineers, indicating a potential for overwhelming complexity. Furthermore, implementing advanced architectures such as horizontal write sharding was described as becoming quite complex.
Reviewers expressed a desire for enhanced query capabilities, specifically requesting more out-of-the-box, PostgreSQL-s…
Reviewers expressed a desire for enhanced query capabilities, specifically requesting more out-of-the-box, PostgreSQL-specific SQL functions. The topic of indexing was also highlighted by 2 of 6 reviewers as an area that could benefit from further development.
Operational aspects presented challenges for 2 of 6 reviewers, who reported frequent blocking locks occurring during ce…
Operational aspects presented challenges for 2 of 6 reviewers, who reported frequent blocking locks occurring during certain DDL operations. This can lead to situations where operational teams must carefully weigh priorities to maintain system availability when workloads exceed capacity.
Reviewers frequently highlight PostgreSQL's robust performance and reliability as a primary strength, with 4 of 6 reviewers specifically commending its stability and consistent high performance. This includes its ability to operate effectively even with substantial data volumes, with reviewers noting its resistance to crashes and data loss. Beyond its technical prowess, PostgreSQL also delivers significant cost efficiencies; 2 of 6 reviewers appreciate its open-source licensing model, which contributes to reduced IT budgets. Furthermore, its flexible scalability and configuration capabilities are valued, with 2 of 6 reviewers pointing out features like automatic disk scaling and unrestricted configuration options for parameters such as maximum connections. These aspects collectively position PostgreSQL as a powerful and cost-effective database solution.
Reviewers consistently praise PostgreSQL for its high performance and robust reliability, with 4 of 6 reviewers noting…
Reviewers consistently praise PostgreSQL for its high performance and robust reliability, with 4 of 6 reviewers noting its stability. It is described as a system that rarely crashes and effectively safeguards data, even when handling large datasets. Its performance is considered among the best across various benchmarks.
The open-source nature of PostgreSQL is a significant advantage, directly contributing to cost savings for organization…
The open-source nature of PostgreSQL is a significant advantage, directly contributing to cost savings for organizations. Two of six reviewers explicitly mention that its licensing model helps reduce IT expenditures. This makes it an economically attractive option for database management.
PostgreSQL offers strong scalability and flexible configuration options, which are highly valued by reviewers. Two of s…
PostgreSQL offers strong scalability and flexible configuration options, which are highly valued by reviewers. Two of six reviewers highlight its ability to automatically scale resources, such as increasing disk space when needed. Additionally, its lack of restrictions on configuring critical parameters like maximum connections provides greater control and adaptability.