PostgreSQL Reviews

Name: PostgreSQL
Brand: PostgreSQL
Rating: 4.2 (128 reviews)

Vendor: PostgreSQL

4.2 out of 5

128 reviews
96% willing to recommend

Leave a review Why PeerSpot?

What is PostgreSQL?

PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases.

Get the PostgreSQL Buyer's Guide and find out what your peers are saying about PostgreSQL, MySQL, Redis and more!

PostgreSQL is the #1 ranked solution in top Open Source Databases and #7 ranked solution in top Vector Databases solutions. PeerSpot users give PostgreSQL an average rating of 8.4 out of 10. PostgreSQL is most commonly compared to MySQL: PostgreSQL vs MySQL. PostgreSQL is popular among the large enterprise segment, accounting for 42% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 11% of all views.

Helped 916,771 peers since 2012

Featured PostgreSQL reviews

Shobhit Goel

Data Science Architect at publicis Sapient

The best feature is performance, because of which I decided on PostgreSQL. I have also enabled the PG vector plugin on top of PostgreSQL. I have the opportunity to use two different features and two different flavors in a single product, which is the best thing about PostgreSQL. Initially, we had some hiccups around the performance part, but later we did indexing in PostgreSQL and now it is working very well. Even when we are doing 100,000 transactions in a day, PostgreSQL is working excellently. The interface is another best feature. If I need to do any query, I simply install the plugin on my local, which is pgAdmin. Through pgAdmin, I am able to communicate with PostgreSQL and execute all my SQL queries. I am getting a better UI with PostgreSQL as the backend, which is also one of the best options. PG vector is also very strong from PostgreSQL where I have implemented RAG and on a daily basis, I inject thousands of pages of PDF. More than 100 PDFs are coming into my system and one PDF is around 1,000 pages. We are injecting them into PostgreSQL and converting them into dimensions and inserting them into PG vector. The level of transactions we are doing on a daily basis is substantial, and we are getting very good throughput and low latency from PostgreSQL. When we were doing more than 50,000 transactions in a minute with the previous database, we were getting a lot of latency issues with threads getting blocked and abruptly closed unwantedly. After doing extensive research, we decided to move to PostgreSQL. Now, we are doing around 100,000 transactions in PostgreSQL and we are getting good throughput with no latency.

Read full review

Ram Maruboina

Software Engineer – Rust Systems & AI Evaluation at Turing

PostgreSQL is a dependable database that offers a great balance of performance, stability, and advanced features without locking me into a proprietary ecosystem. As my application has grown, PostgreSQL has continued to meet my needs with minimal operational issues, which is very important. It is a solid choice for organizations looking for a mature, scalable, and well-supported relational database. In my current role, I leverage customized functions and extensions, especially when dealing with complex data transformations or business logic that are cumbersome to implement purely in the application code. For instance, I have written custom aggregate functions in PL/pgSQL to perform specialized calculations over my AI model's evaluation metrics. This significantly simplifies report queries and improves performance. I heavily rely on JSONB for storing and querying semi-structured data, particularly for log configurations related to the AI agent workflow. Its ability to index and query nested data efficiently is invaluable. For custom data types, while I use them less frequently, I have explored creating custom data types for specific domain requirements where built-in types do not meet my needs, to ensure data integrity at the database level. Regarding extensions, beyond JSONB, I have used extensions such as pg_cron for scheduling tasks within the database and others for generating unique identifiers. These are very useful. I would rate my overall experience with PostgreSQL a ten out of ten.

Read full review

AyushVerma

Software Engineer at GSS Academy, Noida

PostgreSQL fully supports ACID transactions, including atomicity, consistency, isolation, and durability, which are some of the best features it offers in my experience. It also supports multiple index types, such as B-tree, Gin, Gist, and BRIN, and provides JSON and JSONB support, which is used to query semi-structured data. PostgreSQL uses Multi-Version Concurrency Control, which allows multiple users to read and write simultaneously. For extensibility, PostgreSQL allows extensions such as PostGIS and pg_trgm, which are truly useful. PostgreSQL improves reliability, performance, and scalability in production. Since it is ACID compliant, it ensures that database transactions are safe and consistent, preventing partial data updates, maintaining data integrity, and allowing multiple users to read or write data simultaneously using MVCC. Features such as foreign keys, constraints, and triggers impact data consistency by preventing invalid data. It supports read replicas, partitioning, and horizontal scaling for scalability. PostgreSQL has been very stable in my experience, handling concurrent requests reliably while maintaining data consistency with ACID transactions and accommodating concurrent users with strong data integrity, making it mature and widely used in production systems. Using PostgreSQL with Prisma allows faster development because schema migrations are automated and type-safe queries reduce the time I spend fixing database bugs, allowing me to focus more on building features while improving collaboration between developers due to a well-defined relational schema. Migration tools keep everyone's database schema synchronized, which allows multiple developers to work on backend features without conflicts. It has a rich feature set, supporting advanced features such as window functions, common table expressions (CTEs), and full-text search, with the flexibility of supporting both JSON and relational data, meaning it can behave as both a relational database and a document database. Extensibility allows PostgreSQL to add new capabilities while maintaining a strong ecosystem that integrates easily with modern backend stacks such as Node.js, Docker, and Prisma.

