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 8

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.
Praneel Kumar P.
PP
Full time Research Scholar (Ph.D)
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Ability to manage database securely and easily, easy to integrate to several applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, so far everything is fine going Review collected by and hosted on G2.com.

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

Database management, backups and recoveries, easy administration and migration Review collected by and hosted on G2.com.

UDDAGIRI S.
US
Assistant System Engineering
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

I can store data in relational database in the form of tables, views and functions Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Inserting row providing explicit value for Primary key even though default value defind Review collected by and hosted on G2.com.

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

It help me to datawarehousing Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
AM
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

For the most part PostgreSQL performs well and does not catch you out too often. Various tuning options and ways to analyse performance so is not too tricky to keep it working well as you scale vertically. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of horizontal scaling options in the market make it tricky once you've either exhausted vertical scaling or are encountering issues with multiple read replicas. Review collected by and hosted on G2.com.

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

Need somewhere to store transactional data and that is what it does best Review collected by and hosted on G2.com.

MO
Innovation Manager
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is totally free; it has helped us to deploy our own web-based applications using RDBMS schemes; admin control is simple to deploy and maintain, it is also very well supported around the community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Currently we have not found anything to dislike about postgreSQL, coming from MySQL I think postgreSQL it is very straight forward to use, and we haven't had any issues with it. Review collected by and hosted on G2.com.

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

It has provided us a Relational DataBase Management System for our web applications, we are using python and flask framework for development, and it is very simple to connect PostgreSQL to SQLAlchemy Review collected by and hosted on G2.com.

Alejandro C.
AC
IT Head
Automotive
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is the most complete, safer, easier and more reliable database engine we use in the company. We administrate it through PG Admin, and we have allocated in the AWS instance. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's tricky if you have invalid objects to assign permissions to different users o groups. But once you delete or repair the invalid objects, everything becomes more accessible. It is the only thing that i dislike. Review collected by and hosted on G2.com.

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

Fastest access to my principal database schema. Secure the information of the company. Escalable trough the main support assistance. Easier to integrate with different apps. Review collected by and hosted on G2.com.

Shrijaya S.
SS
Senior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

Supports wide range of query syntax and best in terms if usability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Too many reserved keywords. With these many keywords we dont get to chosse meaningful column names due to reserved keyword restrictions. Review collected by and hosted on G2.com.

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

Helps store the data and is one of the best "structured query language" tools out there. Pretty versatile in supporting multiple formats of queries. Review collected by and hosted on G2.com.

Mansi M.
MM
Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like the best that it is widely used for enterprise software development, it has been in the industry for very long, thus it is reliable, robust and highly performant. It is fast and very easy to use. It also provides very detailed documentation along with detailed feature matrix for each version release. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing to dislike as such, but something that is very common in softwares is that latest version is never stable enough for production use. Review collected by and hosted on G2.com.

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

It is a very easy to use object relational database management system, it is powerful and provides support for backend, different data types, indexing, JSON, backup, restore, data integrity, and much more all just in one product. Review collected by and hosted on G2.com.

Mubeen A.
MA
SOC - Security Engineering Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is a very robust and tested relational database known for its simple implementation and great features like fault tolerance, self recovery and detailed logging capabilities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a very old relational database which is not very efficient, it has not aged well and the current technology relevance is very limited. It is slow, not compatible with modern applications and lacks proper support and documentation. Review collected by and hosted on G2.com.

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

PostgreSQL is part of ArcSight, one of the SIEM solutions we currently use. It is light-weight, easy to use and serves the purpose as there is no much operational overhead. Review collected by and hosted on G2.com.

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

I like its capability to handle multi vendors. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It takes more time to get hands on experience than other RDBMS Review collected by and hosted on G2.com.

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

Multi vendors handling, we are getting more from it. Review collected by and hosted on G2.com.

Shrijaya S.
SS
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic Review from User Profile
What do you like best about PostgreSQL?

Ease of use and too many features. Like the varchar limit is way more than we have in oracle Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It uses too much memory for processing complex queries Review collected by and hosted on G2.com.

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

Its helping us store data for our web application. Review collected by and hosted on G2.com.