Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 6

PostgreSQL Overview

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL Details
Show LessShow More
Product Description

PostgreSQL is a powerful, open source object-relational database system.


Seller

PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:
008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

Recent PostgreSQL Reviews

Biruk T.
BT
Biruk T.Mid-Market (51-1000 emp.)
5.0 out of 5
"Robust PostgreSQL support with enterprise grade features"
EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integra...
Verified User
U
Verified UserSmall-Business (50 or fewer emp.)
5.0 out of 5
"PostgreSQL:"
Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in J...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

637 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
637 PostgreSQL Reviews
4.4 out of 5
637 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Kwabena A. B.
KB
IT Professional
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgresSQL shines as an enterprise RDBMS. It has all the enterprise features of a modern database management system, yet it is free and open source. It can handle a data intensive system very well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is really difficult to talk about any dislike about PostgreSQL, however it has a bit of a learning curve. Also, installation and configuration on a linux platform is a bit complicated. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL is serving as a backend database for our laboratory information management system. We have also deployed it as a database for our institutional repository system. Review collected by and hosted on G2.com.

RL
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

-Scalability and Performance: PostgreSQL can handle high-volume workloads and scale to large datasets.

-Cross-Platform Compatibility: PostgreSQL runs on multiple platforms, including Linux, macOS, and Windows. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Configuration and Performance Tuning: Optimizing performance in PostgreSQL can be challenging, particularly for complex workloads and large datasets.

-Upgrade Process: Upgrading PostgreSQL to newer versions may require careful planning and testing, as it involves migrating data and ensuring compatibility with existing applications and extensions. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL solves several problems in the realm of data management:

-Data Integrity and ACID Compliance: PostgreSQL implements ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring data integrity and reliability.

-Data Integration and Interoperability: PostgreSQL supports integration with other systems and tools.

-Scalability and Performance: PostgreSQL offers scalability and handles high-volume workloads effectively. Review collected by and hosted on G2.com.

Akash N.
AN
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

Postgresql is a platform that shares unlimited sources accessible to every user. Its user-friendly features make it easy for beginners to understand its functionalities.

Whether maintaining or exploring new databases or setting up your database from scratch, Postgresql is one of the best tool user can rely upon! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While merging or blending data from different sources a few times, PostgreSQL lags or fails the first time, which can be a con for the platform, other than all other features work smoothly! Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Users can maintain their databases, make changes, store them, and use them for analyzing trends or research. And with its ease-of-use features, it is one of the best platforms for DBMS. Review collected by and hosted on G2.com.

Vladimir T.
VT
Ingeniero y Desarrollador
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Reliable: Even when there is no space in disk or with some hardware errors it can recover. Fast --it requires optimizing but it gives the tools to optimize. Open Source. Periodicaly updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For me that it uses Sql is a plus. But I guess for people who doesn't know Sql it may be hard, but it iw worth to learn it. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Keeping millions of records of clients integrally, reliabily and fast. Review collected by and hosted on G2.com.

Paresh K.
PK
Junior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The main plus point about PostgreSQL is that it's an open-source R-DBMS that is very reliable, making it a first choice for startups and other organizations. Also, it has gained a high reputation for its high performance while handling high volumes of datasets very efficiently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One thing I feel that's a downside in PostgreSQL is that its GUI functionality is very limited and not that user-friendly, making it challenging for first-timers to use its complete functionalities, especially when they are not used to the command-line interface. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL helped us while working on a web application as the backend database management system, which was built on top of Java the main reason I chose this was that it was open-source and had a vast community, which was needed when we got stuck in some problem. Also because of the flexibility and its performance, it was the best option for us. Review collected by and hosted on G2.com.

Stefano A.
SA
Direttore Ricerca & Sviluppo
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
Rating Updated ()
What do you like best about PostgreSQL?

High compatibility with Oracle SQL and Oracle PL/SQL. With very few changes, you are able to migrate an Oracle Database to PostgreSQL. There are also a good choice for what concern high availability and load balancing solutions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is able to manage JSON data with native datatype and APIs. But if you need to query datasets over 10 Gbytes of raw data, consider transforming JSON documents to normalized tables because queries may have time-out issues. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Currently, PostgreSQL is solving the problem of not having the high cost of an Oracle Database installed on-premises. And it also solved the problem of having to rewrite all the PL/SQL code written in another language. Review collected by and hosted on G2.com.

Shubhi S.
SS
ETL Developer - Talend
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

It is open source and freely available, partitioning concept, sql compatibility , support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

upgrade process support, complexity on performance tuning Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Helping in Relational Data Management, performance optimization and partitioning on nodes Review collected by and hosted on G2.com.

Yan A.
YA
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It has a rich and mature feature set where things like referential integrity weren't an afterthought (compared to MySQL). Documentation is also excellent, and modern ANSI SQL syntax is well supported. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's not as widespread as MySQL is, so it can be harder to find people that are strong DBA skills or know the specifics of its internal workings, but it isn't that bad either. It's not like it's some unknown DBMS either, it's simply not as widespread as MySQL. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

It allows us to store all of our application's data in a resilient and secure way and be accessible with standard programming languages and development tools such as Java, NodeJS, etc. Review collected by and hosted on G2.com.

Vivek D.
VD
Associate Technical Engineer I
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL provides an open-source environment to all users. It's easy to use and easy to understand it's functionality. Creating your own data set for testing or exploring new data set both work in the best way. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is good for beginners but its integration parts didn't work properly. Such as JSON data or others. PostgreSQL needs to work on the integration part of this tool. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We save data sets in tables and later explore data sets with the help of PostgreSQL. It makes the data analysis part easy and gives the required result with less effort. Easy working makes it the best. Review collected by and hosted on G2.com.

Ayesh  N.
AN
Senior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Since this is an open-source product, this really helps with day-to-day database development. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't really like the user interface, compared to other popular products like SSMS. Sometimes the UI lags. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Overpriced services. Review collected by and hosted on G2.com.