Read full review

PostgreSQL mindshare

Product category:

As of October 2026, the mindshare of PostgreSQL in the Open Source Databases category stands at 11.8%, down from 16.7% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Open Source Databases Mindshare Distribution
Product	Mindshare (%)
PostgreSQL	11.8%
MySQL	12.7%
Firebird SQL	10.1%
Other	65.4%

Open Source Databases

Key learnings from peers

Valuable Features

Users highlight PostgreSQL's robust geospatial support with PostGIS, high reliability, and exceptional JSON and JSONB features. Its open-source nature allows cost-effective use and supports extensive customization with diverse extensions. PostgreSQL excels in performance with scalable architecture, supports ACID compliance ensuring data transactions integrity, and has comprehensive indexing capabilities. It handles complex queries efficiently and offers seamless integration with various languages. The community support and vast documentation enhance its appeal, making it a preferred choice for diverse applications.

"PostgreSQL provides the structured persistence layer that makes my AI experimentation and evaluation processes manageable, repeatable, and scalable."
"Now, we are doing the same level of transactions in PostgreSQL, around 100,000 transactions, and we are getting good throughput with no latency."
"PostgreSQL is for personal use, e.g. I've been using it for my applications."

Room for Improvement

PostgreSQL requires improvement in user-friendliness with a better interface and documentation while enhancing JSON capabilities, multi-master replication, and performance for large datasets. Users find the interface complex and seek improved scalability, integration, and support for real-time data. There is a demand for more efficient query optimization, multi-tenant capabilities, security enhancements, and better support for distributed queries and clustering to meet evolving data handling needs.

"While improving reliability, I have noticed that the limitations in PostgreSQL can be complex."
"The only thing for PG vector is if the dimension limit could be increased."
"They should make PostgreSQL more secure."

ROI

Users frequently mention high ROI due to PostgreSQL's open-source nature, which eliminates licensing costs. They note rapid return with minimal expenditure, emphasizing cost savings compared to alternatives like Oracle. Implementation requires time but results in tangible benefits, such as improved performance and easier maintenance. Many report saving significant amounts, often several hundred thousand dollars. The efficiency of using PostgreSQL in business intelligence contexts is another significant factor contributing to favorable ROI experiences.

Pricing

Enterprise users find PostgreSQL cost-effective as it is open-source with no licensing fees, leading to reduced initial investment compared to Oracle and Microsoft SQL Server. Users mainly incur costs for expert personnel and infrastructure. While PostgreSQL is free by itself, expenses may arise for third-party services, plugins, and managed versions like EnterpriseDB. Self-management further reduces costs, but cloud-managed PostgreSQL still offers affordability. Users appreciate its flexibility and significant ROI in database management scenarios.

"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."

Popular Use Cases

Organizations use PostgreSQL primarily for transactional data management and storage. Many favor it for its superior indexing and performance capabilities, especially at large scales. Common applications include ERP systems, financial data management, AI workflows, and backend support for microservices. Others leverage it for data analytics, sensor data storage, machine learning, and adaptation in various industries like accounting, media, and software development. Its open-source nature and scalability are highly appreciated.

Service and Support

PostgreSQL is supported by a vast community, offering robust resources for troubleshooting. Many users find answers through forums, mailing lists, and extensive documentation. Third-party companies provide professional support, while cloud providers like Amazon and Google handle technical assistance when PostgreSQL is hosted on their platforms. Users generally find community support sufficient, often turning to online resources like Stack Overflow for solutions. The active community contributes significantly to resolving issues and sharing knowledge.

Deployment

PostgreSQL's initial setup is generally straightforward, especially when using default configurations or distro packages. Beginners find setup easy but encounter complexity with advanced configurations and performance tuning. Managed databases or Docker integration simplify setup. Common challenges arise from extensive configuration options and security settings. Reading documentation and gaining experience improve setup outcomes. Advanced setups require tuning and adjustments for optimal performance, while cloud services and GUI installers facilitate quicker deployment.

