--- title: PostgreSQL Reviews meta_title: 'PostgreSQL Reviews November 2026: Details, Pricing, & Features | G2' meta_description: Filter 682 reviews by the user's company size, role or industry to find out how PostgreSQL works for a business like yours (as of November 2026). aggregate_rating: rating_value: 4.4 review_count: 682 scale: '5' date_modified: '2026-11-16' parent_category: name: Database Software url: https://www.g2.com/categories/database-software ---

PostgreSQL Reviews & Product Details

Pricing

Pricing provided by PostgreSQL.

Basic

$0.01
With One-Time Purchase

User Insights

Average based on 682 real user reviews.

Implementation Time

2 months

Perceived Cost

$$$$$

Typical contract price

$0k - $0k

Sign in to view

With One-Time Purchase

PostgreSQL Reviews FAQs

Generated using AI

Last updated: Nov 01, 2026

What is PostgreSQL, and what problem is it built to solve?

PostgreSQL is an open-source object-relational database system for storing and managing data. It is built to support reliable data handling, with an emphasis on data integrity and correctness.

What company sizes and industries is PostgreSQL the best fit for?

PostgreSQL is used across small businesses, mid-market organizations, and enterprises, with especially strong representation in software and IT settings.
  • Company size: Small businesses, mid-market organizations, and enterprises.
  • Industries: Computer software and information technology and services.
  • Other represented industries: Financial services, education, and retail.

How long does it take to implement PostgreSQL across a team?

Teams commonly get PostgreSQL live in under a month, though implementation can be quicker or take several months depending on the work involved.
Time to go live Relative frequency
Under 1 month Most common
Under 1 day Also reported
1–3 months Also reported
3–6 months Less common
6–12 months or longer Less common

What customer support options does PostgreSQL provide, and how do users find the overall support experience?

Support options include 24/7 live-rep help, phone and email support, and self-service resources such as FAQs and a knowledge base. The experience is mixed: community discussions and documentation can help teams find answers, while users also describe wanting more direct, dependable technical assistance, particularly for complex or managed deployments.

What is the experience like for teams switching to PostgreSQL from another tool?

Switching to PostgreSQL has often meant moving from MySQL or other relational and legacy databases to reduce licensing costs or gain flexibility for complex queries, data types, and application integrations. The change can preserve familiar relational workflows, but differences in SQL syntax, features, and configuration may require migration work and adjustment.

What tools and platforms does PostgreSQL integrate with, and how do these integrations help users get more value from the product?

PostgreSQL offers 24 listed integrations, and users connect it with development frameworks, analytics tools, and data platforms.
  • Development and application frameworks: Python, Node.js, Prisma, and Ruby on Rails.
  • Analytics and business intelligence: Tableau and Power BI.
  • Cloud and data platforms: AWS RDS and Cloudera.
These connections let teams use PostgreSQL within application backends and bring database information into reporting and data workflows.

What features or capabilities could make PostgreSQL even more useful?

PostgreSQL could be easier to operate and learn, particularly as teams move from basic use to production tuning. Recurring opportunities to improve it include:
  • Make administration more approachable: Improve the usability and responsiveness of graphical management tools.
  • Simplify performance work: Provide clearer monitoring and more guided help for query optimization, indexing, and vacuum settings.
  • Strengthen onboarding resources: Add more practical examples and beginner-friendly setup and configuration guidance.

Is PostgreSQL considered safe and secure for handling data?

PostgreSQL is used for sensitive and business-critical data, with users highlighting role-based access, permissions, and secure connections as useful safeguards. Its reliability and transaction integrity also support confidence in stored data. Security still depends on careful configuration: access controls and encryption practices may require deliberate setup rather than being assumed to work securely by default.

PostgreSQL Reviews (682)

View 2 Video Reviews
Reviews

PostgreSQL Reviews (682)

View 2 Video Reviews
4.4
682 reviews

What do users say?

Generated using AI from real user reviews

Pros & Cons

Generated from real user reviews
View All Pros and Cons
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Omkar M.
OM
Omkar M.
Software engineer
Small-Business (50 or fewer emp.)
"Postgres is my Superman of the Database"
5/5
What do you like best about PostgreSQL?

Postgres has some amazing features like it has introduced a pg vector. Which am using mostly everywhere in my AI applications. It comes handy I don't have to setup two different databases for relational and vector seperate, both of them postgres provides, it saves my headache. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing much but postgres do not have an ability to store the data entirely in ram for fast access which Mysql like database provides Review collected by and hosted on G2.com.

Pramoda  H.
PH
Pramoda H.
Full Stack Developer
Program Development
Small-Business (50 or fewer emp.)
Originally submitted 5/25/2026
"Solid relational database for a real-world PHP clinic management system"
4.5/5
What do you like best about PostgreSQL?

