PostgreSQL Reviews & Product Details

I like that PostgreSQL is free and open source. We can rely on it for scalability and ease of use, which saves a lot of money on database infrastructure. It's also very customizable, and we can run it on servers with minimal hardware configurations. Its advanced features allow us to have better control of our data sets, manage complex queries, and handle JSON more easily. The fact that we can contribute to its development gives us a sense of involvement and community. Review collected by and hosted on G2.com.

It's a bit slow compared to other specialized databases like MySQL or NoSQL databases for large data sets. Initial setup was a bit difficult because it was not supported for our legacy system hardware. Review collected by and hosted on G2.com.

PostgreSQL strikes a great balance between ease of use and depth of features. The initial setup and implementation are straightforward, and it integrates well with most programming languages, frameworks, and ORMs. I use it frequently because it offers rich features out of the box (CTEs, JSONB, full-text search, indexing options) without needing external add-ons. It’s very stable, reliable, and easy to scale once you get familiar with its ecosystem. Review collected by and hosted on G2.com.

The main challenge is that advanced tuning and optimization require expertise — features like partitioning, replication, or query optimization aren’t always beginner-friendly. Customer support depends heavily on community resources unless you opt for paid enterprise support, which might not suit smaller teams. GUI tools like pgAdmin are functional but not the most user-friendly compared to some commercial alternatives. Review collected by and hosted on G2.com.

This is one of my favorite databases. It allows me to get set up fast and handle any workload. I love using it with Prisma, I love using it with Ruby on Rails and all my projects. I don't think there's even a project that I use without it. Review collected by and hosted on G2.com.

Don’t have any dislikes at this point in time Review collected by and hosted on G2.com.

I use PostgreSQL for every project, from small to large, as it integrates well with my back-end REST and GraphQL APIs. I really like how it allows me to perform advanced SQL queries beyond just the normal ones. The advanced analytical features in PostgreSQL is very useful for my projects. I also love that it allows me to work with JSON objects, simplifying tasks related to both NoSQL-like use cases and SQL databases. Review collected by and hosted on G2.com.

Scaling and operational aspects could be better, as it's doable but could be much more straightforward. Also, much more customization should be there. Review collected by and hosted on G2.com.

Postgres is known for being super stable.

It don’t easily lose data, and it handle crashes very well.

For big, serious applications, this is very helpful. Review collected by and hosted on G2.com.

If your app is super basic (just simple reads), MySQL can be faster.

Postgres focus more on accuracy and complex queries, so sometimes speed feel a bit slower for small things. Review collected by and hosted on G2.com.

PostgreSQL offers exceptional reliability and flexibility for both transactional and analytical workloads. I appreciate its strong ACID compliance, robust indexing strategies, and the ability to handle complex queries efficiently. The open-source ecosystem is very mature, and extensions like PostGIS and pgAdmin make it a versatile tool. Performance tuning and horizontal scaling are well-documented, and its integration with .NET, Node.js, and cloud providers (AWS RDS, Azure Database) is seamless. Review collected by and hosted on G2.com.

While PostgreSQL is extremely powerful, it can be intimidating for newcomers. Some advanced configurations—like connection pooling or query planner tuning—require deep database knowledge. The learning curve for replication and failover setup is also steep, and GUI tools are not as intuitive as those for MySQL or SQL Server. However, once mastered, its capabilities easily outweigh the initial challenges. Review collected by and hosted on G2.com.

1) Open-source and free

2) Highly reliable and ACID compliant

3) Supports complex queries and JSONB

4) Extensible (custom types, functions, extensions)

5) Strong concurrency with MVCC

6) Cross-platform and cloud compatible

7) Advanced security features

8) Good scalability and replication

9) Large and active community Review collected by and hosted on G2.com.

1) Slower for simple read-heavy workloads

2) Requires manual tuning for performance

3) Replication/sharding setup is complex

4) Steeper learning curve

5) Higher memory and disk usage

6)Fewer managed hosting options Review collected by and hosted on G2.com.

The robustness with which the data is handled, the ease of managing tables, in addition to the fact that several database GUIs integrate easily to manage all the information handled within PostgreSQL. Review collected by and hosted on G2.com.

It is somewhat slow in its performance, as for small databases it would be better to use another relational database manager. Review collected by and hosted on G2.com.

What truly distinguishes PostgreSQL for me is its reliability and data integrity. After more than five years of using it in production environments, I can say it has never failed me. Its ACID compliance is exceptionally robust, and the way it manages concurrent transactions continues to impress. I also value its extensive feature set, such as JSONB support, full-text search, and the ability to extend functionality with custom functions and types. The community is another strong point—whenever I encounter an edge case, I can usually find a well-documented solution or a helpful discussion in the mailing lists. Review collected by and hosted on G2.com.

The learning curve can be quite steep for newcomers, particularly when it comes to grasping the nuances of vacuum and autovacuum tuning to achieve optimal performance. Managing configurations across various environments demands close attention, as the default settings are not always suitable for production workloads. While replication is a strong feature, its setup tends to be more complicated than with some other options. Review collected by and hosted on G2.com.

PostgreSQL is the most abstract form of relational databases that provides ease of normalization, handling multiple databases, and transactions. All ACID properties can easily be applied, and it provides tools, an easier way to automate tasks.

Great Customer Support.

APIs, adapters, and interfaces are readily available for integration. Review collected by and hosted on G2.com.

Slow performance for large databases and complex queries.

No horizontal scaling.

No Columnar storage of tables and no optimal indexing and sharding.

Beginner unfriendly for introduction to RDBMS. Review collected by and hosted on G2.com.