Scalability

Many users report no issues with PostgreSQL's scalability. They find it easy to expand, especially with configurations that optimize performance. Some encountered challenges with large datasets, while others praise its horizontal scaling capabilities. There is mention of missing features like sharding. PostgreSQL efficiently handles increased transactions and offers good options for read scalability through replication. Users highlight the benefit of no licensing restrictions as usage grows.

Stability

PostgreSQL is described as highly stable, reliable, and bug-free by users, with no issues encountered when properly configured. While some report minor stability concerns with large data or specific versions, most find it performs reliably. Observers note stability is often dependent on configuration and administrator expertise. PostgreSQL holds a reputation for stability, surpassing MySQL and being comparable to Oracle. Performance is praised, with seamless operation under ideal conditions, although a few note slowdowns in specific scenarios.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our PostgreSQL Buyer's Guide for additional reliable information.

Review data by company size

By reviewers
Company Size	Count
Small Business	57
Midsize Enterprise	22
Large Enterprise	41

By reviewers

By visitors reading reviews
Company Size	Count
Small Business	318
Midsize Enterprise	135
Large Enterprise	324

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

11%

Comms Service Provider

10%

Outsourcing Company

Computer Software Company

Construction Company

Manufacturing Company

University

Government

Healthcare Company

Educational Organization

Retailer

Media Company

Performing Arts

Non Profit

Insurance Company

Marketing Services Firm

Transportation Company

Energy/Utilities Company

Real Estate/Law Firm

Hospitality Company

Legal Firm

Wholesaler/Distributor

Pharma/Biotech Company

Aerospace/Defense Firm

Non Tech Company

Recreational Facilities/Services Company

Compare PostgreSQL with alternative products

Learn more about PostgreSQL

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.

PostgreSQL customers

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

Product Categories

Open Source Databases

Vector Databases

Popular Comparisons

MySQL vs PostgreSQL

Redis vs PostgreSQL

Microsoft Azure Cosmos DB vs PostgreSQL

MongoDB Enterprise Advanced vs PostgreSQL

Elastic Search vs PostgreSQL

InfluxDB vs PostgreSQL

Firebird SQL vs PostgreSQL

ClickHouse vs PostgreSQL

MariaDB vs PostgreSQL

Qdrant vs PostgreSQL

Pinecone vs PostgreSQL

Milvus vs PostgreSQL

SingleStore vs PostgreSQL

CockroachDB vs PostgreSQL

Cassandra vs PostgreSQL

See all alternatives

PostgreSQL Reviews Summary
Author info	Rating	Review Summary
Data Science Architect at publicis Sapient	4.0	I rely on PostgreSQL for financial and AI (RAG with PG vector) needs. It delivers excellent performance, handling 100,000 transactions/minute without latency, improving efficiency and customer service. My main wish is for higher PG vector dimension limits.
Software Engineer – Rust Systems & AI Evaluation at Turing	4.5	I rely on PostgreSQL for AI workflows, storing data, evaluating models, and validating AI-generated code. Its robustness, extensibility, and open-source nature are highly valued despite minor configuration complexities. I rate it ten out of ten.
Software Engineer at GSS Academy, Noida	4.0	I’ve used PostgreSQL for three years for authentication and a collaborative app, valuing ACID, MVCC, indexing, JSONB, and extensibility with Prisma. It’s stable and scalable, but needs good indexing, connection pooling, partitioning, and caching.
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.
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.
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.
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.
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.
System Administrator at TZ Telecom Ltd.	4.5	I use PostgreSQL on-premises to manage real-time monitoring data due to its performance, TimescaleDB extension support, and cost-effectiveness. Although it requires manual tuning and consumes more memory, its benefits outweigh these challenges, offering a 100% ROI.

Shobhit Goel

Data Science Architect at publicis Sapient

Apr 8, 2026

High-volume transactions have reduced failures and improve customer service efficiency

PostgreSQL Reviews

What is PostgreSQL?

Featured PostgreSQL reviews

PostgreSQL mindshare

Valuable Features

Room for Improvement

ROI

Pricing

Popular Use Cases

Service and Support

Deployment

Scalability

Stability

Review data by company size

Top industries

Compare PostgreSQL with alternative products

Learn more about PostgreSQL

PostgreSQL customers

Related questions

Product Categories

Popular Comparisons

What is our primary use case?