I use PostgreSQL as the core database for a Pet Clinic Management System I built. It supports multi-role authentication (admin, doctor, staff, and pet owners), appointment scheduling, medical records, vaccination tracking, and invoice management, all within a single relational schema.

What I value most is PostgreSQL’s ability to enforce complex relational integrity. In my system, the appointments table includes foreign key constraints that link to animals, owners, doctors, schedules, and staff at the same time. PostgreSQL handles cascading deletes and referential integrity smoothly—for instance, when an owner is deleted, their associated animals and related records are automatically removed.

I also like the strong support for enum types, sensible timestamp defaults, and multi-column unique constraints, such as preventing duplicate owner registrations. These features made my schema design cleaner and more dependable. On the application side, PostgreSQL integrates well with PHP via PDO, so parameterized queries are easy to write and help keep the system secure against SQL injection. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Initial setup and configuration—especially when it comes to user roles, privileges, and connection pooling—feels more involved than with simpler databases. In my case, for a pet clinic system I run locally using XAMPP/MariaDB syntax, migrating the schema to PostgreSQL took extra care because of syntax differences (for example, AUTO_INCREMENT vs. SERIAL and how enums are handled).

On top of that, debugging complex multi-join queries—such as joining appointments with animals, owners, doctors, and schedules—can lead to error messages that are difficult to interpret, particularly for developers coming from a MySQL/MariaDB background. Review collected by and hosted on G2.com.

Hrithik V.
HV
Hrithik V.
Software Engineer - Trading Systems
Mid-Market (51-1000 emp.)
"PostgreSQL: Flexible, Reliable, and Easy to Scale"
5/5
What do you like best about PostgreSQL?

What I like most about PostgresSQL is it's reliability, performance and rich feature set. We use it for production workflows, and it has handled everything from transactional data to large partitioned tables effectively. Features such as indexing, query optimization, EXPLAIN ANALYZE make it easy to diagnose and improve performance issues. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One drawback of PostgresSQL is that advanced administration and performance tuning can have a steep learning curve. As the database grows, tasks such as partitioning, indexing strategy, query optimization require experienced database knowledge. While PostgresSQL performs very well, troubleshooting complex queries can take significant effort compared to some managed database solutions. Review collected by and hosted on G2.com.

Gunther C.
GC
Gunther C.
Software Engineer
Mid-Market (51-1000 emp.)
"Versatile, High-Performance PostgreSQL for Local and Cloud Development"
5/5
What do you like best about PostgreSQL?

PostgreSQL offers robust database functionality that covers a wide variety of use cases. The ability to run this database locally for testing and development as well as in the cloud is imperative for ensuring that software runs as expected when it goes into production. The adoption of PostgreSQL by a wide variety of cloud providers has made this a great option for most software projects. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have few complaints about PostgreSQL, it is one of the most versatile and performant databases that I've used Review collected by and hosted on G2.com.

Aparajito P.
AP
Aparajito P.
NA
Mid-Market (51-1000 emp.)
"Enterprise-Grade Power with Open-Source Flexibility—Plus an Intuitive PgAdmin UI"
5/5
What do you like best about PostgreSQL?

What I like best about PostgreSQL is how it combines power, reliability, and flexibility in one platform. Its SQL standards compliance, strong performance, advanced indexing, and support for both relational and JSON workloads make it suitable for everything from transactional apps to analytics platforms. From a UI/UX standpoint, it works well with excellent tools like pgAdmin and many third-party clients. In terms of integrations, it connects easily with BI tools, ETL pipelines, cloud platforms, and programming languages. For pricing / ROI, being open-source significantly lowers total cost while still delivering enterprise-grade capabilities. It also has a large community for support / onboarding, with abundant documentation and tutorials. On AI / Intelligence, its growing ecosystem for vector extensions and ML integrations makes it increasingly relevant for modern AI-driven applications.ern AI-driven applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I dislike about PostgreSQL is that while it is powerful, it can feel complex for new users. The UI / UX depends heavily on third-party tools rather than a polished native interface. In terms of performance, it may require careful tuning for very high write-volume workloads or large-scale horizontal scaling. Some integrations and enterprise features can need extra setup compared with fully managed commercial platforms. For support / onboarding, community resources are strong, but official hands-on vendor support is limited unless using a managed provider. On AI / Intelligence, capabilities often rely on extensions rather than built-in native features. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness
UH
Verified User in Health, Wellness and Fitness
Small-Business (50 or fewer emp.)
"The Secure Backbone for Critical Cyber Data Management"
5/5
What do you like best about PostgreSQL?

PostgreSQL's robust access control and row-level security make it an excellent choice for storing sensitive security data. Its reliability, ACID compliance, and extensive audit logging capabilities are critical when handling threat intelligence, incident records, or compliance data. The open-source nature means no vendor lock-in, and the active community ensures rapid security patches and updates Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL's initial configuration can be a security risk if not hardened properly out of the box — default settings are not always production-ready from a security standpoint. Managing encryption at rest requires additional setup and third-party tooling, unlike some commercial databases that offer built-in encryption solutions. Review collected by and hosted on G2.com.

