Last updated on
Company health
Ratings
PostgreSQL description
PostgreSQL is a reliable, open-source database system businesses use to store and manage their data. Known for its reliability and performance, it's suitable for a wide range of needs, from single computers to large-scale data storage for multiple users. PostgreSQL is free to use and is backed by a large community of developers.
Who is PostgreSQL best for
PostgreSQL is a robust, open-source database solution suitable for businesses of all sizes. Known for its reliability, performance, and scalability, it excels in handling large datasets efficiently. Users appreciate its open-source nature, ease of installation, and fast query times. However, some find the initial setup complex and the CPU usage somewhat high. It's particularly well-suited for the software development industry.
-
Ideal for small, medium, and enterprise businesses.
-
Best fit for Software, IT & Telecommunications; suitable for E-commerce, Retail, Education, and public sector.
PostgreSQL features
| Supported PostgreSQL, as offered via EDB on AWS Marketplace, fully supports SQL querying. |
| Supported PostgreSQL supports standard SQL syntax and implements many of the features required by the SQL standard. |
| Supported PostgreSQL supports asynchronous replication, which prioritizes performance over strict data consistency. |
| Supported PostgreSQL supports synchronous replication for high data consistency. |
| Supported PostgreSQL supports JSON data and querying, enabling custom JSON APIs. |
| Supported PostgreSQL supports granular data access control through roles, permissions, and row-level security. |
We evaluate the sentiment that users express about non-functional aspects of the software
Value and Pricing Transparency
Customer Service
Ease of Use
Reliability and Performance
Ease of Implementation
Scalability
PostgreSQL reviews
We've summarised 992 PostgreSQL reviews (PostgreSQL Capterra reviews and PostgreSQL G2 reviews) and summarised the main points below.
- Open-source database
- Easy to install and configure
- Handles large datasets efficiently
- Fast querying time
- Strong community support
- Consumes somewhat higher CPU usage so that efficiency is a bit low
- Initial setup is not straightforward.
- Limited GUI tools.
- PostgreSQL may have slower performance than other RDBMS like SQL Server and MySQL.
PostgreSQL pricing
The commentary is based on 112 reviews from PostgreSQL Capterra reviews and PostgreSQL G2 reviews.
PostgreSQL is a free and open-source relational database management system (RDBMS). Users appreciate its cost-effectiveness, robust features, and scalability. While some find the interface less user-friendly than commercial options, the lack of licensing fees makes it an attractive choice.
Users sentiment
PostgreSQL alternatives
Microsoft SQL ServerBetter suited for enterprise customers. Wider industry applicability. Has significantly more momentum. Stronger integration with Microsoft products. Higher licensing costs.Read more
postgresql vs MySQLBetter for web applications and boasts faster growth. More popular with a larger user base and broader industry applicability. Simpler for basic database operations.Read more
postgresql vs MariaDBMore website traffic momentum. A better PostgreSQL alternative for smaller businesses due to cost-effectiveness. Less suitable for finance, e-commerce, and other industries.Read more
MongoDBBetter for agile development and handling large datasets, particularly for real-time analytics and online content management. Has significantly more momentum currently. Schema-less design may be preferable for some.Read more
postgresql vs MongoDBBetter for software and IT companies. Has stronger momentum in terms of website traffic and employee growth. Offers a flexible schema design. Lacks JOIN support and can have high memory consumption.Read more
ClickHouseBetter for analytics on large datasets, particularly suited to log analysis and reporting. Has significant momentum compared to PostgreSQL. Columnar data storage allows for faster query processing with large datasets.Read more
PostgreSQL FAQ
What is PostgreSQL and what does PostgreSQL do?
PostgreSQL is a powerful, open-source relational database management system known for its reliability, data integrity, and robust feature set. It efficiently handles diverse workloads, from simple applications to complex data warehousing, and is highly scalable for growing businesses. PostgreSQL is also standards-compliant and actively developed by a large community.
How does PostgreSQL integrate with other tools?
PostgreSQL integrates with various tools through its extensive API support and drivers. It's compatible with programming languages like Python, Java, and C++, and integrates with BI tools for data visualization and analysis. Its open-source nature further expands integration possibilities.
What the main competitors of PostgreSQL?
Top PostgreSQL competitors include MySQL, MongoDB, and Microsoft SQL Server. These alternatives offer diverse features and capabilities, catering to various data management needs. For cloud-based solutions, consider MongoDB Atlas.
Is PostgreSQL legit?
Yes, PostgreSQL is a safe and legitimate open-source database known for its reliability and performance. It's trusted by many businesses for its robust features, active community support, and ability to handle large datasets efficiently.
How much does PostgreSQL cost?
PostgreSQL is an open-source database, so it's free to download and use. However, you might incur costs for hosting, support, and add-on tools depending on your specific needs. Is PostgreSQL worth it? Its cost-effectiveness makes it a popular choice.
Is PostgreSQL customer service good?
Customer support for PostgreSQL is mixed. While the large community forum is helpful for some, others find the lack of direct, dedicated support challenging, especially for complex issues. A few users mention slow response times.
Reviewed by
Michal has worked at startups for many years and writes about topics relating to software selection and IT management. As a former consultant for Bain, a business advisory company, he also knows how to understand needs of any business and find solutions to its problems.
Tymon is a seasoned CTO who loves finding the perfect tools for any task. He recently headed up the tech department at Batmaid, a well-known Swiss company, where he managed about 60 software purchases, including CX, HR, Payroll, Marketing automation and various developer tools.