Antonio M.
AM
Antonio M.
Analisa de BI
Mid-Market (51-1000 emp.)
"PostgreSQL: Reliable, High-Performance, and Packed with Advanced Features"
5/5
What do you like best about PostgreSQL?

What I like most about PostgreSQL is its reliability, performance, and flexibility. It supports advanced SQL features, handles complex queries efficiently, and offers powerful capabilities like JSON support, window functions, CTEs, and extensions. I also appreciate that it's open source, has a strong community, and integrates well with modern data engineering and analytics tools. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One common complaint is that PostgreSQL may require more manual performance tuning as databases grow, especially around autovacuum and indexing. Another is that horizontal scaling can be more challenging compared to some distributed database systems. Review collected by and hosted on G2.com.

Yogesh S.
YS
Yogesh S.
Software Engineer
Mid-Market (51-1000 emp.)
"The ultimate open-source workhorse for our relational data needs"
4.5/5
What do you like best about PostgreSQL?

We use PostgreSQL as the sole choice for practically every new service that we launch, and as a software engineer in a medium sized company, we'd love to do more but cannot do it. I'm most impressed by how reliable it is, and how much more it has to offer than standard SQL. The JSONB support is a godsend to us, because it allows us to have the flexibility of a NoSQL data model to our semi-structured data, without losing our strict ACID requirements of our transactional data. The extension ecosystem is also phenomenal. We can typically select an extension to easily incorporate geospatial functionality into PostGIS or time-series data into its time-series management utility, without having to try out a whole new database technology. It can easily process complex queries and concurrency heavy read and write without breaking a sweat and is open-source, so we are not faced with the licensing problems found with enterprise alternatives to it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's a great database, but it has its oddities. Managing connections has always been the most cumbersome task that irritates our staff. PostgreSQL runs a process for every connection, so if you're running a lot of microservices trying to connect to it in a short period, you can easily end up consuming a lot of memory. Although we had to come up with PgBouncer early on to deal with connection pooling, I hope that good connection pooling is integrated into the core system from the start. The other small complaint is about the autovacuum. With our very write-intensive tables, optimizing the auto-vacuum settings to not cause table bloating yet still maintain query performance was quite the process of trial, error, and mastering the documentation. When you begin scaling up, it will need a bit more hands-on knowledge of database administration than some of the managed, cloud-native databases. Review collected by and hosted on G2.com.

Axel U.
AU
Axel U.
Software Engineer
Computer Software
Small-Business (50 or fewer emp.)
"PostgreSQL: robust, flexible, and scalable, with ACID, JSONB, and powerful extensions"
5/5
What do you like best about PostgreSQL?

What I like most about PostgreSQL is the balance it achieves between robustness and flexibility. It offers reliable ACID transactions, strong referential integrity, and a powerful query optimizer. Additionally, it supports JSONB, advanced indexes, and extensions, allowing the combination of the relational model with semi-structured cases without the need to change engines. Overall, I find it a stable, scalable, and suitable option for both small projects and critical systems. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL may require more careful initial configuration and optimization compared to simpler databases. In teams without experience in tuning, indexes, and query planning, performance can degrade if the schema is not designed correctly from the start. Additionally, some advanced administrative tasks demand a deeper technical knowledge. Review collected by and hosted on G2.com.

Jignesh A. P.
JP
Jignesh A. P.
Delivery Manager
Mid-Market (51-1000 emp.)
"Powerful and reliable open-source database for scalable applications"
4.5/5
What do you like best about PostgreSQL?

PostgreSQL offers strong performance, reliability, and advanced SQL capabilities. Features like JSONB support, indexing options, window functions, and extensions make it highly flexible for both transactional and analytical workloads. It integrates well with modern stacks and handles large datasets efficiently while maintaining data integrity. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Initial configuration and tuning can be complex, especially for high-traffic systems. Some administrative tasks require deeper database knowledge, and horizontal scaling is not as straightforward compared to certain distributed databases. Review collected by and hosted on G2.com.

Questions about PostgreSQL? Ask real users or explore answers from the community

Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights.

Jay P.
JP
Jay Padhya
•
Last activity over 6 years ago

Can we get some video tutorials on usage? Also how do we connect them over cloud ?

Shruti N.
SN
Shruti Nair
•
Last activity 7 months ago

Most reliable relational database software for new businesses

Pricing Options

Pricing provided by PostgreSQL.

Basic

$0.01
With One-Time Purchase
PostgreSQL Comparisons
PostgreSQL Features
Storage
Availability
Stability
Data Schema
Query Language
Data Types
Operating Systems
Database Locking
Access Control